private void EntityLoad() { IDbQuery query = new MSSQL(); var tables = new List <DbTable>(); DataTable dt = new DataTable(); LB_Table.Items.Clear(); using (var conn = new SqlConnection(this.ConnectionString)) using (var cmd = new SqlCommand(query.AllTables(), conn)) { conn.Open(); using (var adp = new SqlDataAdapter(cmd)) { adp.Fill(dt); } conn.Close(); } if (dt != null && dt.Rows != null && dt.Rows.Count > 0) { tables = dt.DataToEntity <DbTable>(); } if (tables != null && tables.Count > 0) { foreach (var table in tables) { LB_Table.Items.Add(table.TableName); } } }
private void btn_load_Click(object sender, EventArgs e) { IDbQuery query = new MSSQL(); var tables = new List <DbTable>(); DataTable dt = new DataTable(); CB_List.Items.Clear(); using (var conn = new SqlConnection(this.ConnectionString)) using (var cmd = new SqlCommand(query.AllTables(), conn)) { conn.Open(); using (var adp = new SqlDataAdapter(cmd)) { adp.Fill(dt); } conn.Close(); } if (dt != null && dt.Rows != null && dt.Rows.Count > 0) { tables = dt.DataToEntity <DbTable>(); } if (tables != null && tables.Count > 0) { foreach (var table in tables) { CB_List.Items.Add(table.TableName, false); } } }