Session的使用

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Login : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void loginOk_Click(object sender, EventArgs e)
    {
        SQLDMO.SQLServer SqlEXPRESS = new SQLDMO.SQLServerClass();
        //组合SQLEXPRESS服务器名称
        string sqlServer = txtSQL.Text.ToString();
        string uid = txtUid.Text.ToString();
        string pwd = txtPwd.Text.ToString();
        try
        {
            SqlEXPRESS.Connect(sqlServer, uid, pwd);
            Session["SqlServer"] = sqlServer;
            Session["user"] = uid;
            Session["password"] = pwd;
            Response.Redirect("mainServer.aspx");
        }
        catch
        {
            Response.Write("服务器连接错误");
            for (int i = 0; i < this.Controls.Count; i++)
            {
                this.Controls[i].Visible = false;
            }
        }
    }
}

********************************************************************************************************

using System;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data;
using System.Data.SqlClient;

public partial class viewTableDetail : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string strSqlSer = Session["SqlServer"].ToString();
        string strUid = Session["user"].ToString();
        string strPwd = Session["password"].ToString();
        string DbName = Request.QueryString.Get("requestDbName");
        string TbName = Request.QueryString.Get("requestTbName");
        txtDB.Text = DbName;
        txtTB.Text = TbName;
        string strConn = "data source=" + strSqlSer + ";user id=" + strUid + ";password=" + strPwd + ";initial catalog=" + DbName;
        SqlConnection myConn = new SqlConnection(strConn);
        string strSQL = "SELECT * FROM " + TbName;
        SqlCommand myCommand = new SqlCommand(strSQL, myConn);
        myConn.Open();
        myGW.DataSource = myCommand.ExecuteReader();
        myGW.DataBind();
        myConn.Close();
    }
    protected void back_Click(object sender, EventArgs e)
    {
        Response.Redirect("mainServer.aspx");
    }
}