public bool UpdData(LoaiObj lObj) { cmd.CommandText = "UPDATE LOAI SET TENL=N'" + lObj.TenL + "'WHERE MAL='" + lObj.MaL + "'"; cmd.CommandType = CommandType.Text; cmd.Connection = con.Connection; try { con.OpenConn(); cmd.ExecuteNonQuery(); con.CloseConn(); return(true); } catch (Exception ex) { string mex = ex.Message; cmd.Dispose(); con.CloseConn(); } return(false); }
public bool AddData(LoaiObj lObj) { cmd.CommandText = "INSERT INTO LOAI VALUES ('" + lObj.MaL + "', N'" + lObj.TenL + "')"; cmd.CommandType = CommandType.Text; cmd.Connection = con.Connection; try { con.OpenConn(); cmd.ExecuteNonQuery(); con.CloseConn(); return(true); } catch (Exception ex) { string mex = ex.Message; cmd.Dispose(); con.CloseConn(); } return(false); }
public bool updData(LoaiObj lObj) { return(lMod.UpdData(lObj)); }
public bool addData(LoaiObj lObj) { return(lMod.AddData(lObj)); }
private void addData(LoaiObj l) { l.MaL = txtmal.Text.Trim(); l.TenL = txttenl.Text.Trim(); }