为什么会出错?!!
异常详细信息: System.Data.OleDb.OleDbException: 列名 'pword' 无效。列名 'uname' 无效。列名 'logmemberid' 无效
<script runat="server">
sub page_load(byval sender as object,e as eventargs)
dim dbconn as oledbconnection
dim dbcommand as oledbdataadapter
dim ds as new dataset
dbconn=new oledbconnection("provider=sqloledb;" _
&"server=yt2000;" _
&"initial catalog=homepage;" _
&"user id=sa;" _
&"password=yt;")
dbconn.open
dbcommand=new oledbdataadapter("select logmemberid from" _
& "logmembers where " _
& " uname= '" & textbox1.text _
& "' and pword= '" & textbox2.text _
&"'",dbconn)
dbcommand.fill(ds,"logmembers")
if ds.tables("logmembers").rows.count=0 then
label1.text="error"
else
session("logmemberid")=ds.tables("logmembers").rows(0).item("logmemberid")
response.redirect("./index.aspx")
end if
end sub
</script>