SqlDataAdapter Binding Empty Data

I have a block of code that does a Fill() with a DataAdapter, which seems to throw an exception if no values are returned. Then, when I try to bind the DataSet that gets filled, an error occurs, it doesn't even try to bind the column headers or anything.





This process seems to work fine when some rows are found, but it is not always guaranteed that the row count will always be > 0. The nice thing about using the Fill() function, is that it creates all my column headers automatically, so I was just wondering if there's a way to do a Fill() then a subsequent DataBind() to a DataGrid which would automatically format the columns even when no rows are found?





Here's a bit of the source.. if the last line finds no rows, it throws an exception ( I assume this is normal):





strSQL = "SELECT * FROM Prods";


cm.CommandText = strSQL;


da = new SqlDataAdapter( cm );


da.Fill(shelf);





Anyone got any ideas on how to fix this problem?








Brent