日期:2014-05-16  浏览次数:21422 次

IIS7 下上传读取Excel 表格数据,并添加到数据库



<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)