/// <summary> /// 注册 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnRegister_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(txtUserName.Text)) { Response.Write("<script>alert('请输入用户名')</script>"); return; } if (string.IsNullOrWhiteSpace(txtUserPwd.Value)) { Response.Write("<script>alert('请输入密码')</script>"); return; } int id = SimpleSqlserverHelper.ExecuteNonQuery("Insert into Users (UserName,UserPwd)Values('" + txtUserName.Text + "','" + txtUserPwd.Value + "')"); if (id > 0) { Response.Write("<script>alert('注册成功')</script>"); Response.Redirect("Default.aspx"); } else { Response.Write("<script>alert('注册失败')</script>"); } }
//绑定 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>"); } }
/// <summary> /// 取消 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> //protected void gvwUsers_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) //{ // gvwUsers.EditIndex = -1; // dataBinds(); //} /// <summary> ///删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void gvwUsers_RowDeleting(object sender, GridViewDeleteEventArgs e) { sqlWhere = "delete from TempHumData where Id='" + gvwUsers.DataKeys[e.RowIndex].Value.ToString() + "'"; SimpleSqlserverHelper.ExecuteNonQuery(sqlWhere); dataBinds(); }