protectedvoidButton1_Click(objectsender,EventArgse){stringSqlStr="DataSource=127.0.0.1;UserId=root;Password=123;DataBase=website2;";MySqlConnectioncon=newMySqlConnection(...
protected void Button1_Click(object sender, EventArgs e)
{
string SqlStr = "Data Source=127.0.0.1;User Id=root;Password=123;DataBase=website2;";
MySqlConnection con = new MySqlConnection(SqlStr);
MySqlDataAdapter username = new MySqlDataAdapter();
MySqlDataAdapter password = new MySqlDataAdapter();
username.SelectCommand = new MySqlCommand("select username from user",con);
password.SelectCommand = new MySqlCommand("select password from user", con);
DataSet un = new DataSet();
DataSet pd = new DataSet();
password.Fill(pd);
username.Fill(un);
username.Select