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);
}
