// Button 'Search'
// Search guest archive
private void buttonSearchGuest_Click(object sender, EventArgs e)
{
string searchinput = @textBoxSearch.Text.Trim();
// Fetch dataset
DataSet guestListDS = DBGetData.GetGuestListSearch(searchinput);
if (guestListDS != null)
{
// No tables fetched
if (guestListDS.Tables.Count == 0)
{
MessageBox.Show("No guest datatable found, contact administrator.");
return;
}
// No rows fetched
else if (guestListDS.Tables[0].Rows.Count == 0)
{
MessageBox.Show("No search result found in guest table.");
return;
}
// Set the dataset as source for listbox
listBoxGuest.ValueMember = "guestid";
listBoxGuest.DisplayMember = "guest_name";
listBoxGuest.DataSource = guestListDS.Tables[0];
}
}
