public void Update(Class.hoiVien hoiVien) { sqlQuery = "update Member set ma = N'" + hoiVien.ma.Trim() + "', ten = N'" + hoiVien.ten + "', tuoi = '" + hoiVien.tuoi + "', gioiTinh= N'" + hoiVien.gioiTinh + "', soDT =" + hoiVien.sdt + ", ngayThamGia = '" + hoiVien.ngayThamGia.ToString("MM/dd/yyyy") + "' where ma=N'" + hoiVien.ma.Trim() + "'"; conString.ConString constring = new conString.ConString(); try { using (var con = new SqlConnection(constring.initString())) { using (var cmd = new SqlCommand(sqlQuery, con)) { con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } } catch (SqlException ex) { } }
public void FullInsert(Class.hoiVien hoiVien) { sqlQuery = "insert into Member (ma, ten,tuoi, gioiTinh,soDT, ngayThamGia, ngayKetThuc) values ('" + hoiVien.ma + "',N'" + hoiVien.ten + "','" + hoiVien.tuoi.ToString() + "',N'" + hoiVien.gioiTinh + "','" + hoiVien.sdt + "','" + hoiVien.ngayThamGia.ToString("MM/dd/yyyy") + "','" + hoiVien.ngayTKetThuc.ToString("MM/dd/yyyy") + "')"; conString.ConString constring = new conString.ConString(); try { using (var con = new SqlConnection(constring.initString())) { using (var cmd = new SqlCommand(sqlQuery, con)) { con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } } catch (SqlException ex) { } }