Esempio n. 1
0
 public static string GetActiveDatabase()
 {
     return(AnalyzeConnectionStringRetriveDatabaseName(ConfigManager.GetConnectionString()));
 }
Esempio n. 2
0
        public DataRow GetReportConfigInfo(string reportCode)
        {
            DataTable dataTable = new DataTable();

            try
            {
                string query = "select field_caps, sql_from,detail_fieldsets from " + ConfigManager.GetReportTableName() + " where upper(report_code) ='" + reportCode.ToUpper() + "'";

                using (OleDbConnection dbConnection = new OleDbConnection(ConnectionString))
                {
                    using (OleDbDataAdapter adapter = new OleDbDataAdapter())
                    {
                        adapter.SelectCommand = new OleDbCommand(query, dbConnection);
                        adapter.Fill(dataTable);
                        return(dataTable.Rows[0]);
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception("From GetDataTable method:" + ex.Message);
            }
            return(null);
        }