checkbox eventhandler visual c# 2008

[sarabonn]

Hello everyone,

Iam firing a event in the chechbox_checke dchanged. It works fine

 private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            /
                textBox1.Visible = false;
                textBox2.Visible = false;
                button2.Visible = false;
 
                String connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + datapath + "'";
 
                using (OleDbConnection connection = new OleDbConnection(connectionString))
                {
                    OleDbCommand command = new OleDbCommand("select * from userinfo WHERE ServerUrl='" + temp + "'", connection);
 
                    connection.Open();
                    OleDbDataReader reader = command.ExecuteReader();
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            String rea = reader[0].ToString();
                            String reb = reader[1].ToString();
                            MessageBox.Show("Username and Password are Matching Click ok to continue ..");
                            groupBox2.Visible = false;
                            groupBox1.Visible = false;
                            groupBox3.Visible = true;
                            checkBox1.Checked = false;
                            newop(rea, reb, out res1, out res2);
                        }
                    }
                    else
                    {
                        MessageBox.Show("No Record please provide username and pwd");
                        groupBox2.Visible = true;
                        textBox1.Visible = true;
                        textBox2.Visible = true;
                        button2.Visible = true;
                        checkBox1.Checked = false;
                        groupBox1.Visible = false;
                    }
                    reader.Close();
                    connection.Close();
                }
  }
 

The problem after this event when i make the checkbox visible the checkbox is in checked state. so if i make the checkbox.checke dstate= false automatically the else part in the chekedchanged event is triggering i know why it is happening?.. what are the other ways i can make the checkbox in unchecked state without firing this eventhandler or should i write the code in someother handler event of checkbox ?..

Thank you.

Dinesh.

[sarabonn]

Hello everyone,

Iam firing a event in the chechbox_checke dchanged. It works fine

 private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
 
                textBox1.Visible = false;
                textBox2.Visible = false;
                button2.Visible = false;
 
                String connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + datapath + "'";
 
                using (OleDbConnection connection = new OleDbConnection(connectionString))
                {
                    OleDbCommand command = new OleDbCommand("select * from userinfo WHERE ServerUrl='" + temp + "'", connection);
 
                    connection.Open();
                    OleDbDataReader reader = command.ExecuteReader();
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            String rea = reader[0].ToString();
                            String reb = reader[1].ToString();
                            MessageBox.Show("Username and Password are Matching Click ok to continue ..");
                            groupBox2.Visible = false;
                            groupBox1.Visible = false;
                            groupBox3.Visible = true;
                            checkBox1.Checked = false;
                            newop(rea, reb, out res1, out res2);
                        }
                    }
                    else
                    {
                        MessageBox.Show("No Record please provide username and pwd");
                        groupBox2.Visible = true;
                        textBox1.Visible = true;
                        textBox2.Visible = true;
                        button2.Visible = true;
                        checkBox1.Checked = false;
                        groupBox1.Visible = false;
                    }
                    reader.Close();
                    connection.Close();
                }
  }
 

The problem after this event when i make the checkbox visible the checkbox is in checked state. so if i make the checkbox.checke dstate= false automatically the else part in the chekedchanged event is triggering i know why it is happening?.. what are the other ways i can make the checkbox in unchecked state without firing this eventhandler or should i write the code in someother handler event of checkbox ?..

Thank you.

Dinesh.

[cloud255]

Hi

By reading your code it seems that you only want to execute this section if the check box is checked (in both the if and else you set the checked to false).

a work around might be to check if the textbox is checked before executing the code:

if(checkbox1.checked == true)
{
  //execute code
}
else
{
  return;
}

if indeed you want the code to execute each time the checked state changes, i suggest you use a Boolean variable (not inside the event handler scope) to perform a similar task as described above. Neither of these methods is optimal as they both cause the event to fire more than once per user interaction.

Ultimately i would suggest that you use a command button to execute code that reads from the database, but that is a personal preference in design choice.

Good luck

[Frinavale]

Add an if statement around your whole code checking if the checkbox is checked before executing the call to the database.

If it's not checked, don't do anything.
If it is, execute the code.

[tlhintoq]

[edit] Threads have been merged[/edit]

By the way, another technique for your need to would be to disconnect the event, change the checkbox, then reconnect the event.

.... -= new eventhandler ......
mycheckbox.chec ked = false;
... += new eventhandler ....