How to save datagridview checkbox column in c# window app

Question

Hai In my project I want to save datagridview checkbox column  here am using c# windows application . How can I save this in my projet Please anybody suggest an Idea to solve this problem. Thanks in advance.

Pavithra L · Answer

Thank you.

Ajay Saini · Answer

Ok great. Thank you.

Pavithra L · Answer

Hai I got my answer just am changed the datatype as bit. It was save and retrieve the answer correctly. Thank you for your reply.

Ajay Saini · Answer

Did you check my sample which i have attached for you?

Pavithra L · Answer

In my project am using c# windows based application Here i can select the datagridviewcheckboxcolumn as select and save using save button. After finished the save I want to retrieve the data. While am using retrieve query it will not work properly. It was shown the true or false in works Here i want to display the (tick)Checked or unchecked option in datagridview .How to do this. I want to write this retrieve query in textbox1_Textchanged event. How to do this . I just simply show the selected options in datagridview. How can I do this thanks for your reply.... Here is my code  Please refer this I wrote this in textbox_Textchanged event dataGridView1.Columns[12].DataPropertyName = Knitting; dataGridView1.Columns[13].DataPropertyName = Heat_Set; dataGridView1.Columns[14].DataPropertyName = Dyeing; dataGridView1.Columns[15].DataPropertyName = Dryer; dataGridView1.Columns[16].DataPropertyName = Tumble; dataGridView1.Columns[17].DataPropertyName = Shearing; dataGridView1.Columns[18].DataPropertyName = Raising; dataGridView1.Columns[19].DataPropertyName = Stenter; displaydata(); private void displaydata() { dt3 = new DataTable(); SqlDataAdapter da3= new SqlDataAdapter(selectJob_NoCustomerPO_NoO_NoFabricBlendColourGSMF_WidthOrder_QtySplit_QtyDye_QtyKnittingHeat_SetDyeingDryerTumbleShearingRaisingStenter from Finishing_Production WHERE V_No=' + textBox1.Text + ' GROUP BY Job_NoCustomerPO_NoO_NoFabricBlendColourGSMF_WidthOrder_QtySplit_QtyDye_QtyKnittingHeat_SetDyeingDryerTumbleShearingRaisingStenter con1); da3.Fill(dt3); dataGridView1.DataSource = dt3; }

Ajay Saini · Answer

Hi Pavithra I am sharing a demo which i have created as per your requirement whatever i understand please have a look and try as per your requirement. Just include the page and try by Typing Column values as Value0 or Value1.... please note the case sensitive of Value.... Please let me know if it works for you.

Pavithra L · Answer

Hai Am using your code but it was shown the same error in datagridviewcheckboxcolumn. I don't know how to solve this in my project. Please suggest any idea. Here am using this code for retrieve the data in Textbox_Textchanged event:Kindly refer this code private void textBox1_TextChanged(object sender EventArgs e) { dataGridView1.Columns[12].DataPropertyName = Knitting; dataGridView1.Columns[13].DataPropertyName = Heat_Set; dataGridView1.Columns[14].DataPropertyName = Dyeing; dataGridView1.Columns[15].DataPropertyName = Dryer; displaydata(); } private void displaydata() { dt3 = new DataTable(); SqlDataAdapter da3 = new SqlDataAdapter(select KnittingHeat_SetDyeingDryer from Finishing_Production WHERE V_No=' + textBox1.Text + ' GROUP BY KnittingHeat_SetDyeingDryer con1); da3.Fill(dt3); dataGridView1.DataSource = dt3; } Please tell me anyother idea. Thanks for your reply

Ajay Saini · Answer

Hi Pavithra Now it is clear to me. Please use following code piece hope it works for you... After providing datasource to your datagridview... dataGridView1.DataSource = dt; for (int i = 0; i { if (dataGridView1.Rows[i].Cells[Col2].Value.ToString().Trim() == Value1) { //To check uncheck your CheckBox dataGridView1.Rows[i].Cells[Col1].Value = true; } } above is just for your reference make changes as per your requirement. ------------------------------------------------------------------------------------------ Please mark as Answer if it works for you.

Pavithra L · Answer

Hai Yeah you are right. But I don't know how to use databindingcomplete event . Will you please explain briefly. Thanks for your reply. Please give me an idea to overcome this problem.

Ajay Saini · Answer

You mean you are able to save the checked values and want to retrieve that with check/uncheck the corresponding checkboxes? If not then i am not able to relate please share more details and in same time you can try DataBindingComplete event of datagridview to check/uncheck checkboxes as per the condition.

Pavithra L · Answer

Hai How can I retrieve the saved data including this datagridcheckbox column value??? Give me any idea.

Ajay Saini · Answer

Hope this works... private void dataGridView1_CellContentClick(object sender DataGridViewCellEventArgs e) { DataGridViewCheckBoxCell checkbox = (DataGridViewCheckBoxCell)dataGrid_ModelControls.CurrentCell; bool isChecked = (bool)checkbox.EditedFormattedValue; }