如何利用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. 对数据库的简单操作
一个简单的用户注册、登录就完成了,通过这个案例希望对大家的学习有所帮助。