public DataTable LoadData(string querytype, string TblName) { DataTable db = new DataTable(TblName); using (Data.DataSet ds = new System.Data.DataSet()) { using (SqlDataAdapter da = new SqlDataAdapter(querytype, ConnectionString)) { da.Fill(ds, TblName); } db = ds.Tables[0]; return(db); } }
public DataTable LoadData(string querytype) { DataTable db; using (Data.DataSet Ds = new System.Data.DataSet()) { using (SqlDataAdapter da = new SqlDataAdapter(querytype, ConnectionString)) { da.Fill(Ds, "table"); } db = Ds.Tables[0]; return(db); } //return db; }
public Data.DataSet getSqlStatement(string SQL) { //bool bResponse = false; Data.DataSet Ds = new System.Data.DataSet(); try { using (SqlDataAdapter da = new SqlDataAdapter(SQL, ConnectionString)) { da.Fill(Ds); } } catch (Exception ex) { Tripous.Sys.ErrorBox(ex); } return Ds; }