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);
}
}
}
