public void update(Class_CongDung cd) { string sql = "UPDATE CongDung WHERE SET MaCongDung=" + cd.MaCongDung1 + ",TenCongDung=N'" + cd.TenCongDung1 + "')"; query.insert(sql); }
public void delete(Class_CongDung cd) { string sql = "DELETE FROM CongDung WHERE MaCongDung = " + cd.MaCongDung1; query.insert(sql); query.insert(sql); }
public void insert(Class_CongDung cd) { string sql = "INSERT INTO CongDung(MaCongDung,TenCongDung) VALUES("; sql += cd.MaCongDung1 + ",N'" + cd.TenCongDung1 + "')"; query.insert(sql); }
public new List <Class_CongDung> test1() { string sql = "SELECT * FROM CongDung"; List <Class_CongDung> list = new List <Class_CongDung>(); SqlConnection con = new SqlConnection(); con.ConnectionString = @"Data Source=Data Source=MINH_VU_PC\SQLEXPRESS;Initial Catalog=BTL;Integrated Security=True"; con.Open(); SqlCommand cmd = new SqlCommand(sql, con); using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { string MaCongDung = reader.GetString(0); string TenCongDung = reader.GetString(1); Class_CongDung Test = new Class_CongDung(MaCongDung, TenCongDung); list.Add(Test); } } } con.Close(); return(list); }
public new List <Class_CongDung> test1() { query.ketnoiSQL(); string sql = "SELECT * FROM CongDung"; List <Class_CongDung> list = new List <Class_CongDung>(); using (DbDataReader reader = query.Reader(sql)) { if (reader.HasRows) { while (reader.Read()) { string MaCongDung = reader.GetString(0); string TenCongDung = reader.GetString(1); Class_CongDung Test = new Class_CongDung(MaCongDung, TenCongDung); list.Add(Test); } } } query.DongketnoiSQL(); return(list); }