Question

急！！asp写入与数据库问题

三个字段 id , topic ,time ； id和time系统自动生成
现在用一个文本框和一个按钮，将文本框内的文本写入数据库tb_topic表中的topic字段，Button里代码怎么写？

SqlConnection con = new SqlConnection("server=.;database=db_lt;integrated security=true");
con.Open();
SqlCommand cmd = new SqlCommand("insert into tb_topic values ？？？？？？？？？？？");

Answer 1

'以下是用ASP做的

<%
If request("editKind") ="I" Then
Dim insValue,Conn
insValue = request.from("txtValue");
'SqlConnection con = new SqlConnection("server=.;database=db_lt;integrated security=true");
'con.Open();
'SqlCommand cmd = new SqlCommand("insert into tb_topic values ？？？？？？？？？？？");
Dim strConnect = "SqlConnection写到这里"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open strConnect
Dim sql = " insert into tb_topic (topic) values ('" & insValue & "')";
set rs = Conn.execute(sql)
End If
%>

<script language="javascript">
<!--
function insertData(){
var objFrm = document.getElementById("frm");
objFrm.action = "本文件.asp?editKind=I";
objFrm.submit();
}
//-->
</script>
<form id="frm" method="post">
<input type="text" id="txtValue">
<input type="button" value="insert" onclick="insertData()">
</form>