急 请高手指教表单提交数据库问题!!
workstate111.asp
<%
set conn=opendb()
set rs=server.createobject("adodb.recordset")
sql="select * from work_wz "
rs.open sql,conn,1,1
%>
<tr>
<td><%=rs("tc_dept")%></td>
<td><%=rs("part_order")%></td>
<td><%=rs("part_th")%></td>
<td><%=rs("part_name")%></td>
<td><%=rs("plan_amount")%></td>
<td><%=rs("part_date")%></td>
<td><%=rs("qianshu")%></td>
<td><%=rs("need_date")%></td>
<td><%=rs("chn_date")%></td>
<td><%=rs("sj_date")%></td>
<td><%=rs("tq_day")%></td>
workstate_in111.asp
<%
set conn=opendb()
if request("save")="提交" then
conn.execute "insert into work_wz(tc_dept,part_order,part_th,part_name,plan_amount,part_date,qianshu,need_date,chn_date,sj_date,tq_day) values('"& request("tc_dept")&"','"& request("part_order")&"','"& request("part_th")&"','"& request("part_name")&"','"& request("plan_amount")&"','"& request("part_date")&"','"& request("qianshu")&"','"& request("need_date")&"','"& request("chn_date")&"','"& request("sj_date")&"','"& request("tq_day")& "')"
response.redirect "workstate111.asp"
%>
<% end if %>
<center>
<form method="POST" action="workstate_in111.asp" name="form2" >
<table border="0" width="95%" id="table1" >
<tr>
<td width="16%"><b>提出部门</b></td>
<td width="83%">
<input type="text" name="tc_dept" size="20" class="style1" >
</td>
</tr>
<tr>
<td width="16%" ><b>令 号</b></td>
<td width="83%"><input type="text" name="part_order" size="20" class="style1">
</td>
</tr>
<tr>
<td width="16%"><b>零件图号</b></td>
<td width="83%"><input type="text" name="part_th" size="20" class="style1">
</td>
</tr>
<tr>
<td width="16%"><b>零件名称</b></td>
<td width="83%"><input type="text" name="part_name" size="20" class="style1">
</td>
</tr>
<tr>
<td width="16%"><b>计划数量</b></td>
<td width="83%"><input type="text" name="plan_amount" size="20" class="style1">
</td>
</tr>
<tr>
<td width="16%"><b>产品配套期</b></td>
<td width="83%"><input type="text" name="part_date" size="20" class="style1">
</td>
</tr>
<tr>
<td width="16%"><b>所欠数量</b></td>
<td width="83%"><input type="text" name="qianshu" size="20" class="style1">
</td>
</tr>
<tr>
<td width="16%"><b>要求到料时间</b></td>
<td width="83%"><input type="text" name="need_date" size="20" class="style1">
</td>
</tr>
<tr>
<td width="16%"><b>承诺到料时间</b></td>
<td width="83%"><input type="text" name="chn_date" size="20" class="style1">
</td>
</tr>
<tr>
<td width="16%"><b>实际到料时间</b></td>
<td width="83%"><input type="text" name="sj_date" size="20" class="style1">
</td>
</tr>
<tr>
<td width="16%"><b>拖期天数</b></td>
<td width="83%"><input type="text" name="tq_day" size="20" class="style1">
</td>
</tr>
<tr>
<td colspan=2>
<input type="submit" value="提交" name="save"> <input type="reset" value="取消" name="B2">
</td>
</tr>
</table>
</form>
</center>
高手帮我看看,哪里出错了,怎么插入不了数据库?还有,要怎么写才能在数据库中每条记录自动生成一个ID号?