protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)
{
//TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME COLUMN_GUID COLUMN_PROPID ORDINAL_POSITION COLUMN_HASDEFAULT
//COLUMN_DEFAULT COLUMN_FLAGS IS_NULLABLE DATA_TYPE TYPE_GUID CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH
// NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_CATALOG CHARACTER_SET_SCHEMA CHARACTER_SET_NAME
// COLLATION_CATALOG COLLATION_SCHEMA COLLATION_NAME DOMAIN_CATALOG DOMAIN_SCHEMA DOMAIN_NAME DESCRIPTION
DataView dv = DBFun.GetAccessColumnList(ListBox1.SelectedValue);
dv.Sort = "ORDINAL_POSITION";
ListItem li;
CheckBoxList1.Items.Clear();
for (int i = 0; i < dv.Table.Rows.Count; i++)
{
li = new ListItem();
li.Text = dv.Table.Rows[i]["DESCRIPTION"].ToString();
li.Value = dv.Table.Rows[i]["COLUMN_NAME"].ToString();
CheckBoxList1.Items.Add(li);
}
//GridView1.DataSource = dv;
//GridView1.DataBind();
}
