如何利用Visual studio 2010创建一个ASP网站?
【文件】-->【新建】-->【网站】-->【ASP.Net网站】--【完成】
默认页面Default.aspx
创建以上界面:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="UserLogin.aspx.cs" Inherits="UserLogin" %> <!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 > </ head > < body > < div align = "center" > < h1 >用户登录页面</ h1 > < form id = "form1" runat = "server" > < p > < asp:Label ID = "lbusername" runat = "server" >用户名:</ asp:Label > < asp:TextBox ID = "tbusername" runat = "server" ></ asp:TextBox > </ p > < p > < asp:Label ID = "lbpsw" runat = "server" >密 码:</ asp:Label > < asp:TextBox ID = "tbpsw" runat = "server" TextMode = "Password" ></ asp:TextBox > </ p > < p >< asp:Button ID = "btnLogin" runat = "server" Text = "登录" onclick = "btnLogin_Click" /> < asp:Button ID = "btnCancel" runat = "server" Text = "取消" onclick = "btnCancel_Click" /> </ p > </ form > </ div > </ body > </ html > |
登录验证功能
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
/// <summary> /// 用户登录 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnLogin_Click( object sender, EventArgs e) { if (tbusername.Text == "" ) { Response.Write( @"<script>alert('用户名不能为空!');</script>" ); } if (tbpsw.Text == "" ) { Response.Write( @"<script>alert('密码不能为空!');</script>" ); } string username = tbusername.Text; string password = tbpsw.Text; string sql = "select * from T_user where username=@username and password=@password" ; SqlParameter[] parameters = { new SqlParameter( "@username" ,username), new SqlParameter( "@password" , password) }; using (SqlConnection conn = new SqlConnection(connstr)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = sql; cmd.Parameters.AddRange(parameters); DataSet ds = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(ds); DataTable table = ds.Tables[0]; if (table != null ) Response.Write( @"<script>alert('登录成功!');</script>" ); else Response.Write( @"<script>alert('登录失败!');</script>" ); } } } |
注册功能
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
/// <summary> /// 用户注册 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void brnRegister_Click( object sender, EventArgs e) { string username = tbusername.Text; string password = tbpsw.Text; string sql = "Insert into T_user(username, password) values(@username,@password)" ; SqlParameter[] parameters = { new SqlParameter( "@username" , username), new SqlParameter( "@password" , password) }; using (SqlConnection conn = new SqlConnection(connstr)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = sql; cmd.Parameters.AddRange(parameters); cmd.ExecuteNonQuery(); } } Response.Write( @"<script>alert('注册成功!');</script>" ); } |
知识点归纳:
1.如何创建一个ASP.Net网站
2. 使用服务器控件实现界面设计
3. 对数据库的简单操作
一个简单的用户注册、登录就完成了,通过这个案例希望对大家的学习有所帮助。