跳转用类读取数据库传值.doc

namespace class_sql public class UserInfo private string userName; private string passWord; private string xingMing; private string age; public string UserName get return userName; set userName = value; public string PassWord get return passWord; set passWord = value; public string XingMing get return xingMing; set xingMing = value; public string Age get return age; set age = value; public class DBHelper private static string connectionString=Server=I6R7IVUNHOKLYSD;Database= DBUser; Trusted_connection=SSPI; / 执行查询语句，返回SqlDataReader ( 注意：调用该方法后，一定要对SqlDataReader进行Close ) /public static SqlDataReader ExecuteReader(string strSql) / / SqlConnection con = new SqlConnection(connectionString); / SqlCommand cmd = new SqlCommand(strSql, con); / try / / con.Open(); / SqlDataReader myReader=cmd.ExecuteReader(CommandBehavior.CloseConnection); / return myReader; / / catch(System.Data.SqlClient.SqlException e) / / throw e; / / / 执行查询语句，返回DataSet public static DataSet Query(string strSql) using (SqlConnection con = new SqlConnection(connectionString) DataSet ds = new DataSet(); try con.Open(); SqlDataAdapter com = new SqlDataAdapter(strSql, con); com.Fill(ds, ds); catch (System.Data.SqlClient.SqlException ex) throw new Exception(ex.Message); return ds; using System.Data;using System.Data.SqlClient;public partial class Login : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) lblTishi.Text = string.Empty; protected void btnOk_Click(object sender, EventArgs e) string sql = string.Format(select * from UserInfo where UserName=0 and PassWord=1, txtName.Text, txtMm.Text); UserInfo use = getUser(sql); if (use != null) Sessionuser = use; Response.Redirect(Main.aspx); else lblTishi.Text = 用?户名?或密码?出?错洙?; protected UserInfo getUser(string sql) UserInfo us = null; us = new UserInfo(); /使用SqlDataReader接收 /SqlDataReader myReader = DBHelper.ExecuteReader(sql); /if (myReader.Read() / / us.UserName = myReaderUserName.ToString(); / us.PassWord = myReaderPassWord.ToString(); / us.XingMing = myReaderXingMing.ToString(); / us.Age = myReaderAge.ToString(); / /使用DataSet接收 DataTable dt = DBHelper.Query(sql).Tables0; if (!string.IsNullOrEmpty(sql) us.UserName = dt.Rows00.ToString(); us.PassWord = dt.Rows01.ToString(); us.XingMing = dt.Rows02.ToString(); us.Age = dt.Rows03.ToString(); return us; protected void btnClear_Click(object sender, EventArgs e) txtName.Text = string.Empty; txtMm.Text = string.Empty; public partial class Main : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) if (Sessionuser != null) UserInfo us = (UserInfo)Sessionuser; lblMessage.Text =