private void NamesForm_Load(object sender, EventArgs e)
{
// the query
string qry = string.Format(SchoolDatabase.STUDENTS_BY_YEAR_GROUP, "Lower 8");
// get the connection string from the app.config
// NB. the database file must be in a directory that the process can write to (there'll be a lockfile)
try
{
DataSet ds = _schoolDatabase.GetMeSomeData(qry);
// bind the dataset to the combobox
namesComboBox.DataSource = ds.Tables[0];
namesComboBox.ValueMember = "ID"; // these are the field names returned from the query.
namesComboBox.DisplayMember = "Student";
lblSelected.Text = "No-one selected yet";
}
catch (Exception ex)
{
lblSelected.Text = ex.Message;
}
}