// Button 'Search' private void buttonSearchPaymentItem_Click(object sender, EventArgs e) { string searchinput = @textBoxSearch.Text.Trim(); // Fetch dataset DataSet paymentitemDS = DBGetData.GetPaymentItemDGVSearch(searchinput); if (paymentitemDS != null) { // No tables fetched if (paymentitemDS.Tables.Count == 0) { new StatusMessage("No datatable found, contact administrator."); return; } // No rows fetched else if (paymentitemDS.Tables[0].Rows.Count == 0) { new StatusMessage("No datarows found matching search."); return; } // Clear labelStatus for previous messages else { new StatusMessage(""); } // Set the dataset as source for datagridview and make sure its displayed dataGridViewPaymentItem.DataSource = paymentitemDS; dataGridViewPaymentItem.DataMember = "Get_PaymentItem_Search"; LoadDataGridViewPaymentItem(); } }