get rows returned from data adapter

[mikemilano]

OdbcDataAdapter da = new OdbcDataAdapter(sql,con); DataSet ds = new DataSet(); da.Fill(ds,"Contacts"); dataGrid1.SetDataBinding(ds,"Contacts"); i need to get the total rows returned from my sql query similar to how ExecuteNonQuery() works. how can i get the total rows in a data grid, data set, or data adapter?

[Alexander Kojevnikov]

Use ds.Tables["MyTable"].Rows.Count property to get the total number of rows in MyTable DataTable. Alexandre Kojevnikov MCAD charter member Leuven, Belgium

[mikemilano]

I thank you so much!