no dataset in asp.net 2.0?

[calvin]

Hi,

Im novice in asp.net 2.0. Since in version 1.1, when i call a select query to check is data available in database table, I use dataset to get the count of row if it is equal to zero, then do something...

However, I found the feature no longer exist in version 2.0. So, Is anyone know how to do such a "function" to check the number of row return?

Appreciate for any help and suggestion. Thank you.


Calvin

 

[tfowler]

The DataSet object still exists:

[font=Courier New][size=2]System.Data.DataSet
[/size][/font]

Although, I would think that you wouldnt want all of that overhead just to determine if there is data in a database table. Why wouldnt you use something like:

Dim con As New System.Data.SqlClient.SqlConnection(<your connection string>)
Dim com As New System.Data.SqlClient.SqlCommand("SELECT COUNT(*) FROM <your table name>", con)
 
con.Open()
Dim rowCount As Integer = CType(com.ExecuteScalar, Integer)
con.Close()

If you are going to use the data in the DataSet after you check to see if it has rows, then, by all means, fill the DataSet. But, dont just fill a DataSet to check the number of rows and then discard it.

Todd