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