public void Xoa(LoaiCongTrinh_InFo loaicongtrinh)
{
SqlCommand s = new SqlCommand("Delete LoaiCongTrinh where MaLoaiCongTrinh = @ma");
s.Parameters.Add("@ma", SqlDbType.Int).Value = loaicongtrinh.MaLoaiCongTrinh;
DT_SV.Load(s);
}
public void Sua(LoaiCongTrinh_InFo loaicongtrinh)
{
SqlCommand s = new SqlCommand("Update LoaiCongTrinh set TenLoaiCongTrinh = @ten where MaLoaiCongTrinh = @ma");
s.Parameters.Add("@ten", SqlDbType.NVarChar, 50).Value = loaicongtrinh.TenLoaiCongTrinh;
s.Parameters.Add("@ma", SqlDbType.Int).Value = loaicongtrinh.MaLoaiCongTrinh;
DT_SV.Load(s);
}
//
public void Them(LoaiCongTrinh_InFo loaicongtrinh)
{
SqlCommand s = new SqlCommand("INSERT INTO LoaiCongTrinh(MaLoaiCongTrinh, TenLoaiCongTrinh) VALUES(@ma, @ten)");
s.Parameters.Add("@ma", SqlDbType.Int).Value = loaicongtrinh.MaLoaiCongTrinh;
s.Parameters.Add("@ten", SqlDbType.NVarChar, 200).Value = loaicongtrinh.TenLoaiCongTrinh;
DT_SV.Load(s);
}
public void Sua(LoaiCongTrinh_InFo loaicongtrinh)
{
DATA.Sua(loaicongtrinh);
}
public void Xoa(LoaiCongTrinh_InFo loaicongtrinh)
{
DATA.Xoa(loaicongtrinh);
}
public void Them(LoaiCongTrinh_InFo loaicongtrinh)
{
DATA.Them(loaicongtrinh);
}