protectedvoidButton1_Click(objectsender,EventArgse){stringzhanghao=TextBox1.Text.Trim();stringmima=TextBox2.Text.Trim();stringlianjie="Server=localhost;database=zhaoyanji...
protected void Button1_Click(object sender, EventArgs e)
{
string zhanghao = TextBox1.Text.Trim();
string mima = TextBox2.Text.Trim();
string lianjie = " Server = localhost; database = zhaoyanjing_keyan不要丢;Integrated Security=true";
SqlConnection conn = new SqlConnection(lianjie);
conn.Open();
SqlCommand comm = new SqlCommand("select 密码 from 账号和密码 where 账号='" + zhanghao + "'", conn);
SqlDataReader myreader = comm.ExecuteReader();
try
{
string reader = myreader.GetString(1);
if (mima==reader.Trim())
Response.Redirect("个人主页.aspx");
else Response.Write("账号或密码错误!请重新输入!");
myreader.Close();
conn.Close();
}
catch (Exception a) { Response.Write(a); }
}
展开
此篇博客介绍了如何使用C#通过ADO.NET连接到SQL Server数据库,实现用户账号密码的验证过程。代码展示了获取TextBox输入的账号和密码,然后查询数据库中对应记录,如果密码匹配则跳转到个人主页,否则提示错误信息。
549

被折叠的 条评论
为什么被折叠?



