protected void DBTableDownList_SelectedIndexChanged(object sender, EventArgs e) { if (DbTableDownList.SelectedIndex == 0) { DbFieldDownList.Items.Clear(); } string dataname = DBHelper.GetAttrByStr(SqlHelper.ConnectionString, "Initial Catalog"); string dataname2 = DBHelper.GetAttrByStr(SqlHelper.PlugConnectionString, "Initial Catalog"); Hashtable tablelist = new Hashtable(); tablelist.Add(dataname, SqlHelper.ConnectionString); tablelist.Add(dataname2, SqlHelper.PlugConnectionString); string databaselistvalue = txt_DatabaseList; string Conection = tablelist[databaselistvalue].ToString(); this.dbConnectionString = Conection; if (this.DbTableDownList.SelectedIndex != 0) { DataTable tabledlist = this.bll.GetTableField(this.DbTableDownList.SelectedValue, this.dbConnectionString); tabledlist.DefaultView.Sort = "fieldname asc"; this.DbFieldDownList.DataSource = tabledlist; this.DbFieldDownList.DataTextField = "fieldname"; this.DbFieldDownList.DataValueField = "fieldname"; this.DbFieldDownList.DataBind(); this.DbFieldDownList.Items.Insert(0, new ListItem("*", "*")); for (int i = 0; i < this.DbFieldDownList.Items.Count; i++) { DbFieldDownList.Items[i].Attributes["title"] = bll.GetTablecolumn(this.DbTableDownList.SelectedValue, this.DbFieldDownList.Items[i].Text); } } }