How to save datagridview checkbox column in c# window app

Pavithra L

11y1.3k.NET

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.

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pavithra L11y ago
Thank you.
0
Ajay Saini11y ago
Ok, great.

Thank you.
0
Pavithra L11y ago
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.
0
Ajay Saini11y ago
Did you check my sample which i have attached for you?
0
Pavithra L11y ago
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;
}

0
Ajay Saini11y ago
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.
0
Pavithra L11y ago
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

0
Ajay Saini11y ago
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 < dataGridView1.RowCount - 1; 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.
0
Pavithra L11y ago
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.
0
Ajay Saini11y ago
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.
0
Pavithra L11y ago
Hai,

How can I retrieve the saved data including this datagridcheckbox column value???

Give me any idea.
0
Ajay Saini11y ago
Hope this works...

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