数据添加
有如下数据库:如何把填写的信息写如到数据库的表中
1:%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<%
dim conn,dbuid,dbpwd,dbname,dbip,rs,database
dim startime,endtime
startime=timer()
database=1
'修改以下信息以适合你的网站
'---------------------------------------------------------------------------
dbuid="sa" '数据库登陆名
dbpwd="197765" '数据库密码
dbname="process" '数据库名称
dbip="(local)" '数据库所在的IP地址,如果是本地数据库则为:"(local)"
'---------------------------------------------------------------------------
set conn=Server.CreateObject("adodb.Connection")
Conn.Open "PROVIDER=SQLOLEDB.1;Data Source="&dbip&";Initial Catalog="&dbname&";Persist Security Info=True;User ID="&dbuid&";Password="&dbpwd&";Connect Timeout=30"
set rs=server.createobject("adodb.recordset")
%>
</body>
</html><%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body {
background-image: url(image/background4.gif);
}
-->
</style>
<link href="css/f1.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style3 {font-size: 12px}
.style4 {color: #cc0000}
-->
</style>
</head>
<body>
<table width="774">
<tr>
<td height="56"> </td>
</tr>
</table>
<table width="772" height="33" border="0" background="image/bg1.gif">
<tr>
<td width="772"> <span class="style3">用户信息填写</span></td>
</tr>
</table>
<form name="form1" method="post" action="">
<table class=unnamed1 cellSpacing=0 borderColorDark=#ffffff cellPadding=0
width=770 align=center borderColorLight=#cccccc border=1>
<tr>
<td height="20" colspan="4"><p><img src="image/bg1-02.gif" width="9" height="9"> <span class="style4">请注意填写的格式 每一项务必填写完整</span></p>
</td>
</tr>
<tr>
<td width="156"><img src="image/bg1-02.gif" width="9" height="9"> 用户名:</td>
<td width="220"><input name="textfield" type="text" size="15"></td>
<td width="175"><img src="image/bg1-02.gif" width="9" height="9"> 密码:</td>
<td width="209"><input name="textfield" type="text" size="15"></td>
</tr>
<tr>
<td><img src="image/bg1-02.gif" width="9" height="9"> 确认密码:</td>
<td><input name="textfield" type="text" size="15"></td>
<td><img src="image/bg1-02.gif" width="9" height="9"> 真实姓名:</td>
<td><input name="textfield" type="text" size="15"></td>
</tr>
<tr>
<td><img src="image/bg1-02.gif" width="9" height="9"> 部门:</td>
<td><input name="textfield" type="text" size="15"></td>
<td><img src="image/bg1-02.gif" width="9" height="9"> 职称:</td>
<td><input name="textfield" type="text" size="15"></td>
</tr>
<tr>
<td height="20"><img src="image/bg1-02.gif" width="9" height="9"> 注册时间:</td>
<td><input name="textfield" type="text" size="15"></td>
<td><img src="image/bg1-02.gif" width="9" height="9"> E-mail:</td>
<td><input name="textfield" type="text" size="15"></td>
</tr>
<tr>
<td height="14" colspan="4">
<p>
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit" value="重填">
</p>
<p> </p>
<p> </p></td>
</tr>
</table>
</form>
</body>
</html>
3:请给出写入数据库表中的程序,写完整点
谢谢哥哥