Sql to CheckBox || checkbox situation on button if/else (C#)

Question

Thank You guys!!! really!! checkbox situation on button if/else (solved)

but how can i transfer a sql situation e.x True/false to checkbox. Or if there is another way to do this: When i open a winform i want to keep in memory what was my checkbox condition.

Assuming that the id column is unique, then you need to use `ExecuteScalar` — Yacoub Massad, Jan 30 '16 at 22:00
Please find your solution in the revision history and post it as an answer of its own, thank you. — Cœur, Jul 18 '18 at 13:56

score 2 · Accepted Answer · edited May 23 '17 at 12:15

You need to use the ExecuteScalar method like this:

SqlCommand cmd = new SqlCommand("select rent_panel from parameters where id= '1'", con);

con.Open();

bool rent_panel = (bool)cmd.ExecuteScalar();

if (rent_panel == true) 
{
    //..
}
else
{
    //..
}

Please note that based on your question, I am assuming that the rent_panel column is of type bit (it can be either true or false).

I am assuming also that the id column has unique values (it is the primary key, right?)

Side note: you should always dispose your connection and command objects using the using keyword. Take a look at this answer.

score 0 · Answer 2 · answered Jan 30 '16 at 22:19

SqlConnection con = new SqlConnection("Your Data Source");
SqlCommand cmd = new SqlCommand("select rent_panel from parameters where id= '1'", con);
con.Open();
bool rent_panel = (bool)cmd.ExecuteScalar();
if (rent_panel)  //(rent_panel == true) 
{
//..
}
else
{
    //..
}
con.close();

Sql to CheckBox || checkbox situation on button if/else (C#)

2 Answers2