Filtering data from datatable to dropdownlists?

Question

Hi In my application there are three dropdownlist are there if user selects the first and second dropdowns the data should be binded into third dropdownlist without using SQL or any database only through (datatable)? Plz Tell the code for it.... Thanks.

Abdullah Munshi · Answer

Here is the code: public partial class Default3 : System.Web.UI.Page { static DataTable dt = new DataTable(); static DataTable dt1 = new DataTable(); static DataTable dt2 = new DataTable(); protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { dt.Columns.Clear(); dt.Rows.Clear(); dt.Columns.Add(new DataColumn(Name typeof(string))); dt.Columns.Add(new DataColumn(ID typeof(string))); dt.Rows.Add(Wholesale Area wa); dt.Rows.Add(Region reg); dt.Rows.Add(Notification Group ng); ddlSendMsgBy.DataSource = dt; ddlSendMsgBy.DataTextField = dt.Columns[0].ToString(); ddlSendMsgBy.DataValueField = dt.Columns[1].ToString(); ddlSendMsgBy.DataBind(); dt1.Columns.Clear(); dt1.Rows.Clear(); dt1.Columns.Add(new DataColumn(Name1 typeof(string))); dt1.Columns.Add(new DataColumn(ID1 typeof(string))); dt1.Rows.Add(All (non-dealers) A); dt1.Rows.Add(Branded Jobber B); dt1.Rows.Add(Unbranded Jobber U); ddlPriceType.DataSource = dt1; ddlPriceType.DataTextField = dt1.Columns[0].ToString(); ddlPriceType.DataValueField = dt1.Columns[1].ToString(); ddlPriceType.DataBind(); dt2.Columns.Clear(); dt2.Rows.Clear(); dt2.Columns.Add(new DataColumn(Name2 typeof(string))); dt2.Columns.Add(new DataColumn(ID2 typeof(string))); dt2.Columns.Add(new DataColumn(ID typeof(string))); dt2.Columns.Add(new DataColumn(ID1 typeof(string))); dt2.Rows.Add(1234 1 wa A); dt2.Rows.Add(ASDF A reg B); dt2.Rows.Add(9999 9 ng U); } } protected void ddlPriceType_SelectedIndexChanged(object sender EventArgs e) { DataView dv = new DataView(dt2); string expression = ID=' + ddlSendMsgBy.SelectedValue + 'AND [ID1]=' + ddlPriceType.SelectedValue +'; dv.RowFilter = expression; DropDownList3.DataTextField = Name2; DropDownList3.DataValueField = ID2; DropDownList3.DataSource = dv; DropDownList3.DataBind(); } } =========================================================== .aspx code ============================= onselectedindexchanged=ddlPriceType_SelectedIndexChanged>

Gunti Dilip · Answer

Thanks Abdullah.

Gunti Dilip · Answer

If user selects first 2 ddls depending up on there ID's should be filtered into third ddl using

Abdullah Munshi · Answer

You are already having 3 datatables then what exactly you want to filter & display in 3rd dropdownlist?

Gunti Dilip · Answer

I have created like this can u tell the further procedure... protected void Page_Load(object sender EventArgs e) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn(Name typeof(string))); dt.Columns.Add(new DataColumn(ID typeof(string))); dt.Rows.Add(Wholesale Area wa); dt.Rows.Add(Region reg); dt.Rows.Add(Notification Group ng); ddlSendMsgBy.DataSource = dt; ddlSendMsgBy.DataTextField = dt.Columns[0].ToString(); ddlSendMsgBy.DataValueField = dt.Columns[1].ToString(); ddlSendMsgBy.DataBind(); DataTable dt1 = new DataTable(); dt1.Columns.Add(new DataColumn(Name1 typeof(string))); dt1.Columns.Add(new DataColumn(ID1 typeof(string))); dt1.Rows.Add(All (non-dealers) A); dt1.Rows.Add(Branded Jobber B); dt1.Rows.Add(Unbranded Jobber U); ddlPriceType.DataSource = dt1; ddlPriceType.DataTextField = dt1.Columns[0].ToString(); ddlPriceType.DataValueField = dt1.Columns[1].ToString(); ddlPriceType.DataBind(); DataTable dt2 = new DataTable(); dt2.Columns.Add(new DataColumn(Name2 typeof(string))); dt2.Columns.Add(new DataColumn(ID2 typeof(string))); dt2.Columns.Add(new DataColumn(ID typeof(string))); dt2.Columns.Add(new DataColumn(ID1 typeof(string))); dt2.Rows.Add(1234 1waA); dt2.Rows.Add(ASDF AregB); dt2.Rows.Add(9999 9ngU); }

Abdullah Munshi · Answer

Then you can use this code. dv.RowFilter=FieldName1=+DropDownList1.SelectedValue+AND FieldName2= + DropDownList1.SelectedValue; DropDownList3.DataTextField=abc; DropDownList3.DataValueField=xyz; DropDownList3.DataSource=dv; DropDownList3.DataBind();

Gunti Dilip · Answer

There are three ddlists are there using first and second i should have to filter the records to third ddl.....any other way...

Abdullah Munshi · Answer

You can use DataView. First fill the data in a datatable. Then Dataview dv=new DataView( dataTable ); // dataTable will be your datatable from which you will filter records dv.RowFilter=FieldName=+DropDownList1.SelectedValue; DropDownList2.DataTextField=abc; DropDownList2.DataValueField=xyz; DropDownList2.DataSource=dv; DropDownList2.DataBind(); I think you need to do something like this.