Assign Sql Query Result To Variable

Question

I have a MySql database and I want to assign sql query result to a variable. How can I do this?

My query:

sql = "SELECT rol FROM users WHERE user = '" + txtUser.Text + "'"

Start reading about ADO.NET. Also google for 'query database with C#' — Sergey Berezovskiy
– Sergey Berezovskiy, Commented Mar 15, 2014 at 19:44
@SergeyBerezovskiy: Yes. Other than the OP you are not Lazy anymore! — Olivier Jacot-Descombes
– Olivier Jacot-Descombes, Commented Mar 15, 2014 at 19:46
Out of topic, but you should try to find something about SQL Injections — Rudis
– Rudis, Commented Mar 15, 2014 at 19:47

Sudhakar Tillapudi · Accepted Answer · 2014-03-15 20:00:11Z

2

void AssignValue()
{
    using(MySqlConnection con =new MySqlConnection("/*connection string here*/"))
    using(MySqlCommand command = new MySqlCommand("SELECT rol FROM users WHERE 
                                 user = @user",con))
    {
      con.Open();
      command.Parameters.AddWithValue("@user",txtUser.Text);        
      TextBox2.Text = commad.ExecuteScalar().ToString();        
    }
}

edited Mar 15, 2014 at 20:00

answered Mar 15, 2014 at 19:47

Sudhakar Tillapudi

26.3k5 gold badges43 silver badges70 bronze badges

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

3 Comments

Olivier Jacot-Descombes Over a year ago

The command parameters are a good point. Better enclose the connection in a using statement. This ensures that it will be closed, even if an exception occurs.

Alex Over a year ago

Error 1 The name 'roleName' does not exist in the current context

Sudhakar Tillapudi Over a year ago

@user3421239: are you able to run it now?

Collectives™ on Stack Overflow

Assign Sql Query Result To Variable

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related