How to retrieve datagridviewchexkbox value in c# windows app

Pavithra L

11y946.NET

Hai,

In my project am I using datagridviewcheckbox , I can save this datagridviewcheckbox value in database, Here I can retrieve the checkbox value in the same datagridviewcheckbox .

Am using c# windows application. Please give me any idea to solve this problem.

Thanks in advance.

8 Replies

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

Pavithra L11y ago
Hai,

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
Raja T11y ago
Hi, try like

private void button2_Click(object sender, EventArgs e)
{
   foreach (DataGridViewRow row in dataGridView1.Rows)
   {
      if (Convert.ToBoolean(row.Cells[1].Value))
      {
         // what you want to do
      }
   }
}
0
Pavithra L11y ago
Hai,

I don't want to add the checkbox column in datagridview, I just want to retrieve the checked or unchecked status from database table on the current position of the datagridviewcheckboxcolumn. How can I do this in my project kindly suggest any Idea to solve this issue, Please It'urgent.Anybody give me an idea for this.

Thanks in advance.
0
Munesh Sharma11y ago
http://www.aspsnippets.com/Articles/Add-CheckBox-Column-to-DataGridView-in-Windows-Forms-application-using-C-and-VBNet.aspx
0
Pavithra L11y ago
Hi there,

The checkbox column in my database either has two values, checked or unchecked. Now what I want to do is I have a form where I can view data. That form displays all the data that is selected from a datagridview. The checkbox value must be displayed in checkboxes.
Here am using checkboxcolumn in datagridview, How can I view the check or uncheck status while retrieve the data's in my project.

Thanks in advance.
0
Pavithra L11y ago
But its not working , Please tell me other Idea's to solve this problem .
Please help me quickly its urgent.

Thank you for your reply.
0
Krishna Rajput Singh11y ago
Hello Pavithra L Thanks for writing i hope below link helpful plz correct as accept answer

https://msdn.microsoft.com/en-us/library/bb397491(v=vs.90).aspx
http://stackoverflow.com/questions/19447349/get-datagridview-checkbox-value-after-changed

https://social.msdn.microsoft.com/forums/windows/en-us/31c7a954-1a85-4c38-9e9f-e157d33faf0b/how-to-get-the-value-of-checkbox-in-the-datagridview
0
Raja T11y ago
Hi, Please check out bellow urls

http://www.c-sharpcorner.com/UploadFile/deveshomar/adding-checkbox-column-in-datagridview-in-C-Sharp-window-forms/

http://www.aspsnippets.com/Articles/Add-CheckBox-Column-to-DataGridView-in-Windows-Forms-application-using-C-and-VBNet.aspx

http://www.codeproject.com/Questions/560439/datagridviewpluscheckplusboxpluscolumn
0