protected void BindfundType() { try { ddlLkLookupViewname.DataSource = FundTypeData.GetFundType("GetFundType"); ddlLkLookupViewname.DataValueField = "TypeId"; ddlLkLookupViewname.DataTextField = "Description"; ddlLkLookupViewname.DataBind(); ddlLkLookupViewname.Items.Insert(0, new ListItem("Select", "NA")); } catch (Exception ex) { lblErrorMsg.Text = ex.Message; } }
protected void BindLookups() { try { dtable = new DataTable(); dtable = FundTypeData.GetFundType("GetFundTypeData"); ddlFundType.DataSource = dtable; ddlFundType.DataValueField = "typeid"; ddlFundType.DataTextField = "description"; ddlFundType.DataBind(); ddlFundType.Items.Insert(0, new ListItem("Select", "NA")); dtable = new DataTable(); dtable = FinancialTransactions.GetLookupDetailsByName("LkAcctMethod"); ddlAcctMethod.DataSource = dtable; ddlAcctMethod.DataValueField = "typeid"; ddlAcctMethod.DataTextField = "description"; ddlAcctMethod.DataBind(); ddlAcctMethod.Items.Insert(0, new ListItem("Select", "NA")); dtable = new DataTable(); dtable = FinancialTransactions.GetLookupDetailsByName("LkGrantor"); ddlGrantor.DataSource = dtable; ddlGrantor.DataValueField = "typeid"; ddlGrantor.DataTextField = "description"; ddlGrantor.DataBind(); ddlGrantor.Items.Insert(0, new ListItem("Select", "NA")); dtable = new DataTable(); dtable = FinancialTransactions.GetLookupDetailsByName("LkYear"); ddlFiscalYr.DataSource = dtable; ddlFiscalYr.DataValueField = "typeid"; ddlFiscalYr.DataTextField = "description"; ddlFiscalYr.DataBind(); ddlFiscalYr.Items.Insert(0, new ListItem("Select", "NA")); dtable = new DataTable(); dtable = FinancialTransactions.GetLookupDetailsByName("LKGrantSource"); ddlGrantSource.DataSource = dtable; ddlGrantSource.DataValueField = "typeid"; ddlGrantSource.DataTextField = "description"; ddlGrantSource.DataBind(); ddlGrantSource.Items.Insert(0, new ListItem("Select", "NA")); dtable = new DataTable(); dtable = FinancialTransactions.GetDataTableByProcName("GetStaffUsers"); ddlStaff.DataSource = dtable; ddlStaff.DataValueField = "userid"; ddlStaff.DataTextField = "name"; ddlStaff.DataBind(); ddlStaff.Items.Insert(0, new ListItem("Select", "NA")); dtable = new DataTable(); dtable = FinancialTransactions.GetDataTableByProcName("GetContactUsers"); ddlContact.DataSource = dtable; ddlContact.DataValueField = "contactid"; ddlContact.DataTextField = "name"; ddlContact.DataBind(); ddlContact.Items.Insert(0, new ListItem("Select", "NA")); } catch (Exception ex) { lblErrorMsg.Text = ex.Message; } }