public void Sua(string username, string fullname, string email, string address, int role) { //câu lệnh update vào sql server string update = "update acount set fullname=N'" + fullname + "',email=N'" + email + "',address=N'" + address + "',roleid='" + role + "' where username='******'"; db.ExcuteNonquery(update); }
protected void btnThem_Click(object sender, EventArgs e) { if (int.Parse(ddMenuCha.SelectedValue.ToString()) == 0) { int cateid1 = MaxMenuID() + 1; string link = "BaiViet.aspx?mid=" + cateid1; string sql = "insert into category(cateid,catename,link) values(" + cateid1 + ",N'" + txtTenMenu.Text + "','" + link + "')"; ac.ExcuteNonquery(sql); WriteSiteMap(); Response.Redirect("quanlymenu.aspx"); } else { int cateid = MaxMenuID() + 1; string link = "BaiViet.aspx?mid=" + cateid; string sql = "insert into category values('" + cateid + "',N'" + txtTenMenu.Text + "','" + link + "','" + ddMenuCha.SelectedValue.ToString() + "')"; ac.ExcuteNonquery(sql); WriteSiteMap(); Response.Redirect("quanlymenu.aspx"); } }
/// <summary> /// click vào button Them /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnThem_Click(object sender, EventArgs e) { if (dl.kiemtra("Acount", "username", txtTenDangNhap.Text) <= 0) { //câu lệnh thêm vào sql server string caulenh = "insert into Acount values(N'" + txtTenDangNhap.Text + "',N'" + txtMatKhau.Text + "',N'" + ddlQuyen.SelectedValue.ToString() + "',N'" + txtHoTen.Text + "',N'" + txtDiaChiMail.Text + "',N'" + txtDiaChi.Text + "',N'')"; dl.ExcuteNonquery(caulenh); Response.Write("<script language='javascript'>alert('Thêm tài khoản thành công')</script>"); } else { Response.Write("<script language='javascript'>alert('Tài khoản đã tồn tại')</script>"); } }