예제 #1
0
        public static string TextFromOneSQL(string QuerySQL)
        {
            DataSet ReportDataSet = new DataSet();

            MyDbDataAdapter ReportDataAdapter = new MyDbDataAdapter(QuerySQL, ReportConn);

            ReportDataAdapter.Fill(ReportDataSet);

            return(JSONReportData.FromDataSet(ReportDataSet));
        }
예제 #2
0
        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));
        }