private void BindIssuerDropdown() { DataSet dsLookupData = commisionReceivableBo.GetProdAmc(); //Populating the categories dropdown DataRow drProduct = dsLookupData.Tables[0].NewRow(); drProduct["PA_AMCCode"] = 0; drProduct["PA_AMCName"] = "All"; dsLookupData.Tables[0].Rows.InsertAt(drProduct, 0); ddIssuer.DataSource = dsLookupData.Tables[0]; ddIssuer.DataValueField = dsLookupData.Tables[0].Columns["PA_AMCCode"].ToString(); ddIssuer.DataTextField = dsLookupData.Tables[0].Columns["PA_AMCName"].ToString(); ddIssuer.DataBind(); }