跳转检索传值.doc

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; 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; public static DataSet Query(string SQLString) using (SqlConnection connection = new SqlConnection(connectionString) DataSet ds = new DataSet(); try connection.Open(); SqlDataAdapter command = new SqlDataAdapter(SQLString, connection); command.Fill(ds, ds); catch (System.Data.SqlClient.SqlException ex) throw new Exception(ex.Message); return ds; 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 us = getUser(sql); if (us != null) Sessionuser = us; Response.Redirect(Main.aspx); else lblTishi.Text = 用户名或密码出错; protected UserInfo getUser(string sql) UserInfo us = null; SqlDataReader myReader = DBHelper.ExecuteReader(sql); if (myReader.Read() us = new UserInfo(); us.UserName = myReaderUserName.ToString(); us.PassWord = myReaderPassWord.ToString(); us.XingMing = myReaderXingMing.ToString(); us.Age = myReaderAge.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 = us.XingMing; else Response.Redirect(Login.aspx); protected void btnOut_Click(object sender, EventArgs e) Response.Redirect(Login.aspx); public partial class UserInform : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) if(!IsPostBack) string sql=string.Format(select * from UserInfo order by sort); bindDataGridView(sql); protected void btnRet_Click(object sender, EventArgs e) string sql=string.Format(select * from UserInfo where XingMing like %0%,txtName.Text.Trim(); bindDataGridView(sql); protected void bi