public DataSet getUser()
{
connect();
con.Open();
queue = "select id,pass, maquyen,tennv from nguoidung u1,nhanvien n1 where u1.mnv=n1.mnv";
da.SelectCommand = new SqlCommand(queue, con);
Dset.Clear();
da.Fill(Dset);
return(Dset);
}
public static void DisposeDataBase()
{
if (!_config.Bdd && Dset != null)
{
if (Dset.Tables.Count > 0)
{
Dset.Tables[0].Clear();
}
Dset.Clear();
Dset.Dispose();
Dset = null;
}
Analyser.InitDataSet();
GC.Collect();
}
public DataSet getUser(String id)
{
if (checkConn())
{
connect();
con.Open();
queue = "select * from nguoidung where id = @id";
da.SelectCommand = new SqlCommand(queue, con);
da.SelectCommand.Parameters.Add("@id", SqlDbType.Char).Value = id;
Dset.Clear();
da.Fill(Dset);
return(Dset);
}
else
{
return(Dset);
}
}
