protected void CategoryBind()
{
ddlCategory.Items.Clear();
DataSet dsCategory = new DataSet();
dsCategory = commonLookupBo.GetAllCategoryList();
if (dsCategory.Tables[0].Rows.Count > 0)
{
ddlCategory.DataSource = dsCategory.Tables[0];
ddlCategory.DataValueField = dsCategory.Tables[0].Columns["PAIC_AssetInstrumentCategoryCode"].ToString();
ddlCategory.DataTextField = dsCategory.Tables[0].Columns["PAIC_AssetInstrumentCategoryName"].ToString();
ddlCategory.DataBind();
ddlCategory.Items.Insert(0, new ListItem("All", "0"));
}
ddlSwtchShmCat.Items.Clear();
if (dsCategory.Tables[0].Rows.Count > 0)
{
ddlSwtchShmCat.DataSource = dsCategory.Tables[0];
ddlSwtchShmCat.DataValueField = dsCategory.Tables[0].Columns["PAIC_AssetInstrumentCategoryCode"].ToString();
ddlSwtchShmCat.DataTextField = dsCategory.Tables[0].Columns["PAIC_AssetInstrumentCategoryName"].ToString();
ddlSwtchShmCat.DataBind();
ddlSwtchShmCat.Items.Insert(0, new ListItem("All", "0"));
}
}