给你个例子 Dim cnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("xxxxx.mdb")
Dim strSQL As String = "SELECT Document.objectGuid,Document.Title,Document.Author,Document.Source, Document.CreateDate,Document.HitCount,Subject.Title FROM Document INNER JOIN Subject ON [Subject].[id]=[Document].[pid] ORDER By CreateDate DESC"
Dim cn As New OleDbConnection(cnString)
cn.Open()
Dim cmd As New OleDbCommand(strSQL, cn)
Dim db As OleDbDataReader
db = cmd.ExecuteReader(CommandBehavior.CloseConnection)
EditDoc.DataSource = db
EditDoc.DataBind()
cn.Close()
cn = Nothing
cmd = Nothing
Dim strSQL As String = "SELECT Document.objectGuid,Document.Title,Document.Author,Document.Source, Document.CreateDate,Document.HitCount,Subject.Title FROM Document INNER JOIN Subject ON [Subject].[id]=[Document].[pid] ORDER By CreateDate DESC"
Dim cn As New OleDbConnection(cnString)
cn.Open()
Dim cmd As New OleDbCommand(strSQL, cn)
Dim db As OleDbDataReader
db = cmd.ExecuteReader(CommandBehavior.CloseConnection)
EditDoc.DataSource = db
EditDoc.DataBind()
cn.Close()
cn = Nothing
cmd = Nothing
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货