public new List <Class_Que> Select() { string sql = "SELECT * FROM Que"; List <Class_Que> list = new List <Class_Que>(); SqlConnection con = new SqlConnection(); con.ConnectionString = @"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 MaQue = reader.GetString(0); string TenQue = reader.GetString(1); Class_Que que = new Class_Que(MaQue, TenQue); list.Add(que); } } } con.Close(); return(list); }
public void delete(Class_Que que) { string sql = "DELETE FROM Que WHERE MaQue = " + que.MaQue1; query.insert(sql); query.insert(sql); }
public void update(Class_Que que) { string sql = "UPDATE Que WHERE SET MaQue = " + que.MaQue1 + ",TenQue=N'" + que.TenQue1 + "')"; query.insert(sql); }
public void insert(Class_Que que) { string sql = "INSERT INTO Que(MaQue,TenQue) VALUES("; sql += que.MaQue1 + ",N'" + que.TenQue1 + "')"; query.insert(sql); }
public new List <Class_Que> Select() { string sql = "SELECT * FROM Que"; List <Class_Que> list = new List <Class_Que>(); using (DbDataReader reader = query.Reader(sql)) { if (reader.HasRows) { while (reader.Read()) { string MaQue = reader.GetString(0); string TenQue = reader.GetString(1); Class_Que que = new Class_Que(MaQue, TenQue); list.Add(que); } } } query.DongketnoiSQL(); return(list); }