public void update(QuanDTO info) { string updateCommand = "UPDATE Quan " + "SET TenQuan = '" + info.TenQuan + "', " + "SoDaiLyToiDa = '" + info.SoDaiLyToiDa + "', " + " WHERE MaQuan = '" + info.MaQuan + "'"; executeNonQuery(updateCommand); }
protected override object GetDataFromDataRow(DataTable dt, int i) { QuanDTO quan = new QuanDTO(); quan.MaQuan = dt.Rows[i]["MaQuan"].ToString(); quan.TenQuan = dt.Rows[i]["TenQuan"].ToString(); quan.SoDaiLyToiDa = int.Parse(dt.Rows[i]["SoDaiLyToiDa"].ToString()); return (object)quan; }
public void insert(QuanDTO info) { string insertCommand = "INSERT INTO Quan VALUES('" + info.MaQuan + "', '" + info.TenQuan + "', '" + info.SoDaiLyToiDa + ")"; executeNonQuery(insertCommand); }