private void BindAgents() { try { blAr._Action = "GetAllAgents"; dtGetReturnedData = dlAr.BindControls(blAr); List <BALAgent> agents = new List <BALAgent>(); if (dtGetReturnedData != null && dtGetReturnedData.Rows.Count > 0) { foreach (DataRow row in dtGetReturnedData.Rows) { BALAgent agent = new BALAgent { AgentId = Convert.ToInt32(row["AgentId"].ToString()), AgentName = DataSecurityManager.Decrypt(row["AgentName"].ToString()) }; agents.Add(agent); } List <BALAgent> sortedAgents = agents.OrderBy(a => a.AgentName).ToList(); ddlAgents.DataSource = sortedAgents; ddlAgents.DataTextField = "AgentName"; ddlAgents.DataValueField = "AgentId"; ddlAgents.DataBind(); ddlAgents.Items.Insert(0, "-Select-"); } else { GridAccomodations.DataSource = null; GridAccomodations.DataBind(); } } catch (Exception sqe) { GridAccomodations.DataSource = null; GridAccomodations.DataBind(); } }
private void BindAccomGrid() { try { blAr._Action = "GetAccomodations"; dtGetReturnedData = dlAr.BindControls(blAr); if (dtGetReturnedData != null && dtGetReturnedData.Rows.Count > 0) { GridAccomodations.DataSource = dtGetReturnedData; GridAccomodations.DataBind(); } else { GridAccomodations.DataSource = null; GridAccomodations.DataBind(); } } catch (Exception sqe) { GridAccomodations.DataSource = null; GridAccomodations.DataBind(); } }