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


public?partial?class?admin_loadinstu?:?System.Web.UI.Page
{
???//?string?strConn?=?“Data?Source=.;Database=InOut;Uid=sa;Pwd=123“;?//鏈接SQL數據庫
????string?strConn?=?“Data?Source=.;Initial?Catalog=InOut;Integrated?Security=True“;
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（Session[“login“]?!=?“ok“）
????????{
????????????Response.Redirect（“index.aspx“）;
????????}
????????SqlConnection?cn?=?new?SqlConnection（strConn）;
????????cn.Open（）;
????????SqlDataAdapter?sda?=?new?SqlDataAdapter（“select?*?from?student?order?by?numID“?cn）;
????????DataSet?ds?=?new?DataSet（）;
????????sda.Fill（ds?“student“）;
????????this.GridView1.DataSource?=?ds.Tables[“student“];
????????this.GridView1.DataKeyNames?=?new?string[]?{?“stuID“?};
????????this.GridView1.DataBind（）;
????}
????public?DataSet?ExecleDs（string?filenameurl?string?table）
????{


????????string?strConn?=?““;
????????string?IsXls?=?System.IO.Path.GetExtension（FileUpload1.FileName）.ToString（）.ToLower（）;//System.IO.Path.GetExtension獲得文件的擴展名
????????if?（IsXls?==?“.xls“）
????????{
????????????//此連接只能操作Excel2007之前（.xls）文件
????????????strConn?=?“Provider=Microsoft.Jet.OleDb.4.0;“?+?“data?source=“?+?filenameurl?+?“;Extended?Properties=‘Excel?8.0;HDR=YES;?IMEX=1‘“;
????????}
????????else?if?（IsXls?==?“.xlsx“）
????????{
????????????strConn?=?“Provider=Microsoft.ACE.OLEDB.12.0;Data?Source=“?+?filenameurl?+?“;Extended?Properties=‘Excel?12.0;HDR=YES;IMEX=1‘“;
????????????//此連接可以操作.xls與.xlsx文件?（支持Excel2003?和?Excel2007?的連接字符串）
????????????//備注：?“HDR=yes;“是說Excel文件的第一行是列名而不是數據，“HDR=No;“正好與前面的相反。
????????????//??????“IMEX=1?“如果列中的數據類型不一致，使用“IMEX=1“可必免數據類型沖突。
????????}
????????OleDbConnection?conn?=?new?OleDbConnection（strConn）;
????????try
????????{
????????????conn.Open（）;
????????}
????????catch?（MembershipCreateUserException?ex）???????//捕捉異常
????????{
????????????Response.Write（“ript>alert（‘數據庫連接錯誤！‘）ript>“）;
????????}
????????DataSet?ds?=?new?DataSet（）;
????????OleDbDataAdapter?odda?=?new?OleDbDataAdapter（“select?*?from?[Sheet1$]“?conn）;
????????odda.Fill（ds?table）;
????????return?ds;
????}
????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
????????if?（FileUpload1.HasFile?==?false）//HasFile用來檢查FileUpload是否有指定文件
????????{
????????????Response.Write（“ript>alert（‘請您選擇Excel文件‘）ript>?“）;
????????????return;//當無文件時返回
????????}
????????string?IsXls?=?System.IO.Path.GetExtension（FileUpload1.FileName）.ToString（）.ToLower（）;//System.IO.Path.GetExtension獲得文件的擴展名
????????if?（IsXls?!=?“.xls“?&&?IsXls?!=?“.xlsx“）
????????{
????????????Response.Write（“ript>alert（‘只可以選擇Excel文件‘）