源码
Dim dbpath As String
Dim constr As String
Dim mycon As OleDbConnection
Dim dbset As DataSet
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
dbpath = Server.MapPath("jh.mdb")
constr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & dbpath
mycon = New OleDbConnection(constr)
mycon.Open()
Dim sqlstr As String = "select * from product"
Dim mydc As New OleDbDataAdapter(sqlstr, mycon)
mydc.Fill(dbset, "product")
DataGrid1.DataSource = dbset
DataGrid1.DataBind()
End Sub错误提示异常详细信息: System.Data.OleDb.OleDbException: 不能使用 '';文件已在使用中。
Dim dbpath As String
Dim constr As String
Dim mycon As OleDbConnection
Dim dbset As DataSet
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
dbpath = Server.MapPath("jh.mdb")
constr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & dbpath
mycon = New OleDbConnection(constr)
mycon.Open()
Dim sqlstr As String = "select * from product"
Dim mydc As New OleDbDataAdapter(sqlstr, mycon)
mydc.Fill(dbset, "product")
DataGrid1.DataSource = dbset
DataGrid1.DataBind()
End Sub错误提示异常详细信息: System.Data.OleDb.OleDbException: 不能使用 '';文件已在使用中。
这一句一定要加
注销系统,
在代码里面加上那一句就行了。
Dim constr As String
Dim mycon As OleDbConnection
Dim dbset As DataSet
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
dbpath = Server.MapPath("jh.mdb")
constr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & dbpath
mycon = New OleDbConnection(constr)
mycon.Open()
Dim sqlstr As String = "select * from product"
Dim mydc As New OleDbDataAdapter(sqlstr, mycon) ‘错误
mydc.Fill(dbset, "product")
DataGrid1.DataSource = dbset
DataGrid1.DataBind()
End Sub我建议你这么写 Dim dbpath As String
Dim constr As String
Dim mycon As OleDbConnection
Dim mydc As OleDbDataAdapter
Dim dbset As DataSet
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
dbpath = Server.MapPath("jh.mdb")
constr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & dbpath
mycon = New OleDbConnection(constr)
mycon.Open()
Dim sqlstr As String = "select * from product"
mydc = New OleDbDataAdapter(sqlstr, mycon)
mydc.Fill(dbset, "product")
DataGrid1.DataSource = dbset
DataGrid1.DataBind()
mycon.close
End Sub我把他在上面定义了mydc了,你看一下代码,这样就好了,呵呵
格式化日期为2005-3-20
和
Dim mydc As OleDbDataAdapter
mydc = New OleDbDataAdapter(sqlstr, mycon)是等效的语句啊
如,url?sid={0}
Dim dbset As New DataSet