//绑定
public void dataBinds()
{
string sql = "select * from TempHumData ";
DataSet ds = SimpleSqlserverHelper.ExecuteDataset(sql);
if (ds != null)
{
gvwUsers.DataSource = ds.Tables[0];
gvwUsers.DataKeyNames = new string[] { "Id" };//主键
gvwUsers.DataBind();
}
}
/// <summary>
/// 登录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnLogin_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtUserName.Text))
{
Response.Write("<script>alert('请输入用户名')</script>");
return;
}
if (string.IsNullOrWhiteSpace(txtpwd.Value))
{
Response.Write("<script>alert('请输入密码')</script>");
return;
}
//sql查询语句
string sql = "select UserId from Users where UserName=@username and UserPwd=@userpwd";
//设置参数
SqlParameter[] paras = new SqlParameter[]
{
//记录数据ID
new SqlParameter("@username", SqlDbType.NVarChar, 50),
new SqlParameter("@userpwd", SqlDbType.NVarChar, 50)
};
paras[0].Value = txtUserName.Text;
paras[1].Value = txtpwd.Value;
DataSet ds = SimpleSqlserverHelper.ExecuteDataset(sql, paras);
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
Response.Write("<script>alert('登录成功')</script>");
Response.Redirect("ListShow.aspx");
}
else
{
Response.Write("<script>alert('登录失败')</script>");
}
}
