Function getnewss(ByVal id As String) As OleDbDataReader
Dim dr As OleDbDataReader
Dim conn As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=j:\fsxx\data\fsxx.mdb")
conn.Open()
Dim cmd As New OleDbCommand("select * from news_content where id=" & id, conn)
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection) If conn.State = ConnectionState.Connecting Then
conn.Close()
End If Return dr
End Function
数据库存在,并且有数据.但是运行时缺出问题,提示:不存在此行/列的数据。改成用datatable就好使了.代码如下:
Function getanews(ByVal id As String) As DataTable
Dim dt As New DataTable
Dim ds As New DataSet
Dim conn As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=j:\fsxx\data\fsxx.mdb")
conn.Open() Dim dataadap As New OleDbDataAdapter("select * from news_content where id=" & id, conn)
dataadap.Fill(ds, "news")
dt = ds.Tables("news")
If conn.State = ConnectionState.Connecting Then
conn.Close()
End If Return dt
End Function请问是怎么回事?
Dim dr As OleDbDataReader
Dim conn As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=j:\fsxx\data\fsxx.mdb")
conn.Open()
Dim cmd As New OleDbCommand("select * from news_content where id=" & id, conn)
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection) If conn.State = ConnectionState.Connecting Then
conn.Close()
End If Return dr
End Function
数据库存在,并且有数据.但是运行时缺出问题,提示:不存在此行/列的数据。改成用datatable就好使了.代码如下:
Function getanews(ByVal id As String) As DataTable
Dim dt As New DataTable
Dim ds As New DataSet
Dim conn As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=j:\fsxx\data\fsxx.mdb")
conn.Open() Dim dataadap As New OleDbDataAdapter("select * from news_content where id=" & id, conn)
dataadap.Fill(ds, "news")
dt = ds.Tables("news")
If conn.State = ConnectionState.Connecting Then
conn.Close()
End If Return dt
End Function请问是怎么回事?
解决方案 »
- datalist问题
- 关于updatepanel回传之后JS失效问题!!!!!!!!!!!!!!!!!!!
- Datalist 我不想套用表格,自己定义表格可以吗?
- SqlDataSource连接数据库的问题
- 在panel中加入html控件中的table???
- 已知一个object。如何得到他本来类型的引用?
- web.config问题
- 问一下 VS2008开发的网站 为什么不能Release编译?
- 权限通用设计,请大神们进!
- ASP.Net中,文件读写的锁机制如何实现?一个线程先读后写,在整个过程中,另外的线程无法读
- 有幸被选为斑竹,非常高兴,特来散分.
- 有请cuike519,新当选的斑主cuike519,您能不能公布一个组件源码供我们这些菜鸟学习。。谢谢您了。cuike519
Dim conn As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=j:\fsxx\data\fsxx.mdb")
改成:
Dim conn As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=j"&
server.mappath("data\fsxx.mdb"))
为什么就不好使呢
Dim conn As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=j:\fsxx\data\fsxx.mdb")
改成:
Dim conn As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=j"&
server.mappath("data\fsxx.mdb"))
为什么就不好使呢
------------------Dim conn As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" &
server.mappath("data\fsxx.mdb"))
为什么就不好使呢
要
imports system.web
imports system.web.ui
public class myclass
inherits page
.....
建议使用:System.Web.HttpContext.Current.Request.PhysicalApplicationPath()
这个函数来取路径。