private void Load_Tables(TreeNodeEventArgs e, GlobalFunction.Database database)
{
TreeNodeCollection nodes = e.Node.ChildNodes;
for (int i = 0; i < nodes.Count; i++)
{
string dbnm = nodes[i].Value;
DataTable dt = gf.ShowTables(database, dbnm);
foreach (DataRow dr in dt.Rows)
{
TreeNode node1 = new TreeNode();
node1.Text = GetSpace(2) + dr["TableName"].ToString();
node1.Value = dr["TableName"].ToString();
node1.ImageUrl = "~/Images/table.ico";
e.Node.ChildNodes[i].ChildNodes.Add(node1);
}
if (dt.Rows.Count > 0)
{
nodes[i].Text = GetSpace(1) + dbnm + GetSpace(2) + "(" + dt.Rows.Count + ")";
}
}
}
private void Load_Columns(TreeNodeEventArgs e, GlobalFunction.Database database)
{
string dbnm = e.Node.Value;
TreeNodeCollection tables_nodes = e.Node.ChildNodes;
for (int i = 0; i < tables_nodes.Count; i++)
{
DataTable dt = gf.ShowColumns(database, dbnm, tables_nodes[i].Value);
foreach (DataRow dr in dt.Rows)
{
TreeNode column_node = new TreeNode();
column_node.Text = GetSpace(1) + dr["ColumnName"].ToString();
column_node.Value = dr["ColumnName"].ToString();
column_node.ImageUrl = "~/Images/Column.ico";
e.Node.ChildNodes[i].ChildNodes.Add(column_node);
}
tables_nodes[i].Text = GetSpace(2) + tables_nodes[i].Value + GetSpace(2) + "(" + dt.Rows.Count + ")";
}
}
