Check if datagridview is empty

[KeesBlunder]

Hello,

I fill a datagridview but how do i check if the datagridview is empty

or if there is no data in the database to fill the datagridview ?

cmd = New SqlCeCommand("SELECT Id, Trip, Tons FROM Numbers ", con)

If con.State = ConnectionState.Closed Then con.Open()
myDA = New SqlCeDataAdapter(cmd)
myDataSet = New DataSet()
myDA.Fill(myDataSet, "MyTable")
DataGridView1.DataSource = myDataSet.Tables("MyTable").DefaultView

If con.State = ConnectionState.Open Then con.Close()

Continue reading...