protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e) { int cloID = Request.QueryString["cloID"] == null ? 0 : Int32.Parse(Request.QueryString["cloID"]); if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { //Get questionID here String tableName = DataBinder.Eval(e.Item.DataItem, "tableName").ToString(); String pkColumnName = DataBinder.Eval(e.Item.DataItem, "pkColumnName").ToString(); String displayColumn = DataBinder.Eval(e.Item.DataItem, "displayColumn").ToString(); String headingLabel = DataBinder.Eval(e.Item.DataItem, "headingLabel").ToString(); String questionStatement = DataBinder.Eval(e.Item.DataItem, "questionStatement").ToString(); int questionID = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "questionID")); DropDownList DropDownList1 = (DropDownList)e.Item.FindControl("ddlItemTemp"); DBQueDao dbQueDaoObj = new DBQueDao(); List <ListItem> ddValueList = dbQueDaoObj.getColumnValues(tableName, displayColumn); DropDownList1.DataSource = ddValueList; DropDownList1.DataTextField = "Text"; DropDownList1.DataValueField = "Value"; DropDownList1.DataBind(); } }
public void fillSelectedColumnValues(DropDownList ddWhereTable, DropDownList ddWhereColumn, DropDownList ddColumnValue) { String tableName = ddWhereTable.SelectedItem.Text; String pkColumnName = ddWhereTable.SelectedItem.Value; String columnSelected = ddWhereColumn.SelectedItem.Text; DBQueDao dbQueDaoObj = new DBQueDao(); List <ListItem> listItems = dbQueDaoObj.getColumnValues(tableName, columnSelected); fillColumnValueList(ddColumnValue, listItems); }