asp.net(vb)为什么我单击提交留言时没有把留言信息执插入数据表中???
事件代码:sub postarticle(sender as object,e as eventargs)
dim conn as new oledbconnection()
conn.connectionstring="provider=microsoft.jet.oledb.4.0; data source=" & server.mappath("guestbook.mdb")
conn.open()
dim artid as integer
dim cmd as new oledbcommand("select max(id) as aid from book",conn)
dim reader as oledbdatareader=cmd.executereader()
reader.read()
if isdbnull(reader.item("aid")) then
artid=1
else
artid=reader.item("aid")+1
end if
reader.close()
dim strsql as string
strsql="insert into book values('" & artid & "','" & username.value & "','" & email.text & "','" & system.datetime.now() & "','" & content.text & "')"
dim cn as new oledbcommand(strsql,conn)
cmd.executenonquery()
conn.close()
response.redirect("guestbook.aspx")
end sub
//提交时没有出现错误,但是留言信息总是没有插入数据表中~~~高手指点哈~~~~这是为什么啊???