public void UseGetTablesTest() { string tableName = "EMPOWER.SET_REALEC_DOCTYPES"; using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ExtraTestsConnectionString"])) { conn.Open(); var dt = conn.GetTable(tableName); } }
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; } }