以前写过的一段代码,复制给你看看: using (SqlCommand cmd = new SqlCommand("select count(*) from tbUser where UserID=@UserID and UserPwd=@UserPwd", con)) { cmd.Parameters.AddWithValue("@UserID", id); cmd.Parameters.AddWithValue("@UserPwd", pwd); int count = Convert.ToInt32(cmd.ExecuteScalar()); if (count > 0) {
winform要做界面,连接数据数查询数据参考
#region 绑定 ComboBox
/// <summary>
/// 对 ComboBox 控件进行数据绑定
/// </summary>
/// <param name="P_str_sqlstr"> SQL 语句</param>
/// <param name="P_str_table">表名</param>
/// <param name="P_str_tbMember">数据表字段名</param>
/// <param name="cbox">ComboBox 名字</param>
public void cboxBind(string P_str_sqlstr, string P_str_table, string P_str_tbMember, ComboBox cbox)
{
DataSet myds = getds(P_str_sqlstr, P_str_table);
cbox.DataSource = myds.Tables[P_str_table]; //绑定数据源
cbox.DisplayMember = P_str_tbMember; //显示的字段名
}
#endregion
using (SqlCommand cmd = new SqlCommand("select count(*) from tbUser where UserID=@UserID and UserPwd=@UserPwd", con))
{
cmd.Parameters.AddWithValue("@UserID", id);
cmd.Parameters.AddWithValue("@UserPwd", pwd);
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
{
Response.Redirect("person.aspx?uid="+uid);
}
else
{
Response.Write("<script>alert('非正式员工,登陆失败!')</script>");
}
}