/* * Init checkbox fields to exclude the key column */ void InitCheckboxFields() { CheckBoxListInputColumns.DataSource = null; CheckBoxListInputColumns.DataBind(); CheckBoxListPredictColumns.DataSource = null; CheckBoxListPredictColumns.DataBind(); // execute query SQLManager manager = new SQLManager(sCatalog); DataTable objTable = new DataTable(); // handle errors //if (manager.GetQueryResult(sQueryText) == null) //{ // HandleQueryError(); // return; //} // exclude the key column string sQueryTextExclude = "SELECT COLUMN_NAME, ORDINAL_POSITION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + DropDownListTables.SelectedItem.ToString() + "' AND COLUMN_NAME <> '" + DropDownListKey.SelectedItem.ToString() + " 'ORDER BY ORDINAL_POSITION"; objTable.Load(manager.GetQueryResult(sQueryTextExclude)); CheckBoxListInputColumns.DataSource = objTable; CheckBoxListInputColumns.DataTextField = "COLUMN_NAME"; CheckBoxListInputColumns.DataValueField = "ORDINAL_POSITION"; CheckBoxListInputColumns.DataBind(); CheckBoxListPredictColumns.DataSource = objTable; CheckBoxListPredictColumns.DataTextField = "COLUMN_NAME"; CheckBoxListPredictColumns.DataValueField = "ORDINAL_POSITION"; CheckBoxListPredictColumns.DataBind(); manager.CloseConnection(); }
/* * Initialize column names in checkbox list and dropdown box */ void InitializeColumns(DataTable objMainTable) { if (objMainTable == null) { return; } // reset controlls DropDownListKey.DataSource = null; DropDownListKey.DataBind(); CheckBoxListInputColumns.DataSource = null; CheckBoxListInputColumns.DataBind(); // add columns for (int i = 0; i < objMainTable.Columns.Count; i++) { DropDownListKey.Items.Add(objMainTable.Columns[i].ColumnName.ToString()); CheckBoxListInputColumns.Items.Add(objMainTable.Columns[i].ColumnName.ToString()); } DropDownListKey.DataBind(); CheckBoxListInputColumns.DataBind(); }