**************************************登陆
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
namespace _1015Asp.lianxi
{
public partial class Login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
}
protected void btnlogin_Click(object sender, EventArgs e)
{
string username = TextBox3.Text;
string password = TextBox4.Text;
//string connstr = "Data Source=PC-20120604KNHD;Initial Catalog=T_User;Persist Security Info=True;User ID=sa;Password=910809";
//string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
//using (SqlConnection conn = new SqlConnection(connStr))
//{
// conn .Open ();
// using (SqlCommand cmd = conn.CreateCommand())
// {
#region//方法一
// cmd.CommandText = "select*from T_Users where Fname=@name";
// cmd.Parameters.Add(new SqlParameter ("@name",username ));
// SqlDataReader reader = cmd.ExecuteReader();
// if (reader.Read() == true)
// {
// //用户名存在
// string pwd = reader.GetString(reader.GetOrdinal("Fpassword"));
// if (pwd == password)
// {
// //用户名密码正确
// this.lblErrorMessage.Visible = false ;
// Response.Redirect("welcom.aspx");
// }
// else
// {
// this.lblErrorMessage.Visible = true;
// this.lblErrorMessage.Text = "密码错误";
// //密码错误
// }
// }
// else
// {
// //用户名不存在
// this.lblErrorMessage.Visible = true;
// this.lblErrorMessage .Text ="用户名不存在";
// }
#endregion
// }
//}
//
//*************************************方法二
object result = SqlHelper.ExecuteScalar("select*from T_Users where Fname=@name and Fpassword=@pwd", new SqlParameter("@name", username), new SqlParameter("@pwd", password));
if (Convert.ToInt64(result) > 0)
{
Response.Redirect("welcom.aspx");
}
else
{
Response.Write("用户名或者密码错误,登陆失败!");
}
//**************************************方法三
DataTable table = SqlHelper.ExecuteDataTable("select*from T_Users whereFname=@name", new SqlParameter("@name", username));
if (table.Rows.Count > 0)
{
DataRow row = table.Rows[0];
//用户名存在
string passW = row["Fpassword"].ToString();//取出对应的密码
if (passW == password)
{
//用户名密码正确
// //Session["是否登陆"]=true
this.lblErrorMessage.Visible = false;
Response.Redirect("welcome.aspx");
}
else
{
//密码错误
this.lblErrorMessage.Visible = true;
this.lblErrorMessage.Text = "密码错误";
}
}
}
protected void btnregister_Click(object sender, EventArgs e)
{
Response.Redirect("register.aspx");
}
}
}
注册*******************************************************
using System;
using System.Data.SqlClient;
namespace _1015Asp.lianxi
{
public partial class register : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
;
}
protected void btnregister2_Click(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string username = TextBox1.Text;
string password = TextBox2.Text;
#region//********************************方法一
//string connstr = "Data Source=PC-20120604KNHD;Initial Catalog=T_User;Persist Security Info=True;User ID=sa;Password=910809";
//SqlConnection conn = new SqlConnection(connstr);
//conn.Open();
//SqlCommand cmd = conn.CreateCommand();
//cmd.CommandText = "insert into T_Users (Fname,Fpassword) values (@name,@pwd)";
//cmd.Parameters.Add(new SqlParameter("@name", username));
//cmd.Parameters.Add(new SqlParameter("@pwd", password));
//cmd.ExecuteNonQuery();
//Response.Redirect("message.aspx?message=注册成功,即将转向登陆页面!&RedirectURL=Login.aspx");
#endregion
#region//*************************方法二
//**************************************方法二
int result = SqlHelper.ExecuteNoQuery("insert into T_Users (Fname,Fpassword) values (@name,@pwd)", new SqlParameter("@name", "username"), new SqlParameter("@pwd", password));
if (result >= 1)
{
Response.Redirect("message.aspx?message=注册成功,即将转向登陆页面!&RedirectURL=Login.aspx");
}
#endregion
}
}
}
***************************************************************message.aspx页面
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="message.aspx.cs" Inherits="_1015Asp.lianxi.message" %>
<!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>
<script type="text/javascript" >
setTimeout(function ()
{
location.href = '<%=Request["RedirectURL"] %>';
}, 3000);
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
<a href='<%=Request["RedirectURL"] %>'>立即转向</a>
</div>
</form>
</body>
</html>
************************************************message.aspx.cs页面
public partial class message : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Label1 .Text=Request ["message"];
}
}
<body>
***************************welcom.aspx
<form id="form1" runat="server">
<div>
嗳呦~~欢迎来到csdn学习大本营!<br />
<asp:Button ID="Button1" runat="server" Text="测试DateSet"
οnclick="Button1_Click" />
<asp:TextBox ID="TextBox1" runat="server" Height="152px" TextMode="MultiLine"
Width="374px"></asp:TextBox>
</div>
</form>
</body>
*************************welcom.aspx.cs
protected void Button1_Click(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd=conn .CreateCommand ())
{
cmd.CommandText = "select * from T_Users";
DataSet dataset = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dataset );
DataTable table=dataset .Tables [0];
for (int i = 0; i < table.Rows.Count;i++ )
{
DataRow row=table .Rows [i];
string name = Convert.ToString(row["Fname"]);
this.TextBox1.Text += name+";";
}
}
}
}
SqlHelp
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
namespace _1015Asp.lianxi
{
public class SqlHelper
{
//注册
public static String connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
public static int ExecuteNoQuery(string sql,params SqlParameter [] parameters)
{
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
foreach (SqlParameter parameter in parameters )
{
cmd.Parameters.Add(parameter);
}
return cmd.ExecuteNonQuery();
}
}
}
//登陆
public static object ExecuteScalar(string sql, params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
foreach (SqlParameter parameter in parameters)
{
cmd.Parameters.Add(parameter);
}
return cmd.ExecuteScalar();
}
}
}
//读
public static SqlDataReader ExecuteReader(string sql, params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
foreach (SqlParameter parameter in parameters)
{
cmd.Parameters.Add(parameter);
}
return cmd.ExecuteReader();
}
}
}
public static DataTable ExecuteDataTable(string sql, params SqlParameter[] parameters)
{
using(SqlConnection conn=new SqlConnection(connStr))
{
conn.Open();
using(SqlCommand cmd=conn.CreateCommand())
{
cmd.CommandText = sql;
foreach (SqlParameter parameter in parameters)
{
cmd.Parameters.Add(parameter);
}
DataSet dataset = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dataset);
return dataset.Tables[0];
}
}
}
}
}