从Excel中读取数据
string xlsPath = FileUpload1.PostedFile.FileName;
string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1\";" + "data source=" + xlsPath;
OleDbConnection cnnxls = new OleDbConnection(connStr);
OleDbDataAdapter myDa = new OleDbDataAdapter("select * from [Sheet1$] ", cnnxls);
DataSet myDs = new DataSet();
myDa.Fill(myDs);