private void tvTablesColumns_ExpandTable(TreeNode tNode)
{
if (tNode.Parent == null) // Check for Tables or Views
{
return;
}
if (tNode.FirstNode.Text != "") // Have we already filled it out?
{
return;
}
// Need to obtain the column information for the requested table/view
// suppress redraw until tree view is complete
tvTablesColumns.BeginUpdate();
string sql = "SELECT * FROM " + DesignerUtility.NormalizeSqlName(tNode.Text);
List <SqlColumn> tColumns = DesignerUtility.GetSqlColumns(_Draw, _DataSource, sql);
bool bFirstTime = true;
foreach (SqlColumn sc in tColumns)
{
if (bFirstTime)
{
bFirstTime = false;
tNode.FirstNode.Text = sc.Name;
}
else
{
tNode.Nodes.Add(sc.Name);
}
}
tvTablesColumns.EndUpdate();
}
private void bRefresh_Click(object sender, System.EventArgs e)
{
// Need to clear all the fields and then replace with the columns
// of the SQL statement
List <SqlColumn> cols = DesignerUtility.GetSqlColumns(_Draw, cbDataSource.Text, tbSQL.Text);
if (cols == null || cols.Count <= 0)
{
return; // something didn't work right
}
_dsv.Fields.Rows.Clear();
string[] rowValues = new string[4];
foreach (SqlColumn sc in cols)
{
rowValues[0] = sc.Name;
rowValues[1] = sc.Name;
rowValues[2] = "";
rowValues[3] = sc.DataType.FullName;
_dsv.Fields.Rows.Add(rowValues);
}
}