public void LoadData(string name) { string sqlstr = "select * from td_user"; if (name != "") { sqlstr += " where UserName like'%" + name + "%'"; } DataSet ds = DBhelper.GetDataSet(sqlstr); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { string sqlstr = string.Format("insert into td_user(UserName,PassWord,Email,Role) values('{0}','{1}','{2}','{3}')", txtUserName.Text, txtPassWord.Text, txtEmail.Text, "普通用户"); bool yesno = DBhelper.InsertUpdateDel(sqlstr); if (yesno == true) { txtEmail.Text = ""; txtPassWord.Text = ""; txtPassWord2.Text = ""; txtUserName.Text = ""; Response.Write("<script>alert('注册成功!')</script>"); } else { Response.Write("<script>alert('注册失败!')</script>"); } }
protected void Button1_Click(object sender, EventArgs e) { if (Session["Role"].ToString() == "管理员") { string sqlstr = string.Format("insert into td_user(UserName,PassWord,Email,Role) values('{0}','{1}','{2}','{3}')", txtUserName.Text, txtPassWord.Text, txtEmail.Text, txtEmail.Text, DropDownList1.SelectedItem.Text); bool yesno = DBhelper.InsertUpdateDel(sqlstr); if (yesno == true) { Response.Write("<script>alert('保存成功')</script>"); } else { Response.Write("<script>alert('保存失败')</script>"); } } else { Response.Write("<script>alert('无权限!')</script>"); } }