asp.net中怎么判断记录集条数?

来源:百度知道 编辑:UC知道 时间:2024/06/03 19:20:49
在asp中记录条数可以用rs.recordcount表示,asp.net中我想判断条数怎么实现?

我做的是用户登陆程序,代码如下,请高手告诉我怎么判断有这条记录:

Dim varadname As String
Dim varadpass As String
varadname = Trim(Request.Form("adname"))
varadpass = Trim(Request.Form("adpass"))

'连接数据库
Dim myfile As String = Server.MapPath("")
Dim constr As String = "provider=microsoft.jet.oledb.4.0;data source=" & myfile & "\ku.mdb"
Dim conn As OleDbConnection = New OleDbConnection()
conn.ConnectionString = constr
conn.Open()

Dim cmd As New OleDbCommand
cmd.Connection = conn
cmd.CommandText = "select * from admin where adname='" & varadname & "' and adpass='" & varadpass & "'"
cmd.ExecuteNonQuery()

填充数据表用OleDbDataAdapter
Dim conn As New OleDbConnection(connection)
Dim adapter As New OleDbDataAdapter()
Dim dataset As New DataSet
adapter.SelectCommand = new OleDbCommand(query, conn)
adapter.Fill(dataset)

或者可以直接用DataTable代替DataSet

你直接写cmd.ExecuteNonQuery()>0试试