<asp:ScriptManager ID="ScriptManager1" runat="server">

    </asp:ScriptManager>

    <asp:UpdatePanel ID="UpdatePanel1" runat="server">

        <ContentTemplate>

            <div>

                <radU:RadProgressManager ID="RadProgressManager1" Width="100%" Height="37" runat="server" />

                <radU:RadProgressArea ID="RadProgressArea1" runat="server">

                </radU:RadProgressArea>

                <asp:FileUpload ID="FileUpload1" runat="server" />&nbsp;&nbsp;

                <asp:Button ID="btnUpload" runat="server" Text="上  传" OnClientClick="javascript:return checkTime()"

                    OnClick="btnUpload_Click" />

                <asp:Label ID="lblMessage" runat="server" Visible="False" Font-Bold="True" ForeColor="#009933"></asp:Label>

            </div>

        </ContentTemplate>

        <Triggers>

            <asp:PostBackTrigger ControlID="btnUpload" />

        </Triggers>

    </asp:UpdatePanel>

  #region 连接Excel  读取Excel数据   并返回DataSet数据集合

    /// <summary>

    /// 连接Excel  读取Excel数据   并返回DataSet数据集合

    /// </summary>

    /// <param name="filepath">Excel服务器路径</param>

    /// <param name="tableName">Excel表名称</param>

    /// <returns></returns>

    public static System.Data.DataSet ExcelSqlConnection(string filepath, string tableName, string isXls)

    {

        //    string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties='Excel  "



        //+ " 8.0;HDR=YES;IMEX=1'";

        string strCon = "";

        if (isXls == ".xls")

        {

            strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath +