public void loadDDlClinicName() { if (!Page.IsPostBack) { systemBusinessLayer = new BusinessLayer(); ArrayList clinicList = new ArrayList(); clinicList = systemBusinessLayer.getClinics(); ddlClinicName.DataSource = clinicList; ddlClinicName.DataTextField = "ClinicName"; ddlClinicName.DataValueField = "ClinicRefNumber"; ddlClinicName.DataBind(); ddlClinicName.Items.Insert(0, ".:Select Clinic:."); } }
public ArrayList getClinics() { using (SqlConnection con = new SqlConnection(ConnString)) { SqlCommand cmd = new SqlCommand("procGetClinics", con); cmd.CommandType = CommandType.StoredProcedure; ArrayList clinicList = new ArrayList(); try { con.Open(); SqlDataReader read = cmd.ExecuteReader(); while (read.Read()) { ClsClinic clinics = new ClsClinic(Convert.ToString(read["ClinicName"]), Convert.ToString(read["ClinicRefNr"])); clinicList.Add(clinics); } read.Close(); } catch (Exception exp) { throw new ApplicationException(exp.Message); } return clinicList; } }
ddlClinicName.DataSource = clinicList;
clinicList
ddlClinicName
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)