Show messagebox if no data returned in datagridview

I have a SearchForm where user enters data in textboxes, btnSearchClick displays data in a datagridivew if there is data in the database. This works fine.

If no data is returned, I need message box to say no search returned, enter a new record.

My messagebox pops up for both when there are records returned AND when there are no records returned.

private void btnSearch_Click(object sender, EventArgs e)         
{             

//this binds all textboxes to the dgv. This works fine
BindData();

dgvSearch.DataSource = bindingSource1;

//Need help here. Only display messagebox if there are no records returned.

//It pops up each time, even when there are records returned.

if (dgvSearch.Rows.Count < -1)
{
dgvSearch.ReadOnly = true;
}
else
{
MessageBox.Show("No search results returned, clear your search and enter new case");
} }

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Syed Shanu11y ago
Accepted answer
What is the bindingSource1. is that dataset or Datatable. Iam Assume that its a data set. then you can test like this. if(bindingSource1.Tables[0].Rows.Count<=0) { MessageBox.Show("No search results returned, clear your search and enter new case"); reutn; } dgvSearch.DataSource = bindingSource1;
sammi taylor11y ago
Perfect! that worked. Thank you Syed.
Akhil Garg11y ago
Instead of checking dgvSearch in if condition check bindingSource1.