大家帮忙啊 关于数据库的问题

<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OLEDb"%>
<Script Language="VB" Runat="Server">
Sub Page_Load(sender As Object, E As EventArgs)
Dim cnA as oledbConnection
cnA=New oledbConnection
cnA.ConnectionString= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&server.mappath("infodb.mdb")&";"

cnA.Open

Dim strSQL as String = "SELECT * FROM Info_User"

'创建对象ADODatasetCommand 和 Dataset
Dim objDSCommand as oledbCommand
Dim objDataset as Dataset = New Dataset
objDSCommand = New oledbCommand(strSQL, cnA)

objDSCommand.Fill(objDataset,"User_Information")

cnA.Close() '关闭数据链路
cnA = Nothing '清除对象

user1.DataSource = objDataset.Tables("User_Information").DefaultView
user1.DataBind()

End Sub
</SCRIPT>

我这里错误是出在objDSCommand.Fill(objDataset,"User_Information")

编译器错误信息: BC30456: “Fill”不是“System.Data.OleDb.OleDbCommand”的成员。
我试过用FillDataSet 也不行
555

[1096 byte] By [iceflying-伤心箭] at [2008-2-16]
# 1
objDSCommand沒有fill這個方法啊
你可以用oleDbDataAdapter1
oleDbDataAdapter s=new oleDbDataAdapter(strSQL, cnA)
s.fill()就可以啦
Hero4444-阿神 at 2007-11-1 > top of Msdn China Tech,.NET技术,ASP.NET...
# 2
啊 我是照书上写的 难道这个也会错
要命了 我试试看 谢谢咯
iceflying-伤心箭 at 2007-11-1 > top of Msdn China Tech,.NET技术,ASP.NET...
# 3
为什么我觉得 .net 比asp慢很多啊
我在本机测试的
2000server + Iss5.0
iceflying-伤心箭 at 2007-11-1 > top of Msdn China Tech,.NET技术,ASP.NET...
# 4
oleDbDataAdapter s=new oleDbDataAdapter(strSQL, cnA)
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OLEDb"%>
<Script Language="VB" Runat="Server">
Sub Page_Load(sender As Object, E As EventArgs)
Dim cnA as oledbConnection
cnA=New oledbConnection
cnA.ConnectionString= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&server.mappath("infodb.mdb")&";"

cnA.Open

Dim strSQL as String = "SELECT * FROM Info_User"

'创建对象ADODatasetCommand 和 Dataset
Dim objAD as oledbdataadapter ''注意此行
Dim objDataset as Dataset = New Dataset
objAD = New oledbdataadapter(strSQL, cnA)''注意此行

objAD.Fill(objDataset,"Info_User")''注意此行

cnA.Close() '关闭数据链路
cnA = Nothing '清除对象

user1.DataSource = objDataset.Tables("User_Information").DefaultView
user1.DataBind()

End Sub
</script>
pingnt-淡蓝色的雪 at 2007-11-1 > top of Msdn China Tech,.NET技术,ASP.NET...
# 5
user1.DataSource = objDataset.Tables("User_Information").DefaultView
也应改为:
user1.DataSource = objDataset.Tables("Info_User").DefaultView
pingnt-淡蓝色的雪 at 2007-11-1 > top of Msdn China Tech,.NET技术,ASP.NET...
# 6
用fill()的是后,应该用 oleDataAdapter啊
不能用oleDataCommand
cyy1981-McRain at 2007-11-1 > top of Msdn China Tech,.NET技术,ASP.NET...