复杂的个人信息登录界面

txf2004

浏览: 6870656 次
性别:
来自: 上海

最近访客更多访客>>

east_java

u012363178

wangyy

GDGZWQZ

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

aspx中的代码：

<%@ Page Xlanguage="C#" AutoEventWireup="true" CodeFile="PersonalInformation .aspx.cs" Inherits="PersonalInformation_" Debug="true" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
#Button2
{
height: 21px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table style="margin:0 auto;">
<tr><td></td><td align="center"> 个人信息维护</td></tr>

<tr><td align="right">昵称：</td><td><asp:TextBox ID="Nickname" runat="server"></asp:TextBox>(发表评论时显示)</td></tr>

<tr><td align="right">性别：</td><td>
<asp:RadioButton ID="Sex1" runat="server" Text="男" />
<asp:RadioButton ID="Sex2" runat="server" Text="女" /></td></tr>

<tr><td>所在部门：</td><td><asp:DropDownList ID="department" runat="server">
<asp:ListItem>组宣部</asp:ListItem>
<asp:ListItem>学习部</asp:ListItem>
<asp:ListItem>秘书部</asp:ListItem>
<asp:ListItem>文艺部</asp:ListItem>
</asp:DropDownList></td></tr>

<tr><td align="right"> 爱好：</td><td>
<asp:CheckBoxList ID="CheckBoxList1" runat="server"
RepeatDirection="Horizontal" Width="257px">
<asp:ListItem>旅游</asp:ListItem>
<asp:ListItem>读书</asp:ListItem>
<asp:ListItem>上网</asp:ListItem>
<asp:ListItem>活动</asp:ListItem>

</asp:CheckBoxList>
</td></tr>

<tr><td align="right"> E-mail:</td><td><asp:TextBox ID="Email" runat="server"></asp:TextBox></td></tr>

<tr><td align="right">生日：</td><td><asp:TextBox ID="Birthday" runat="server"></asp:TextBox>(yyyy-mm-dd)</td></tr>

<tr><td>个人头像：</td><td>
<input type="file" runat="server" id="file1"/> </td></tr>

<tr><td>个人简介：</td><td>
<asp:TextBox ID="BriefIntroduction" runat="server" BorderStyle="Double" Height="72px"
Width="277px"></asp:TextBox></td></tr>

<tr><td></td><td><asp:Button ID="Button1" runat="server" Text="确定" Xonclick="Button1_Click" /></td></tr>
</table>

</div>
<div id="divResult" runat="server">

</div>

</form>
</body>
</html>

aspx.cs中的代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Text;
using System.Data.SqlClient;

public partial class PersonalInformation_ : System.Web.UI.Page
{
string sqlserverstr = ConfigurationManager.ConnectionStrings["sqlservercon"].ConnectionString;

protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{

SqlConnection conn = new SqlConnection(sqlserverstr);
conn.Open();
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.Connection = conn;
sqlcmd.CommandText = " insert into Person(Nickname,Sex,Hobby,Email,Birthday,HeadPortrait,BriefIntroduction) values(@Nickname,@Sex,@Hobby,@Email,@Birthday,@HeadPortrait,@BriefIntroduction)";

sqlcmd.Parameters.AddWithValue("@Nickname", Nickname.Text);
if (Sex1.Checked)
{
sqlcmd.Parameters.AddWithValue("@Sex", Sex1.Text);
}
else
{
sqlcmd.Parameters.AddWithValue("@Sex", Sex2.Text);
}

string str = "";
foreach (ListItem li in CheckBoxList1.Items)
{
if (li.Selected)
{
str += li.Text+"、";
}
}

sqlcmd.Parameters.AddWithValue("@Hobby", str);

sqlcmd.Parameters.AddWithValue("@Email", Email.Text);
sqlcmd.Parameters.AddWithValue("@Birthday", Birthday.Text);

StringBuilder sb = new StringBuilder();
string filename = this.file1.PostedFile.FileName;
filename = DateTime.Now.Ticks.ToString() + filename.Substring(filename.LastIndexOf("."));
this.file1.PostedFile.SaveAs(Server.MapPath("upload") + "\\" + filename);
sb.Append("<img src=\"upload/" + filename + "\" />");

sqlcmd.Parameters.AddWithValue("@HeadPortrait", sb.ToString());
sqlcmd.Parameters.AddWithValue("@BriefIntroduction", BriefIntroduction.Text);

sqlcmd.ExecuteNonQuery();

SqlConnection conn1 = new SqlConnection(sqlserverstr);
conn1.Open();
SqlCommand sqlcmd1 = new SqlCommand();
sqlcmd1.Connection = conn1;
sqlcmd1.CommandText = " insert into Department(department) values(@department)";
sqlcmd1.Parameters.AddWithValue("@department", department.Text);
sqlcmd1.ExecuteNonQuery();

conn.Close();
conn.Dispose();

}
}

分享到：