62,046
社区成员
发帖
与我相关
我的任务
分享BC30002: 未定义类型“oledbdatareader”
asp.net调试时BC30002: 未定义类型“oledbdatareader”,不知怎么改?
<script language=vb runat=server>
Sub button1_c(ByVal sender As Object, ByVal e As EventArgs)
step1.Visible = False
Dim rd As oledbdatareader
Dim conn As oledbconnection = Nothing
Dim connstr, sql As String
connstr = "provider=SQLOLEDB;data source=" & Server.MapPath("db1.mdb")
conn = New oledbconnection(connstr)
conn.open()
sql = "insert into xinxi(date,topic,context,)values(#" & Request.QueryString("date1")&"#,'"&textbox2.text&"','"&textbox1.text&"')"
Dim cmd As oledbcommand = New oledbcommand(sql, conn)
cmd.executereader()
End Sub
</script>
<script language=vb runat=server>
Sub button1_c(ByVal sender As Object, ByVal e As EventArgs)
step1.Visible = False
Dim rd As oledbdatareader
Dim conn As oledbconnection = Nothing
Dim connstr, sql As String
connstr = "provider=SQLOLEDB;data source=" & Server.MapPath("db1.mdb")
conn = New oledbconnection(connstr)
conn.open()
sql = "insert into xinxi(date,topic,context,)values(#" & Request.QueryString("date1")&"#,'"&textbox2.text&"','"&textbox1.text&"')"
Dim cmd As oledbcommand = New oledbcommand(sql, conn)
cmd.executereader()
End Sub
</script>
...全文
请发表友善的回复…
发表回复
我姓区不姓区 2009-02-02
- 打赏
- 举报
注意大小写:
OleDbDataReader
OleDbDataReader
简购 2009-02-02
- 打赏
- 举报
改了以后也不行,数据库是SQLSERVER 2005是不是连接有问题
ReyZhang 2009-02-01
- 打赏
- 举报
cmd.executereader() 返回的是一个只读结果集
cmd.ExecuteNonQuery() 返回受影响的行数 ,是在执行 insert,update,delete 等语句的时候使用
cmd.ExecuteNonQuery() 返回受影响的行数 ,是在执行 insert,update,delete 等语句的时候使用
ppp7p 2009-02-01
- 打赏
- 举报
你在插入数据是不能使用 Executereader(),在这里需要使用 cmd.ExecuteNonQuery()这个方法。
winner2050 2009-02-01
- 打赏
- 举报
cmd.executereader()
=====================
cmd.ExecuteNonQuery();
=====================
cmd.ExecuteNonQuery();
