Problem with checkbox in bindingNavigator

Question

Hello I have a checkbox in a databindingNavigator. How can i get its state? In my database i have a field call checked(nvarchar) that gets value 1 if checkbox is checked and 0 if unchecked. I get that value in a textfield so i have the following: Textbox temp_check=new Textbox(); temp_check.Databindings.Add(TextbindSourceCHECKED); if (temp_check.Text==1) check1.CheckState=System.Windows.Forms.CheckState.Checked; else check1.CheckState=System.Windows.Forms.CheckState.Unchecked; My problem is that with the above code i set checkbox to checked/unchecked for all records not only the specific. How can i connect it to my bindingNavigator? Thank you in advance.

Dealy · Answer

Is there someone who can help me with this? Thank you.

Dealy · Answer

If you find some time please check my code it's an example with Northwind database. public void select_orders(String CustID) { string connectionString = @Server=LOC; Initial Catalog=Northwind; Integrated Security=True; using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand(SELECT_ORDERS conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter(@CustomerID CustID)); conn.Open(); //Fill The DataTable From Command SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); //Set It To Binding Navigator BindingSource itmBindSource = new BindingSource(); itmBindSource.DataSource = dt; itmBindNavigator.BindingSource = itmBindSource; itmBindNavigator.Dock = DockStyle.Bottom; TextBox temp_checked = new TextBox(); temp_checked.DataBindings.Add(Text itmBindSource ShipPostalCode); if (temp_checked.Text != null) checkBox1.CheckState = System.Windows.Forms.CheckState.Checked; else checkBox1.CheckState = System.Windows.Forms.CheckState.Unchecked; custID_txt.DataBindings.Add(Text itmBindSource CustomerID); shipRegion_combo.DataBindings.Add(SelectedValue itmBindSource ShipRegion); freight_txt.DataBindings.Add(Text itmBindSource Freight); } } Thank you :)

Roei Bar · Answer

well my friend its a bit late for me but if you want send me the project you have built and i will have the fixed code for you once i wake up :-)

Dealy · Answer

Thank you for your quick answer I'm not sure i understood though can you give me an example of how the checkbox works with position? Thanks again

Roei Bar · Answer

you can use the position property of the bindingNavigator // gets or sets the index of the current item. int pos = this .customersBindingSource1.Position; and use it on the next command to update or insert a new row or whatever you feel like ;-) hope this helps