代码如下
sub page_load(s as object ,e as eventargs)
Dim conn as oledbconnection
Dim strselect As String
Dim strselect1 As String
Dim ascmd As OleDbCommand
Dim ascmd1 As OleDbCommand
Dim asreader As OleDbDataReader
Dim asreader1 As OleDbDataReader
Dim dbname As String
dbname=server.mappath("someelse/info.mdb")
conn = new oledbconnection("provider=microsoft.jet.oledb.4.0;data source="+dbname)
strselect = "select top 7 * from info order by id desc"
strselect1 = "select top 8 * from pic order by id desc"
ascmd = New OleDbCommand(strselect, conn)
ascmd1 = New OleDbCommand(strselect1, conn)
conn.Open()
asreader = ascmd.ExecuteReader()
asreader1 = ascmd1.ExecuteReader()
txt.DataSource = asreader
txt.DataBind()
txt2.DataSource = asreader1
txt2.DataBind()
asreader.Close()
asreader1.Close()
conn.Close()
end sub 在本地打开的时候是显示正常,但是上传到服务器就报错了,提示要关闭repeater
sub page_load(s as object ,e as eventargs)
Dim conn as oledbconnection
Dim strselect As String
Dim strselect1 As String
Dim ascmd As OleDbCommand
Dim ascmd1 As OleDbCommand
Dim asreader As OleDbDataReader
Dim asreader1 As OleDbDataReader
Dim dbname As String
dbname=server.mappath("someelse/info.mdb")
conn = new oledbconnection("provider=microsoft.jet.oledb.4.0;data source="+dbname)
strselect = "select top 7 * from info order by id desc"
strselect1 = "select top 8 * from pic order by id desc"
ascmd = New OleDbCommand(strselect, conn)
ascmd1 = New OleDbCommand(strselect1, conn)
conn.Open()
asreader = ascmd.ExecuteReader()
asreader1 = ascmd1.ExecuteReader()
txt.DataSource = asreader
txt.DataBind()
txt2.DataSource = asreader1
txt2.DataBind()
asreader.Close()
asreader1.Close()
conn.Close()
end sub 在本地打开的时候是显示正常,但是上传到服务器就报错了,提示要关闭repeater
Dim conn as oledbconnection
Dim strselect As String
Dim strselect1 As String
Dim ascmd As OleDbCommand
Dim ascmd1 As OleDbCommand
Dim asreader As OleDbDataReader
Dim asreader1 As OleDbDataReader
Dim dbname As String
dbname=server.mappath("someelse/info.mdb")
conn = new oledbconnection("provider=microsoft.jet.oledb.4.0;data source="+dbname)
strselect = "select top 7 * from info order by id desc"
strselect1 = "select top 8 * from pic order by id desc"
ascmd = New OleDbCommand(strselect, conn)
ascmd1 = New OleDbCommand(strselect1, conn)
conn.Open()
asreader = ascmd.ExecuteReader()
asreader1 = ascmd1.ExecuteReader()
txt.DataSource = asreader
txt.DataBind()
asreader.Close()
txt2.DataSource = asreader1
txt2.DataBind()
asreader1.Close()
conn.Close()
end sub 不建议使用datareader作为数据源来绑定
所以建议用datatable
或者:
关闭一个先
asreader = ascmd.ExecuteReader()
txt.DataSource = asreader txt.DataBind()
asreader.Close() //这是必须的.
asreader1 = ascmd1.ExecuteReader()
txt2.DataSource = asreader1
txt2.DataBind()
我调用的第一个代码 <ul id="ulstyle">
<asp:repeater id="txt" runat="server">
<itemtemplate>
<li><span><%# container.dataitem("subtime") %></span><a href='news/shownews.aspx?sid=<%# container.dataitem("id") %>'><%# container.dataitem("newtitle") %></a> </li>
</itemtemplate>
</asp:repeater>
</ul>我调用第二个代码 <ul>
<asp:repeater id="txt2" runat="server">
<itemtemplate>
<li><a target="_blank" href='news/showpic.aspx?proname=<%# container.dataitem("id")%>'><img src='img/<%# container.dataitem("prourl") %>' /><span><%#Container.DataItem("proname")%></span></a></li>
</itemtemplate>
</asp:repeater>
</ul>
是不是上面不能这样调用啊,
[code=vb#]
sub page_load(s as object ,e as eventargs)
Dim conn as oledbconnection
Dim strselect As String
Dim strselect1 As String
Dim ascmd As OleDbCommand
Dim ascmd1 As OleDbCommand
Dim asreader As OleDbDataReader
Dim asreader1 As OleDbDataReader
Dim dbname As String
dbname=server.mappath("someelse/info.mdb")
conn = new oledbconnection("provider=microsoft.jet.oledb.4.0;data source="+dbname)
strselect = "select top 7 * from info order by id desc"
strselect1 = "select top 8 * from pic order by id desc"
ascmd = New OleDbCommand(strselect, conn)
ascmd1 = New OleDbCommand(strselect1, conn)
conn.Open()
'绑定第一个数据源,完成绑定后关闭
asreader = ascmd.ExecuteReader()
txt.DataSource = asreader
txt.DataBind()
asreader.Close()
'绑定第二个数据源,完成绑定后关闭
asreader1 = ascmd1.ExecuteReader()
txt2.DataSource = asreader1
txt2.DataBind()
asreader1.Close()
conn.Close()
end sub [/code]