public static string TextFromOneSQL(string QuerySQL)
{
DataSet ReportDataSet = new DataSet();
MyDbDataAdapter ReportDataAdapter = new MyDbDataAdapter(QuerySQL, ReportConn);
ReportDataAdapter.Fill(ReportDataSet);
return(JSONReportData.FromDataSet(ReportDataSet));
}
public static string TextFromMultiSQL(ArrayList QueryList)
{
DataSet ReportDataSet = new DataSet();
foreach (ReportQueryItem item in QueryList)
{
MyDbDataAdapter DataAdapter = new MyDbDataAdapter(item.QuerySQL, ReportConn);
DataAdapter.Fill(ReportDataSet, item.RecordsetName);
}
return(JSONReportData.FromDataSet(ReportDataSet));
}