Hide datagrid when it contains no rows

[wassssup]

i want to know is there a way to check wherether is there data inside a datagrid and hide the datagrid when there isn't any.
for example i drag the datagridview from the toolbox and put it on the windows form, then in the coding i put :
"select * from table where balance <50";
it should display only items below 50, but when there isn't any(all items are above 50), i want to hide the datagrid....is there a way to do this?

[dip_developer]

i want to know is there a way to check wherether is there data inside a datagrid and hide the datagrid when there isn't any.
for example i drag the datagridview from the toolbox and put it on the windows form, then in the coding i put :
"select * from table where balance <50";
it should display only items below 50, but when there isn't any(all items are above 50), i want to hide the datagrid....is there a way to do this?

what is the problem..? Datagrid has a visible property...make it to False when needed.....

when number of records ==0 make Datagrid.Visible=False......after that make it to true when needed......

[wassssup]

thats what i thought so also...but is there a way like to know if it is zero?
how you translate "number of records=0" into C#?

[dip_developer]

thats what i thought so also...but is there a way like to know if it is zero?
how you translate "number of records=0" into C#?

are you using datset or datareader..??? then they have a Count property .......you can have the total number of records by writing
myDataSet.Tables(0).Rows.Count or myDataReader.RecordsAffected

 if (myDataSet.Tables(0).Rows.Count = 0) 
{
DataGrid1.Visible=False
}
else
{
DataGrid1.Visible=True
}
 

[wassssup]

are you using datset or datareader..??? then they have a Count property .......you can have the total number of records by writing
myDataSet.Tables(0).Rows.Count or myDataReader.RecordsAffected

 if (myDataSet.Tables(0).Rows.Count = 0) 
{
DataGrid1.Visible=False
}
else
{
DataGrid1.Visible=True
}
 

this is it....thank you very much!!!