新手求助~SQL操作后.怎么知道返回了多少条记录?

[wzqx]

Dim connstr As String = "provider=Microsoft.Jet.Oledb.4.0;user ID =;password=; data source = c:\\ppp\ppp.mdb"
Dim cn As New OleDbConnection
Dim searchsql As String
Dim cmd As OleDbCommand
Dim dr As OleDbDataReader
searchsql = "select * from ppp where q='" + newq + "'"
Dim ii As Integer
Try
cn.ConnectionString = connstr
cn.Open()
cmd = (New OleDbCommand(searchsql, cn))
dr = cmd.ExecuteReader()

和VB RECORDSEET 差好多.唉@_@

[xiafan]

RECORDSEET,你可以用 DATASET。DATASE作为离线式数据库，使用更方便点。

[amandag]

在while循环DataReader 对象的时候循环计数，或者查询的时候返回记录总数