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_No,Customer,PO_No,O_No,Fabric,Blend,Colour,GSM,F_Width,Order_Qty,Split_Qty,Dye_Qty,Knitting,Heat_Set,Dyeing,Dryer,Tumble,Shearing,Raising,Stenter from Finishing_Production WHERE V_No='" + textBox1.Text + "' GROUP BY Job_No,Customer,PO_No,O_No,Fabric,Blend,Colour,GSM,F_Width,Order_Qty,Split_Qty,Dye_Qty,Knitting,Heat_Set,Dyeing,Dryer,Tumble,Shearing,Raising,Stenter", 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 Knitting,Heat_Set,Dyeing,Dryer from Finishing_Production WHERE V_No='" + textBox1.Text + "' GROUP BY Knitting,Heat_Set,Dyeing,Dryer", 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; }

How to save datagridview checkbox column in c# window app

Answers (12)