c# enable button based on mysql value

Question

I would like to know how to enable button based on mysql value.

I have database called database. Inside database table users and row uploader (varchar(45)) text in row is "True".

Here is my code ... but it doesn't work. Any solution would be great.

try
{
    string myConnection = "datasource=localhost;port=3306;username=root;password=pass";
    MySqlConnection myConn = new MySqlConnection(myConnection);

    MySqlCommand SelectCommand = new MySqlCommand("select uploader from database.users where username='" + c.username_txt.Text + "' ;", myConn);
    MySqlDataReader myReader;
    myConn.Open();
    myReader = SelectCommand.ExecuteReader();
    while (myReader.Read())
    {
        Console.WriteLine(myReader.GetString(myReader.GetOrdinal("uploader")));
    }
    string uploader = Console.ReadLine();
    if (uploader == "True")
    {
        uploadToolStripMenuItem.Enabled = true;
    }
    else
        myConn.Close();
}
catch (Exception ex)
{
    MessageBox.Show(ex.Message);
}

What do you mean it doesn't work? Any exception or error message? — Soner Gönül
– Soner Gönül, Commented Oct 22, 2013 at 14:09
you should really put your connection in a using statement. This would handle the closing of the connection, even if there is an exception. — Squirrel5853
– Squirrel5853, Commented Oct 22, 2013 at 14:10
And please use parameterized queries. Also use using statement for your connections. — Soner Gönül
– Soner Gönül, Commented Oct 22, 2013 at 14:10
if (uploader == "True") it's possible this case-sensitive comparison is failing, depending on what's in your database. You really should store boolean values if it's a boolean field. — Preston Guillot
– Preston Guillot, Commented Oct 22, 2013 at 14:11

Nicolas Straub · Accepted Answer · 2013-10-22 14:18:31Z

1

if (uploader == "True")
{
    uploadToolStripMenuItem.Enabled = true;
}
else
{
    myConn.Close();
    uploadToolStripMenuItem.Enabled = false
}

if uploadToolStripMenuItem is already enabled and you want it disabled when uploader != "True", then you have to disable it explicitly. Something else about your code, uploader won't be assigned any data from the table, but user input from the console (CLI), which doesn't make much sense since your working with buttons (GUI). to assign the value of the database call to the var, and keep the code like it is, do:

string uploader;
while (myReader.Read())
{
    uploader = myReader.GetString(myReader.GetOrdinal("uploader"))
    Console.WriteLine(uploader);
}

this will set uploader to the value of the uploader column in the last row

answered Oct 22, 2013 at 14:18

Nicolas Straub

3,4096 gold badges24 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

c# enable button based on mysql value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related