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