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