Dim m_WapShow As New BikeWap
Dim m_Url As String
m_Url = Request.ServerVariables("APPL_PHYSICAL_PATH") & "\mydatabase\#bikewap.mdb"
Dim m_Dr As OleDbDataReader = m_WapShow.GetData(m_Url, "select * from guestbook order by AddTime desc")
NewList.DataSource = m_Dr
NewList.DataTextField = "MessageTitle"
NewList.DataValueField = "MessageID"
NewList.DataBind()------------------
先谢谢各位了:)
Dim m_Url As String
m_Url = Request.ServerVariables("APPL_PHYSICAL_PATH") & "\mydatabase\#bikewap.mdb"
Dim m_Dr As OleDbDataReader = m_WapShow.GetData(m_Url, "select * from guestbook order by AddTime desc")
NewList.DataSource = m_Dr
NewList.DataTextField = "MessageTitle"
NewList.DataValueField = "MessageID"
NewList.DataBind()------------------
先谢谢各位了:)
解决方案 »
- 类型化dataset不能修改数据库
- asp.net 如何获取webservice void方法体内 response的内容
- 在问个textBox的值该变问题????
- 简单问题.....petshop的命名空间问题
- 我在本地VS205里做好页面,传到服务器里就是处理URL错误!
- 高分请教treeview和DIV的问题.
- 请教关于控件隐藏/显示后的对齐问题:
- 急急急:framework1.1打了SP1后,原来的程序点击按钮都没反应了
- 高手帮忙加个注释
- 关于定制IE?
- 请问这个问题是怎么回事?System.ArgumentNullException: 值不能为空。参数名: String
- 为什么在asp.net中插入asp代码,会出现乱码
一般的连接偶会就是调用类的SQL连接类,我不会,所以会的朋友们请帮忙
'在此处放置初始化页的用户代码
Dim m_WapShow As New BikeWap
Dim m_Url As String
m_Url = Request.ServerVariables("APPL_PHYSICAL_PATH") & "\mydatabase\#bikewap.mdb"
Dim m_Dr As OleDbDataReader = m_WapShow.GetData(m_Url, "select * from guestbook order by AddTime desc")
NewList.DataSource = m_Dr
NewList.DataTextField = "MessageTitle"
NewList.DataValueField = "MessageID"
NewList.DataBind()
End Sub
---------------------------
BikeWap.vb类 Imports System.Data
Imports System.Data.OleDb
Public Class BikeWap
'获取数据库中的信息
Public Function GetData(ByVal DatabaseUrl As String, ByVal StrSQL As String)
Dim StrConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DatabaseUrl
Dim Conn As New OleDbConnection(StrConn)
Dim Cmd As OleDbCommand = New OleDbCommand(StrSQL, Conn)
Conn.Open()
Dim Result As OleDbDataReader = Cmd.ExecuteReader(CommandBehavior.CloseConnection)
'Dim Result As OleDbDataReader = Cmd.ExecuteReader(CommandBehavior.SingleRow)
Return Result
End Function
Dim StrConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DatabaseUrl
这里的provider要改成sqloledb
然后databaseurl传入的字符串的格式也要相应改一下具体就是这两个地方:
Dim StrConn As String = "Provider=sqloledb;Data Source=" & DatabaseUrlDim m_Url As String = "服务器名;Initial Catalog=数据库名;User Id=用户名;Password=密码"呵呵 做wap啊……给分 给分^_^
Dim StrConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DatabaseUrl
这里的provider要改成sqloledb
然后databaseurl传入的字符串的格式也要相应改一下具体就是这两个地方:
Dim StrConn As String = "Provider=sqloledb;Data Source=" & DatabaseUrlDim m_Url As String = "服务器名;Initial Catalog=数据库名;User Id=用户名;Password=密码"呵呵 做wap啊……给分 给分^_^