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);
}
}
}
