Problem with checkbox in bindingNavigator

Dealy

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("Text",bindSource,"CHECKED");

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.

5 Replies

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

Dealy17y ago
Is there someone who can help me with this?

Thank you.

Dealy17y ago

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 Bar17y ago
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 :-)
Dealy17y ago
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 Bar17y ago

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