excel数据装载入dataset。并使用bulkcopy倒入数据库

protected void Button1_Click(object sender, EventArgs e)
    {
        Server.ScriptTimeout = 100;
        string path = this.Server.MapPath("1.xls");
        SqlConnection conn = new SqlConnection("Data Source=192.168.1.150;Initial Catalog=WebDiskDB;User ID=sa;Password=XXX");
        conn.Open();
        //SqlBulkCopy倒入数据
        SqlBulkCopy bulkCopy = new SqlBulkCopy(conn);
        bulkCopy.BulkCopyTimeout = 200;
        bulkCopy.DestinationTableName = "dbo.ok2";
        bulkCopy.WriteToServer(UploadExcelData(path, "Sheet1").Tables[0]);
        bulkCopy.Close();
        conn.Close(); 
        string path = this.Server.MapPath("1.xls");
        DataTable dt = UploadExcelData(path, "Sheet1").Tables[0];
        Response.Write(dt.Rows[0][0].ToString());
   
    }
    public DataSet UploadExcelData(string FileName, string SheetName)
    {
        string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileName + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\";";
        OleDbConnection conn = new OleDbConnection(strConn);
        string strExcel = "select * from [Sheet1$]";
        OleDbDataAdapter XlsCommand = null;
        DataSet ds = new DataSet();
        try
        {
            conn.Open();
            XlsCommand = new OleDbDataAdapter(strExcel, strConn);
            XlsCommand.Fill(ds,"Sheet1");
        }
        catch (Exception ex)
        {
            Response.Write("错误!:" + ex.Message.ToString());
        }
        finally
        {
            conn.Close();
            conn.Dispose();
        }
        return ds;