怎样判断数据库中是否有记录

[yunboonline]

怎样判断数据库中是否有记录

[hzybc]

RS.RecordCount 是否为0

[Intelement]

SELECT COUNT(*) FROM TblName

[online]

1. if RS.RecordCount=0 then
2.select count(*) as ll from table
if rs.field("ll")>0 then

[Daniel0318]

同意楼上

[wxy001]

rs.recordcout=0

[greenhandstone]

以SQLSERVER为例
Dim strTemp As String
Dim adoRs As New ADODB.Recordset
Dim adoConn As New ADODB.Connection
strTemp=strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=连接的数据库名;Data Source=连接的计算机名"
adoconn.open strTemp, "用户名", "密码"
set adoRs=nothing
strTemp="select * from 表名"
adoRs.open strtemp,adoconn
if adors.eof or adors.bof then
msgbox "数据库中无记录"
end if

[wdwd05]

SQL语句判断有几个记录~~
SELECT COUNT(*) FROM TblName

ADODB编程判断有几条记录~~
if RS.RecordCount=0 then
Msgbox "数据库里面没有记录"
end if

还有一种就是判断记录是否为结尾和开头的方法
if rs.eof and rs.bof then
Msgbox "数据库里面没有记录"
end if

[shuchang0626]

recordset.recordcount=0
就没有记录