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

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

How to retrieve datagridviewchexkbox value in c# windows app

Answers (8)