public void ClientSelect() { using (var clientTB = new db_ptcDataContext()) { ClientDropDownList.DataSource = from Client in clientTB.Clients orderby Client.ClientName select new { Client.ClientName, Client.ClientId }; ClientDropDownList.DataTextField = "ClientName"; ClientDropDownList.DataValueField = "ClientId"; ClientDropDownList.DataBind(); ClientDropDownList.Items.Insert(0, new ListItem("Search Client", "NA")); } }
protected void fillClientDropDownList() { SLHSClinicEntities db = new SLHSClinicEntities(); List <CustomListItem> clientNameList; clientNameList = db.Clients.Select(x => new CustomListItem { ID = x.ClientID, Text = x.FirstName + " " + x.MiddleName + " " + x.LastName }).ToList(); ClientDropDownList.DataSource = clientNameList; ClientDropDownList.DataTextField = "Text"; ClientDropDownList.DataValueField = "ID"; ClientDropDownList.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { Display(); if (!IsPostBack) { CancleButton.Visible = false; UpdateButton.Visible = false; sucess.Visible = false; using (SqlConnection connection = new SqlConnection(con)) { SqlCommand cmd = new SqlCommand("DisplayClientName", connection); cmd.CommandType = CommandType.StoredProcedure; connection.Open(); SqlDataReader rdr = cmd.ExecuteReader(); ClientDropDownList.DataSource = rdr; ClientDropDownList.DataTextField = "CName"; ClientDropDownList.DataValueField = "CId"; ClientDropDownList.DataBind(); ListItem list = new ListItem("--Select--", "-1"); ClientDropDownList.Items.Insert(0, list); } } }