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