帮忙看一下那错了
<!--#include file="Connections/conn.asp" --><form method="post" action="untitled2.asp" name="form1">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Xh:</td>
<td><input type="text" name="xh" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Bj:</td>
<td><input type="text" name="bj" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Xm:</td>
<td><input type="text" name="xm" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Xb:</td>
<td><input type="text" name="xb" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Nwcj:</td>
<td><input type="text" name="nwcj" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Sxcj:</td>
<td><input type="text" name="sxcj" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td><input type="submit" value="Insert Record">
</td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
</form>
<p> </p>
<%
dim xh,bj,xm,xb,nwcj,sxcj
set conn=server.CreateObject("adodb.connection")
conn.open "provider=SQLOLEDB;datasource=cjb;UID=sa;PWD=;database=xsk;"
set Recordset1=server.CreateObject("adodb.recordset")
Recordset1.ActiveConnection = conn
Recordset1.Source = "SELECT * FROM dbo.cjb"
Recordset1.Open()
%>
<%
xh=request("xh")
bj=request("bj")
xm=request("xm")
xb=request("xb")
nwcj=request("nwcj")
sxcj=request("sxcj")
sql="insert into cjb(xh,bj,xm,xb,nwcj,sxcj) values('"&xh&"','"&bj&"','"&xm&"',"&xb&","&nwcj&","&sxcj&")"
sql
Recordset1.execute
Recordset1.ActiveConnection.Close
%>