public void SuaLop(Lop l)
{
string query = string.Format("UPDATE dbo.LOP SET TENLOP ='{0}' , SISO='{1}', MA_GVCHUNHIEM='{2}'WHERE MALOP= {3}", l.TenLop, l.SiSo, l.MaGVCN, l.MaLop);
DatabaseConnect dtConnet = new DatabaseConnect();
dtConnet.ExecuteNonQuery(query);
}
public void insertLOP(Lop l)
{
string query = string.Format("insert dbo.LOP VALUES ( N'{0}', N'{1}' , N'{2}' )", l.TenLop, l.SiSo, l.MaGVCN);
DatabaseConnect dtConnet = new DatabaseConnect();
dtConnet.ExecuteNonQuery(query);
}
public void SuaHocSinh(HocSinh hs)
{
string query = string.Format("UPDATE dbo.HOCSINH SET HOTEN ='{0}' ,GIOITINH='{1}',NGAYSINH='{2}',NOISINH='{3}',DANTOC='{4}',TONGIAO='{5}' WHERE MAHOCSINH= {6}", hs.HoTen, hs.GioiTinh, hs.NgaySinh.ToShortDateString(), hs.NoiSinh, hs.DanToc, hs.TonGiao, hs.MaHocSinh);
DatabaseConnect dtConnet = new DatabaseConnect();
dtConnet.ExecuteNonQuery(query);
}
public void deleteHocSinh(int id)
{
string query = string.Format("DELETE dbo.HOCSINH WHERE MAHOCSINH={0}", id);
DatabaseConnect dtConnet = new DatabaseConnect();
dtConnet.ExecuteNonQuery(query);
}
public void insertHocSinh(HocSinh hs)
{
string query = string.Format("INSERT dbo.HOCSINH VALUES ( N'{0}' ,N'{1}' , '{2}' , N'{3}' , N'{4}' , N'{5}')", hs.HoTen, hs.GioiTinh, hs.NgaySinh.ToShortDateString(), hs.NoiSinh, hs.DanToc, hs.TonGiao);
DatabaseConnect dtConnet = new DatabaseConnect();
dtConnet.ExecuteNonQuery(query);
}
public DataTable LoadDS()
{
string query = "SELECT * FROM dbo.HOCSINH ";
DatabaseConnect dtConnet = new DatabaseConnect();
return(dtConnet.GETdata(query));
}
public void insertLOP(Lop l)
{
// string query = string.Format("INSERT dbo.LOP VALUES ( N'{0}', N'{1}' , N'{2}' )", l.TenLop, l.SiSo, l.MaGVCN);
string query = string.Format("dbo.themLop @teblop = '{0}', @siso = {1}, @magv = {2}", l.TenLop, l.SiSo, l.MaGVCN);
DatabaseConnect dtConnet = new DatabaseConnect();
dtConnet.ExecuteNonQuery(query);
}
