Example #1
0
 public void UseGetTablesTest()
 {
     string tableName = "EMPOWER.SET_REALEC_DOCTYPES";
     using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ExtraTestsConnectionString"]))
     {
         conn.Open();
         var dt = conn.GetTable(tableName);
     }
 }
Example #2
0
        public DataSet GetDataSet(string dataSetName = "SelectedTables")
        {
            using (var conn = new SqlConnection(ConnectionString))
            {
                conn.Open();
                var ds = new DataSet(dataSetName);

                foreach (ListViewItem item in CheckedItems.Cast<ListViewItem>())
                {
                    string tableName = item.SubItems[0].Text;
                    DataTable dt = conn.GetTable(tableName);
                    ds.Tables.Add(dt);
                }
                return ds;
            }
        }