How many items are there in my dataset??

[andfa]

Number of items???
I use the following code to retreive records from an ACCESS database and everything works fine. How do I find out how many items there are in the dataset or the dataadapter??

________________________________________________
strsql = "select * from spis where titel like '%" & TextBox1.Text & "'"
objda = New OleDb.OleDbDataAdapter(strsql, objconn)
ds.Clear()
DataGrid1.DataSource = ds
objda.Fill(ds)
DataGrid1.DataBind()

----------------------------------------------------------------------

[tattenhoe]

I think this should work

John


Ds.Clear()
OleDbDataAdapter1.Fill(Ds, "table")

Dim iCnt As Integer

iCnt = Ds.Tables("table").Rows.Count

[andfa]

No, that was not a good idea, I'm afraid. Thanks anyway.

My problem is that I execute a SQL-query and that makes the number of records different each time. So, looking at the number of records in the table is not the solution here. I would like to have the number of records in the dataset or in the datagrid for displaying the number of search hits to the user.

/Anders

[scostell]

what tattenhoe said will work for what you want. The dataset will hold the information that you got using the SQL Statement. The table name will be the name you gave the resultset that the dataset is holding. or something like that.

[andfa]

I didn't understand all of it at first!

Thank you for your help.

/Anders