--建表
[ucode] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[realname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sex] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[pwd] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[job] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[department] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[tel] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[integration] [float] NOT NULL ,
[address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[postcode] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[papersName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[papersId] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[pwdQuestion] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[pwdAnswer] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ubirthday] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
--存储过程
--通过调用存储过程,用网页的形式插入数据
<%@ Page Language="C#" Debug="true" %>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<head>
<script language="C#" runat="server">
private void Page_load(object src, EventArgs e)
{
if (!IsPostBack)
BindGrid();
}
private void add_click(object serder, EventArgs E)
{
string insertCmd = "insert into customer_info(ucode,realname,sex,pwd,job,department,tel,email,integration,address,postcode,papersName,papersId,pwdQuestion,pwdAnswer,ubirthday,city)values(@ucode_in ,@realname_in ,@sex_in ,@pwd_in ,@job_in ,@department_in ,@tel_in ,@Email_in ,@intergration_in ,@address_in ,@postcode_in ,@papersName_in ,@papersId_in ,@pwdAnswer_in ,@pwdQuestion_in,@ubirthday,@city_in )";
SqlConnection mycon = new SqlConnection("Data Source=localhost;uid=sa;pwd=123456;Initial Catalog=crazy");
SqlCommand mycom = new SqlCommand(insertCmd, mycon);
mycom.Parameters.Add(new SqlParameter("@ucode_in", SqlDbType.Char,8));
mycom.Parameters["@ucode_in"].Value = ucode.Value;
mycom.Parameters.Add(new SqlParameter("@realname_in", SqlDbType.VarChar, 20));
mycom.Parameters["@realname_in"].Value = realname.Value;
mycom.Parameters.Add(new SqlParameter("@sex_in", SqlDbType.Char, 2));
mycom.Parameters["@sex_in"].Value = sex.Value;
mycom.Parameters.Add(new SqlParameter("@pwd_in", SqlDbType.VarChar,6));
mycom.Parameters["@pwd_in"].Value = pwd.Value;
mycom.Parameters.Add(new SqlParameter("@job_in", SqlDbType.VarChar, 20));
mycom.Parameters["@job_in"].Value = job.Value;
mycom.Parameters.Add(new SqlParameter("@department_in", SqlDbType.VarChar, 20));
mycom.Parameters["@department_in"].Value = department.Value;
mycom.Parameters.Add(new SqlParameter("@tel_in", SqlDbType.VarChar, 20));
mycom.Parameters["@tel_in"].Value = tel.Value;
mycom.Parameters.Add(new SqlParameter("@Email_in", SqlDbType.VarChar, 50));
mycom.Parameters["@Email_in"].Value = email.Value;
mycom.Parameters.Add(new SqlParameter("@intergration_in", SqlDbType.Int ));
mycom.Parameters["@intergration_in"].Value = intergration.Value;
mycom.Parameters.Add(new SqlParameter("@address_in", SqlDbType.VarChar, 50));
mycom.Parameters["@address_in"].Value = address.Value;
mycom.Parameters.Add(new SqlParameter("@postcode_in", SqlDbType.VarChar, 6));
mycom.Parameters["@postcode_in"].Value = postcode.Value;
mycom.Parameters.Add(new SqlParameter("@papersName_in", SqlDbType.VarChar, 20));
mycom.Parameters["@papersName_in"].Value = papersname.Value;
mycom.Parameters.Add(new SqlParameter("@papersId_in", SqlDbType.VarChar, 20));
mycom.Parameters["@papersId_in"].Value = papersid.Value;
mycom.Parameters.Add(new SqlParameter("@pwdQuestion_in", SqlDbType.VarChar, 100));
mycom.Parameters["@pwdQuestion_in"].Value = pwdquestion.Value;
mycom.Parameters.Add(new SqlParameter("@pwdAnswer_in", SqlDbType.VarChar, 100));
mycom.Parameters["@pwdAnswer_in"].Value = pwdanswer.Value;
mycom.Parameters.Add(new SqlParameter("@ubirthday", SqlDbType.Char,8));
mycom.Parameters["@ubirthday"].Value = ubirthday.Value;
mycom.Parameters.Add(new SqlParameter("@city_in",SqlDbType.VarChar,12));
mycom.Parameters["@city_in"].Value=city.Value;
mycon.Open();
try{
mycom.ExecuteNonQuery();
Message.Style["color"] = "red";
Message.InnerHtml = "<b>注册:</b>注册成功";
}
catch (System.Data.SqlClient.SqlException e) {
Message.Style["color"] = "red";
switch (e.Number)
{
case 2627:
Message.InnerHtml = "ERROR:这个帐号已被注册过,请重新输入";
break;
default:
Message.InnerHtml = "错误:" + "[" + e.Number.ToString() + "]" + e.ToString();
break;
}
}
mycon.Close();
BindGrid();
}
private void BindGrid(){
try{
SqlConnection mycon = new SqlConnection("Data Source=localhost;uid=sa;pwd=123456;Initial Catalog=crazy");
SqlDataAdapter mycom = new SqlDataAdapter("select ucode,realname from customer_info", mycon);
DataSet ds=new DataSet();
mycom.Fill(ds,"a");
myDataGrid.DataSource=ds.Tables["a"].DefaultView;
myDataGrid.DataBind();
}
catch(System.Exception e){
Message.Style["color"]="red";
Message.InnerHtml="ERROR:"+e.ToString();
}
}
</script>
</head>
<body style="font:10pt verdana">
<iframe height="98" width="1220"></iframe>
<form runat="server" >
<table width="100%" cellpadding="0" cellspacing="0">
<tr><td align="center" class="contenttitle" width="100%"><marquee><font color="gray" >您好!欢迎你注册本网站</font></marquee></td></tr>
<tr><td><span id="Message" enableviewstate="false" class="Message" runat="server" ></span></td></tr>
<tr><td colspan=10 style="font:10pt verdana"> <a href=""><strong>首页</strong></a>--><a href="注册用户.aspx"><strong>注册</strong></a></td></tr>
</table><br />
<table style="font:10pt verdana" border="0" align="center">
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">帐号:</span></td>
<td><input type="text" id="ucode" value="" runat="server" /></td><td>(提示:请输入8位字母或数字)</td>
<td><asp:RequiredFieldValidator id="ucode1" runat="server" ControlToValidate=ucode ErrorMessage="*请输入8位帐号*"></asp:RequiredFieldValidator></td></tr>
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">姓名:</span></td>
<td><input type="text" id="realname" value="" runat="server" /></td>
<td><asp:RequiredFieldValidator ID="realname1" runat="server" ControlToValidate="realname" ErrorMessage="*请输入你的真实名*"></asp:RequiredFieldValidator></td></tr>
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">密码:</span></td>
<td><input type="password" id="pwd" value="" runat="server" /></td>
<td><asp:RequiredFieldValidator ID="pwd1" runat="server" ControlToValidate=pwd ErrorMessage="*请输入密码*"></asp:RequiredFieldValidator></td></tr>
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">确定密码:</span></td>
<td><input type="password" id="repwd" value="" runat="server" /></td>
<td><asp:CompareValidator ID="repwd1" runat="server" ControlToValidate="pwd" ControlToCompare="repwd" Type="string" Operator="equal" ErrorMessage="*输入密码与论证密码不相符*" ></asp:CompareValidator></td></tr>
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">性别:</span></td>
<td><select id="sex" runat="server" οnchange="setChargNote1">
<option>男</option>
<option>女</option>
</select></td>
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">出生日期:</span></td>
<td><input type="text" id="ubirthday" value="" runat="server" /></td><td>(提示:输入格式19851215)</td>
<td><ASP:RegularExpressionValidator Id="ubirthday1" Runat="Server" ControlToValidate="ubirthday" ValidationExpression="[0-9]{6,8}" Text="*请输入正确的年月日*"/></td></tr>
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">行业:</span></td>
<td><input type="text" id="job" value="" runat="server" /></td>
<td><asp:RequiredFieldValidator ID="job1" runat="server" ControlToValidate="job" ErrorMessage="*请输入你所从事的行业*"></asp:RequiredFieldValidator></td></tr>
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">所在部门:</span></td>
<td><input type="text" id="department" value="" runat="server" /></td></tr>
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">电话:</span></td>
<td><input type="text" id="tel" value="" runat="server" /></td>
<td><ASP:RegularExpressionValidator Id="tel1" Runat="Server" ControlToValidate="tel" ValidationExpression="[0-9]{7,13}" Text="*请输入你的电话号码*"/></td></tr>
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">电子邮箱:</span></td>
<td><input type="text" id="email" value="" runat="server" /></td>
<td><ASP:RegularExpressionValidator Id="email1" Runat="Server" ControlToValidate="email" ValidationExpression=".+@.+" Text="*请输入完整的邮箱名称*"/></td>
<td valign="top" align="right"><span class="REQUIREDFIELD"></span></td>
<td><input type=hidden id="intergration" value="0" runat="server" /></td></tr>
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">地址:</span></td>
<td><input type="text" id="address" value="" runat="server" /></td></tr>
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">地区:</span></td>
<td><select id="city" runat="server" οnchange="setChargeNote2">
<option></option>
<option>北京</option>
<option>广东</option>
<option>上海</option>
<option>浙江</option>
<option>江苏</option>
<option>山东</option>
<option>山西</option>
<option>福建</option>
<option>辽宁</option>
<option>河南</option>
<option>四川</option>
<option>湖北</option>
<option>天津</option>
<option>湖南</option>
<option>河北</option>
<option>重庆</option>
<option>云南</option>
<option>新疆</option>
<option>西藏</option>
<option>青海</option>
<option>宁夏</option>
<option>江西</option>
<option>吉林</option>
<option>海南</option>
<option>贵州</option>
<option>广西</option>
<option>甘肃</option>
<option>安徽</option>
<option>陕西</option>
<option>黑龙江</option>
<option>内蒙古</option>
<option>其它</option>
</select></td>
<td valign="top" align="right"><span class="REQUIREDFIELD">邮编:</span></td>
<td><input type="text" id="postcode" value="" runat="server" /></td>
<td><ASP:RegularExpressionValidator Id="postcode1" Runat="Server" ControlToValidate="postcode" ValidationExpression="[0-9]{6,6}" Text="*请输入你的邮编*"/></td></tr>
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">证件名:</span></td>
<td><input type="text" id="papersname" value="" runat="server" /></td>
<td><asp:RequiredFieldValidator ID="papersname1" runat="server" ControlToValidate="papersname" ErrorMessage="*请输入你的证件名*"></asp:RequiredFieldValidator></td></tr>
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">证件号码:</span></td>
<td><input type="text" id="papersid" value="" runat="server" /></td>
<td><asp:RequiredFieldValidator ID="papersid1" runat="server" ControlToValidate="papersid" ErrorMessage="*请输入你的证件号码*"></asp:RequiredFieldValidator></td></tr>
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">密码提示问题:</span></td>
<td><input type="text" id="pwdquestion" value="" runat="server"></td>
<td><asp:RequiredFieldValidator ID="pwdquestion1" runat="server" ControlToValidate="pwdquestion" ErrorMessage="*请输入你的密码提示问题*"></asp:RequiredFieldValidator></td></tr>
`
<tr><td valign="top" align="right"><span class="REQUIREDFIELD">密码提示答案:</span></td>
<td><input type="text" id="pwdanswer" value="" runat="server" /></td>
<td><asp:RequiredFieldValidator ID="pwdanswer1" runat="server" ControlToValidate="pwdanswer" ErrorMessage="*请输入密码提示答案*"></asp:RequiredFieldValidator></td></tr>
<td valign="top" align="right" ><font FACE="Verdana,Helvetica,Arial" SIZE="1"><br />
<td><input id="Submit1" TYPE="submit" onserverclick="add_click" value="注册" runat="server"/>
<input type="reset" value="重置"/></FONT>
</td></tr>
<tr></tr>
</table>
<table style="font:10pt verdana" align="center">
<td><asp:DataGrid ID="myDataGrid" runat="server" ShowFooter="false" CellPadding="3" CellSpacing="0" Font-Names="Verdana" Font-Size="8pt" AutoGenerateColumns="false">
<Columns>
<asp:BoundColumn HeaderText="你的帐号是:" DataField="ucode" HeaderStyle-Height="2" HeaderStyle-BorderWidth="0"></asp:BoundColumn>
<asp:BoundColumn HeaderText="你的注册名是:" DataField="realname"></asp:BoundColumn>
</Columns>
</asp:DataGrid></td></table>
</form>
</body>
</html>