public void delete(dtobaohanh k) { openC(); SqlCommand cmd = new SqlCommand("sp_delete_TT_BAOHANH", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MAHD", k.MAHD)); cmd.ExecuteNonQuery(); closeC(); }
public void update(dtobaohanh k) { openC(); SqlCommand cmd = new SqlCommand("sp_update_TT_BAOHANH", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MAHD", k.MAHD)); cmd.Parameters.Add(new SqlParameter("@MASP", k.MASP)); cmd.Parameters.Add(new SqlParameter("@NGAY", k.NGAY)); cmd.Parameters.Add(new SqlParameter("@CHITIET", k.CHITIET)); cmd.ExecuteNonQuery(); closeC(); }