protected void BindProjects() { try { DataTable dtProjects = new DataTable(); dtProjects = Project.GetProjects("GetProjects"); ddlProjFilter.DataSource = dtProjects; ddlProjFilter.DataValueField = "projectId"; ddlProjFilter.DataTextField = "Proj_num"; ddlProjFilter.DataBind(); ddlProjFilter.Items.Insert(0, new ListItem("Select", "NA")); ddlProjFilter.Items.Insert(1, new ListItem("All", "-1")); ddlFinancialTrans.DataSource = FinancialTransactions.GetBoardFinancialTrans(); ddlFinancialTrans.DataValueField = "TypeID"; ddlFinancialTrans.DataTextField = "Description"; ddlFinancialTrans.DataBind(); ddlFinancialTrans.Items.Insert(0, new ListItem("Select Financial Transaction", "0")); ddlFinancialTrans.Items.Insert(1, new ListItem("All", "-1")); } catch (Exception ex) { lblErrorMsg.Text = ex.Message; } }