Breaking News: Grepper is joining You.com. Read the official announcement!

c# mysql parameterized query

Defeated Donkey answered on March 18, 2023 Popularity 1/10 Helpfulness 3/10

answer c# mysql parameterized query

related c# mysql parameterized query

c# mysql parameterized query

Comment

protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
    MySqlConnection con = new MySqlConnection("server=localhost;User Id=root;database=result;password=1234");
    con.Open();

    MySqlCommand cmd = new MySqlCommand("Select * from users where username=?username and password=?password", con);
    cmd.Parameters.Add(new MySqlParameter("username", this.Login1.UserName));
    cmd.Parameters.Add(new MySqlParameter("password", this.Login1.Password)); 

    MySqlDataReader dr = cmd.ExecuteReader();
    if (dr.HasRows ==true)
    {
        e.Authenticated = true;
    }
}

Popularity 1/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: c# sql

Link to this answer
Share Copy Link

Contributed on Mar 18 2023

Defeated Donkey

0 Answers Avg Quality 2/10

Closely Related Answers

c# mysql parameterized query

Comment

private String readCommand = 
             "SELECT LEVEL FROM USERS WHERE VAL_1 = @param_val_1 AND VAL_2 = @param_val_2;";

public bool read(string id)
{
    level = -1;
    MySqlCommand m = new MySqlCommand(readCommand);
    m.Parameters.AddWithValue("@param_val_1", val1);
    m.Parameters.AddWithValue("@param_val_2", val2);
    level = Convert.ToInt32(m.ExecuteScalar());
    return true;
}

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: c# sql

Link to this answer
Share Copy Link

Contributed on Mar 18 2023

Defeated Donkey

0 Answers Avg Quality 2/10

c# mysql parameterized query

Contents

More Related Answers

c# mysql parameterized query

Closely Related Answers

c# mysql parameterized query

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.