protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//DataSet set = new DataSet();
//set = DataFactory();
//ObjDataBind(GridView1, set);
string str = @"Provider=Microsoft.Jet.OLEDB.4.0
;Data Source=" + Server.MapPath("學生信息表.xls") + ";Extended ProperTies=Excel 8.0";
string SqlStr = "select * from ["+"學生信息表"+"$]";
OleDbConnection con = new OleDbConnection(str);
con.Open();
OleDbDataAdapter ada = new OleDbDataAdapter(SqlStr,con);
DataTable dt = new DataTable();
ada.Fill(dt);
ObjDataBind(GridView1,dt);
}
}
//創建了壹個基本控件綁定方法
public void ObjDataBind(BaseDataBoundControl datacontrol, object DataSource)
{
datacontrol.DataSource = DataSource;
datacontrol.DataBind();
}