countiing no. of record that has been retrived

لا تستطيع عمل ذلك بال Data Reader مباشرة، يجب أن تعد النواتج يدويا.

بالتوفيق

DataReader dr=cmd.ExecuteReader();
int numberOfRecords=0;
while(dr.Read())
{
//..write your code here
numberOfRecords++;
}
dr.Close();

' read the number of rows
Dim cmd As New SqlCommand("SELECT COUNT(*) FROM Customers", cn)
Dim totalRows As Long = CInt(cmd.ExecuteScalar())

' read the individual rows
cmd = New SqlCommand("SELECT * FROM Customers", cn)
Dim dr As SqlDataReader = cmd.ExecuteReader()

إذا كنت تستخدم الـ StoredProcedure في الـ SQL Server:

اكتب داخل الإجرائية:

// Into Your Procedure
select * from YOUR_TABLE
select count(*) AS ItemsCount from YOUR_TABLE

/// VB.NET Code
Dim r As SqlDataReader = com.ExecuteReader()
While r.Read()

// Get Your Data Here

End While

If r.NextResult And r.Read() Then
    ItemsCount = Convert.ToInt32(r("ItemsCount"))
End If