I am currently using the code below to retrive the total row in my table. The problem is that I need to create a datagridview on the form in order to calculate the count. So is there anyway to store maybe a memory table so I don't need to have a datagridview around the form?Thank you.

Dim sqlstr As String = "select * from plgcuta "
Dim connection As New SqlConnection(connectionString)
da = New SqlDataAdapter(sqlstr, connection)
dgv.DataSource = ds.Tables(0)

dim count as integer = dgv.rows.count

You can use DataTable

dt.Rows.Count

Hi, lucashii,

Based on my understanding, you want to get the row count of your returned DataSet, don't you.

I think Tamirro's idea is right, and to make the answer clear.

You can use

Hope this helps,

Regards

You can use DataTable

dt.Rows.Count

Hi, lucashii,

Based on my understanding, you want to get the row count of your returned DataSet, don't you.

I think Tamirro's idea is right, and to make the answer clear.

You can use

Hope this helps,

Regards