上个方法不好,,,,有专门的返回计算值的方法,,,就是这个ExecuteScalar    代码少了不少

Dim strConn, strSQL As String
Dim myConn As OleDbConnection
Dim myCommand As OleDbCommand
dim cont as integer
strsql = "select * from table"
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(".") & "/db1.mdb"
myConn = New OleDbConnection(strConn)
myCommand = New OleDbCommand(strSQL, myConn)
myConn.Open()
cont = myCommand.ExecuteScalar()
myConn.Close()
response.write(CONT)
posted on 2005-07-24 23:21  aaron.net  阅读(2219)  评论(0编辑  收藏  举报