How to retrieve datagridviewchexkbox value in c# windows app

Question

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.

Pavithra L · Answer

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_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; }

Raja T · Answer

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 } } }

Pavithra L · Answer

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.

Munesh Sharma · Answer

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

Pavithra L · Answer

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.

Pavithra L · Answer

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.

Krishna Rajput Singh · Answer

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

Raja T · Answer

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