How to save data for checkbox selected in gridview?

Question

i am having one gridview and check box for each row of gridview if i click on some checkbox and click save button only checkbox which r clicked those data has to go in database.

How can i do this please help

kianu rieves · Answer

I think you can use Session object and use hash table to cache (id and object) so that you can handle checkbox (checked/uncheck). write code on page change event. Remove all unchecked records from hashtable if exists and add (update if exists) the checked record to hashtable. and finally save it all. http://www.dapfor.com/en/net-suite/net-grid/features/performance

Dorababu Meka · Answer

Check here once http://stackoverflow.com/questions/1008582/invalidoperationexception-when-calling-savechanges-in-net-entity-framework

Dorababu Meka · Answer

Issue resolved?

nallya · Answer

Thanks For Helping me

Dorababu Meka · Answer

I am not having much idea regarding Entity framework but try this if you have a bindingsource bound you should call the suspendbinding: bs.SuspendBinding(); ent1 .SaveChanges(); bs.ResumeBinding(); anyways your task is to save checked records to DB that resolved i think so.. The remaining part of code you have to do

nallya · Answer

Entity ent1 = new Entity(); foreach (GridViewRow row in gv1.Rows) { CheckBox chk = (CheckBox)row.FindControl(chkdelete); if (chk.Checked==false) { ATTENDENCE attend = new ATTENDENCE(); { attend.EMPID =Convert.ToInt32( gv1.Rows[row.RowIndex].Cells[1].Text); attend.EMPNAME = gv1.Rows[row.RowIndex].Cells[2].Text; }; ent1.ATTENDENCEs.AddObject(attend); ent1.SaveChanges(); } } Using in entity framework EntityName= Entity TableName= ATTENDENCE

Dorababu Meka · Answer

Can you post your insert code what you have written

nallya · Answer

Now the data is going to db BUT i have to do if(chk.Checked==false) though i am cheking check box and data going in db on button click anyhow if u r cheking any check box or not(doesn't matter) at last giving exeption The changes to the database were committed successfully but an error occurred while updating the object context. The ObjectContext might be in an inconsistent state. Inner exception message: AcceptChanges cannot continue because the object's key values conflict with another object in the ObjectStateManager. Make sure that the key values are unique before calling AcceptChanges.

Dorababu Meka · Answer

Check this code foreach (GridViewRow row in GridView1.Rows) { CheckBox chk = (CheckBox)row.FindControl(Yourcheckboxname); if(chk.Checked) { string id = GridView1.Rows[row.RowIndex].Cells[0].Text; //emp id string frstName= GridView1.Rows[row.RowIndex].Cells[1].Text; //FIRSTNAME } }

nallya · Answer

getting the error while building : 'System.EventArgs' does not contain a definition for 'RowIndex' and no extension method 'RowIndex' accepting a first argument of type 'System.EventArgs' could be found (are you missing a using directive or an assembly reference?)

Dorababu Meka · Answer

Try this foreach (GridViewRow row in GridView1.Rows) { CheckBox chk = (CheckBox)row.FindControl(Yourcheckboxname); if(chk.Checked) { string id = GridView1.Rows[row.RowIndex].Cells[1].Text; //emp id string frstName= GridView1.Rows[row.RowIndex].Cells[2].Text; //FIRSTNAME } }

Dorababu Meka · Answer

ok try this if any errors let me know foreach (GridViewRow row in GridView1.Rows) { CheckBox chk = (CheckBox)row.FindControl(Yourcheckboxname); if(chk.Checked) { string id = gv1 .Rows[e.RowIndex].Cells[1].Text; //emp id string company = gv1 .Rows[e.RowIndex].Cells[2].Controls[0].Text; // FIRSTNAME } } change the Cells values based on your binded item you have on gridview

nallya · Answer

it is coming from the database with query: var query = from payroll_employee in ent.PAYROLL_EMPLOYEE select new { EmpID = payroll_employee.EMPID EmpName = payroll_employee.FIRSTNAME }; gv1.DataSource = query; gv1.DataBind();

Dorababu Meka · Answer

WHat is the other data you have other than check box

nallya · Answer

Width=100px /> on the button click i want to store the data(for checked row ) into database

Dorababu Meka · Answer

What didn't worked. Why I am using label ? I just posted the sample code to access the controls inside gridview. If you are not having labels post the design of your gridview. Also make sure that you have binded your grid view in page load under if(!IsPostBack) { // your gridview bind code } If not you will always get a negative result even if you checked a check box

nallya · Answer

This is not working. I also used debugger it leaves the code at line if(chk.Checked) why u used (label) here string strDummy= (( Label )row.FindControl(yourcolumnname)).Text;

Dorababu Meka · Answer

Try this code in your button click or other foreach (GridViewRow row in GridView1.Rows) { CheckBox chk = (CheckBox)row.FindControl(Yourcheckboxname); if(chk.Checked) { //access values as follows string strDummy= ((Label)row.FindControl(yourcolumnname)).Text; // like this access the remaining controls that you need // your code to save the data } }