protected void BindCategory() { DataSet ds = objBLL.TEC_Get_ActiveCategory(); DataTable dt = new DataTable(); dt.Columns.Add("ID"); dt.Columns.Add("Category_Name"); dt.Columns.Add("Category_Type"); dt.Columns.Add("Active_Status"); DataRow[] dr = ds.Tables[0].Select(" Category_Type= 'Primary'"); for (int i = 0; i < dr.Length; i++) { dt.Rows.Add(dr[i].ItemArray[0].ToString(), dr[i].ItemArray[1].ToString(), dr[i].ItemArray[2].ToString(), dr[i].ItemArray[3].ToString()); } ddlPrimary.DataSource = dt; ddlPrimary.DataTextField = "Category_Name"; ddlPrimary.DataValueField = "ID"; ddlPrimary.DataBind(); dt.Rows.Clear(); ddlPrimary.Items.Insert(0, "--SELECT--"); DataRow[] dr1 = ds.Tables[0].Select(" Category_Type= 'Secondary'"); for (int i = 0; i < dr1.Length; i++) { dt.Rows.Add(dr1[i].ItemArray[0].ToString(), dr1[i].ItemArray[1].ToString(), dr1[i].ItemArray[2].ToString(), dr1[i].ItemArray[3].ToString()); } ddlSecondary.DataSource = dt; ddlSecondary.DataTextField = "Category_Name"; ddlSecondary.DataValueField = "ID"; ddlSecondary.DataBind(); ddlSecondary.Items.Insert(0, "--SELECT--"); }