MySQL登录

//前台

账号：<asp:TextBox ID="txtName" runat="server"></asp:TextBox><br />
密码：<asp:TextBox ID="txtPwd" runat="server"></asp:TextBox><br />
<asp:Button ID="Button1" runat="server" Text="登录" OnClick="Button1_Click"/>

//后台

string name = txtName.Text.Trim();
string pwd = txtPwd.Text.Trim();
string conString="server=127.0.0.1;database=mytext;User ID=rootPassword=password;port=3306;CharSet=utf8;pooling=true";
MySqlConnection conn = new MySqlConnection(conString);
MySqlDataAdapter sda=new MySqlDataAdapter("select * from users where UserName='"+name+"' and Pwd='"+pwd+"'",conn);
DataSet ds = new DataSet();
sda.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
Response.Redirect("Main.aspx");
}
else {
Response.Write("<script>alert('账号或密码错误')</script>");
}