编程论坛 → ASP.NET技术论坛

[求助]请问以下代码怎么不能获取表单值?浏览时它老是提示:至少一个参数没有被指定值

gaoqiang1987 发布于 2007-09-23 13:13， 955 次点击

<%@ Import Namespace="system.data" %> <%@ Import Namespace="system.data.oledb" %>

程序代码：

<script language=\"vb\" runat=\"server\">

    Dim myconnection As OleDbConnection
    Dim mycommand As OleDbCommand
    Sub submit_onclick(ByVal sender As Object, ByVal e As EventArgs)
        myconnection = New OleDbConnection(\"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=\" & \"h:\asp.net\information.mdb\")
        mycommand = New OleDbCommand(\"insert into information (name,home,relationship,message) values(name,home,relationship,message)\", myconnection)
        myconnection.Open()
        mycommand.ExecuteNonQuery()
        myconnection.Close()
    End Sub

</script>

无标题页

4 回复

#2

jxnuwy042007-09-23 13:27

insert into information (name,home,relationship,message) values(name,home,relationship,message)这条语句是用来插入的吗，好象有问题吧．后面的值怎么能这样写呢，当然会提示参数没有指定值了
将插入语句改成:string strInsert="insert into information (name,home,relationship,message) values('"+textname.text+"','"+texthome.text+"','"+textrelationship.text+"','"+textmessage.text+"';试试看．

#3

gaoqiang19872007-09-23 14:09

它提示textmessage,textname,texthome,textrelationship未声明名称.再想问一下为什么前面要加一个TEXT呢?我是用VB语言,不是C#

#4

jxnuwy042007-09-23 14:51

哦，不好意思，这是我的习惯．其实textmessage就表示Message输入框的ID,textmessage.Text就是取它的Text值．

#5

gaoqiang19872007-09-23 16:44

回复：（jxnuwy04）哦，不好意思，这是我的习惯．其实...

太感谢了,在你的指点下,现在搞定了!

1