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