登陆部分
protected
void
Login1_Authenticate(
object
sender, AuthenticateEventArgs e)
... {
//创建数据库连接对象
SqlConnection con = new SqlConnection("server=.;database=OA;uid=sa;pwd=sa");
//打开数据库连接
con.Open();
//创建命令对象
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
// 定义字符串变量FSelectName
string FSelectName = String.Format("select id,name,passwd from member where name='{0}' and passwd='{1}'", this.Login1.UserName, this.Login1.Password);
cmd.Connection = con;
cmd.CommandText = FSelectName;
//将查询结果集获取
IDataReader idr = cmd.ExecuteReader();
DataTable dt = new DataTable();
//将结果赋给虚拟表
dt.Load(idr);
//如果没有查询到数据
if (dt.Rows.Count == 0)
...{
//原页面不跳转
return;
}
//否则
else
...{
//为 Session 赋值
Session["id"] = dt.Rows[0][0];
Session["name"] = dt.Rows[0][1];
//页面跳转
Response.Redirect("Member_register.aspx");
}
}
... {
//创建数据库连接对象
SqlConnection con = new SqlConnection("server=.;database=OA;uid=sa;pwd=sa");
//打开数据库连接
con.Open();
//创建命令对象
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
// 定义字符串变量FSelectName
string FSelectName = String.Format("select id,name,passwd from member where name='{0}' and passwd='{1}'", this.Login1.UserName, this.Login1.Password);
cmd.Connection = con;
cmd.CommandText = FSelectName;
//将查询结果集获取
IDataReader idr = cmd.ExecuteReader();
DataTable dt = new DataTable();
//将结果赋给虚拟表
dt.Load(idr);
//如果没有查询到数据
if (dt.Rows.Count == 0)
...{
//原页面不跳转
return;
}
//否则
else
...{
//为 Session 赋值
Session["id"] = dt.Rows[0][0];
Session["name"] = dt.Rows[0][1];
//页面跳转
Response.Redirect("Member_register.aspx");
}
}
页面传值取值
//
页面传值方法
Response.Redirect( " M_register_2nd.aspx?name=string&id=string " );
// 页面传递变量方法
Response.Redirect( string .Format( " M_register_2nd.aspx?name={0} " , this .CreateUserWizard1.UserName));
// 页面取值方法
string str1 = Request.QueryString[ " name " ];
Response.Redirect( " M_register_2nd.aspx?name=string&id=string " );
// 页面传递变量方法
Response.Redirect( string .Format( " M_register_2nd.aspx?name={0} " , this .CreateUserWizard1.UserName));
// 页面取值方法
string str1 = Request.QueryString[ " name " ];