// Button 'Search' in the room section
// Searches result in relevant tables from textinput
private void buttonSearchBookingRoom_Click(object sender, EventArgs e)
{
string searchinput = @textBoxSearch.Text.Trim();
// Fetch dataset
DataSet roomreservationDS = DBGetData.GetRoomBookingDGVSearch(searchinput);
if (roomreservationDS != null)
{
// No tables fetched
if (roomreservationDS.Tables.Count == 0)
{
new StatusMessage("No datatable found, contact administrator.");
return;
}
// No rows fetched
else if (roomreservationDS.Tables[0].Rows.Count == 0)
{
new StatusMessage("No datarows found for search.");
return;
}
// Clear labelStatus for previous messages
else
{
new StatusMessage("");
}
// Set the dataset as source for datagridview and make sure its displayed
dataGridViewRoom.DataSource = roomreservationDS;
dataGridViewRoom.DataMember = "Get_RR_Search";
LoadDataGridViewRoom();
}
}
