//thêm mới dl
public bool AddData(TrinhDoHocVanDT dtTV)
{
cmd.CommandText = "INSERT INTO trinhdohocvan values ('" + dtTV.Matrinhdohocvan + "',N'" + dtTV.Tentrinhdohocvan + "', N'" + dtTV.Chuyennganh + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn.Connection;
try
{
conn.OpenConn();
cmd.ExecuteNonQuery();
conn.CloseConn();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
conn.CloseConn();
}
return(false);
}
//SỬA dl
public bool UpdateData(TrinhDoHocVanDT dtTV)
{
cmd.CommandText = "UPDATE trinhdohocvan SET tentrinhdohocvan= N'" + dtTV.Tentrinhdohocvan + "', chuyennganh = N'" + dtTV.Chuyennganh + "' WHERE matrinhdohocvan ='" + dtTV.Matrinhdohocvan + "'";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn.Connection;
try
{
conn.OpenConn();
cmd.ExecuteNonQuery();
conn.CloseConn();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
conn.CloseConn();
}
return(false);
}
public bool UpdateData(TrinhDoHocVanDT dtTV)
{
return(tvMH.UpdateData(dtTV));
}
public bool AddData(TrinhDoHocVanDT dtTV)
{
return(tvMH.AddData(dtTV));
}
//ham lay du lieu tu cotroller
void ganDL(TrinhDoHocVanDT dtTV)
{
dtTV.Matrinhdohocvan = txtMaTrinhDoHocVan.Text.Trim();
dtTV.Tentrinhdohocvan = txtTenTrinhDoHocVan.Text.Trim();
dtTV.Chuyennganh = txtChuyenNganh.Text.Trim();
}
