protected void txtsave_Click(object sender, EventArgs e) { //string masv = txtmasv.Text; //string hoten = txthoten.Text; //string ngaysinh = txtngaysinh.Text; //bool gioitinh = bool.Parse(DropDownList3.SelectedValue); //string quequan = txtquequan.Text; //string lop = txtmalop.Text; //string tenchutro = txttenchutro.Text; //string sdt = txtsdt.Text; //string diachi = txtdiachi.Text; //string ngayden = txtngayden.Text; //string ngaydi = txtngaydi.Text; //Sinhvien sv = new Sinhvien(masv, hoten, ngaysinh, gioitinh, quequan, tenchutro, sdt, diachi, ngayden, ngaydi, lop); SinhVienDAO svdao = new SinhVienDAO(); if (svdao.CheckUser(txtmasv.Text)) { lbthongbao.Text = "Tai Khoan Ton Tai"; } else { svdao.Insert(GetSinhvien()); lbthongbao.Text = "Luu Thanh Cong"; LoadGridview(); } }
protected void find_Click(object sender, EventArgs e) { SinhVienDAO svdao = new SinhVienDAO(); if (!svdao.CheckUser(txttim.Text.Trim())) { lbthongbao.Text = "Không tìm thấy"; } else { GridView1.DataSource = svdao.Getdata("SELECT MaSV,HoTen,NgaySinh,GioiTinh,TenKhoa,Lop,TenChuTro,SDT,DiaChi,NgayDen,NgayDi,TenKhoa FROM SinhVien,Khoa WHERE MaSV='" + txttim.Text + "' "); GridView1.DataBind(); lbthongbao.Text = ""; } }