标题:如何获得表里记录的条数?
取消只看楼主
zhuifengjian
Rank: 1
等 级:新手上路
帖 子:108
专家分:0
注 册:2006-12-31
 问题点数:0 回复次数:3 
如何获得表里记录的条数?
各位大哥!!!!!!!!!!怎样获得留言表里记录的条数啊??
Dim conn As OleDbConnection
Dim conStr As String
Dim rs As OleDbDataReader
conStr = "provider=microsoft.jet.oledb.4.0;data source=" & Server.MapPath("data\留言.mdb")
conn = New OleDbConnection(conStr)
Dim comm As OleDbCommand
Dim comStr As String
comStr = "select * from 留言表"
comm = New OleDbCommand(comStr, conn)
Dim da As New OleDbDataAdapter
Dim ds As New DataSet
da.SelectCommand = comm
conn.Open()
da.Fill(ds, "留言表") '执行selectComma
e = ds.Tables(0).Rows.Count()
DataGrid1.DataSource = ds
DataGrid1.DataBind() '将数据集"ds"绑定到DataGrid1
conn.Close()
搜索更多相关主题的帖子: 表里 Dim conn comStr 
2007-01-12 20:49
zhuifengjian
Rank: 1
等 级:新手上路
帖 子:108
专家分:0
注 册:2006-12-31
得分:0 
数据读取器????能说明一点吗..小弟还是新手!!!!!呵呵
2007-01-12 21:17
zhuifengjian
Rank: 1
等 级:新手上路
帖 子:108
专家分:0
注 册:2006-12-31
得分:0 

我改成这样了..................不过还是不行
label12.text显示这个...System.EventArgs

[CODE]Dim conn As OleDbConnection
Dim conStr As String
Dim rs As OleDbDataReader
conStr = "provider=microsoft.jet.oledb.4.0;data source=" & Server.MapPath("data\留言.mdb")
conn = New OleDbConnection(conStr)
Dim comm As OleDbCommand
Dim comStr As String
comStr = "select * from 留言表"
comm = New OleDbCommand(comStr, conn)
Dim da As New OleDbDataAdapter
Dim ds As New DataSet
da.SelectCommand = comm
conn.Open()
da.Fill(ds, "留言表") '执行selectComma
Dim e As Integer
e = 0
rs = comm.ExecuteReader()
While (rs.Read())
e = e + 1
End While
Label12.Text = e
'e = ds.Tables(0).Rows.Count
DataGrid1.DataSource = ds
DataGrid1.DataBind() '将数据集"ds"绑定到DataGrid1
conn.Close()[/CODE]

2007-01-13 09:48
zhuifengjian
Rank: 1
等 级:新手上路
帖 子:108
专家分:0
注 册:2006-12-31
得分:0 
嘿..........终于知道那里出错拉.................label12.text 接收的是字符型
2007-01-13 09:53



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-115673-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.077413 second(s), 8 queries.
Copyright©2004-2025, BCCN.NET, All Rights Reserved