.net语句在dreameavermx2004 中怎么写？

[lsypenghong]

我想在网页中添加记录，后台是sql 2000,已经连接数据库成功，我怎么在网页中用vb.net写语句添加记录？？

[wuzhouhome]

OleDbConnection con=new OleDbConnection("连接")
OleDbCommand Icom=OleDbCommand("insert into table(column,column) values('values','values')",con);
Icom.ExecuteNonQuery();

[wuzhouhome]

OleDbConnection con=new OleDbConnection("连接")
con.open();
OleDbCommand Icom=OleDbCommand("insert into table(column,column) values('values','values')",con);
Icom.ExecuteNonQuery();
少了个open();

[lsypenghong]

这段代码怎么加到网页中？

[lsypenghong]

<tr>
<td height="23" align="center" valign="middle"><textarea name="tt1" cols="100" rows="6" id="tt1" dir="ltr" lang="zh"><%# DataSet1.FieldValue("Text", Container) %></textarea> <input name="Submit" type="submit" onClick="Dim spl As String = "insert into Guestinfo(ID,IP,Text) Values('" & t1.Text & "','" & textfield2.text & " """"""""','" & tt1.text & " """"""""' )"
Dim Mycommand As New SqlCommand(spl, myvar)
Mycommand.ExecuteNonQuery()" value="回复主题"></td>
</tr>
这样不行！！！
我想点击一个按钮，添加记录，在dreame中添加代码~~
不是在。net 平台添加~~

[lsypenghong]

那位大哥，把.net与dreameaver结合作成的网页后台代码让俺看看，俺看看怎么在网页上添加记录！！！！

[Chocoboboy]

这跟你用什么有什么关系？用DW只不过没有CODEBEHIND吧？
<script language="vb" runat="server>
Sub button1_click(sender as object,e as eventargs)
OleDbConnection con=new OleDbConnection("连接")
con.open();
OleDbCommand Icom=OleDbCommand("insert into table(column,column)values ('values','values')",con);
Icom.ExecuteNonQuery();
end Sub
</script>
....
<form ...>
...
<asp:Button id="button1" runat="server" text="xxx"></asp:button>
...
</form>
...