?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;
using System.Data.SqlClient;

public partial class Myinfo : System.Web.UI.Page
{
    //全局變量
    private static string connstr = "Server=localhost;Database=Materialsystem;User ID=sa";
    SqlConnection stuinfoconn = new SqlConnection(connstr);
    SqlDataAdapter stuinfoadapter;
    DataSet ds;
    protected void Page_Load(object sender, EventArgs e)
    {
        
        welcomelable.Text = Session["studentname"].ToString();
        string stunum = Session["studentnumber"].ToString().Trim();
       
        string stuinfostr = "SELECT Snum as '職工號',Sname as '姓名:',Ssex as '性別:',Ssdept as '科室:',Smajor as '類別:',Sclass as '類別' FROM Studentinfo WHERE Snum='"+stunum+"'";
        try
        {
            if(stuinfoconn.State==ConnectionState.Closed)
            {
                stuinfoconn.Open();
            }
            stuinfoadapter = new SqlDataAdapter(stuinfostr,stuinfoconn);
            ds = new DataSet();
            stuinfoadapter.Fill(ds, "Datatab");
            DetailsView1.DataSource = ds.Tables["Datatab"].DefaultView;
            DetailsView1.DataBind(); 
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        { 
            if(stuinfoconn.State==ConnectionState.Open)
            {
                stuinfoconn.Close();
            }
        }
    }
    protected void BorrowBookLinkButton_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Link/Borrow.aspx");
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Mainbody/BorrowReturn.aspx");
    }
    protected void ShowMessageLinkButton_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Link/Myinfo.aspx");
    }
    protected void ReturnBookLinkButton_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Link/Return.aspx");
    }
    protected void BorrowHistoryLinkButton_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Link/BorrowHistory.aspx");
    }
    protected void CheckPwdLinkButton_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Link/ChangePwd.aspx");
    }
    protected void LogoutLinkButton_Click(object sender, EventArgs e)
    {
        Session.Contents.Remove("studentname");
        Session.Contents.Remove("studentnum");
        Response.Redirect("../Login/Login.aspx");
    }
}