Excel、记事本数据导入到数据库的实现方法

文件示例：
Excel：

记事本：

前台代码：
代码如下:
<div class="tab-content detail" id="divSecond" runat="server" visible="false">
            <fieldset >
             <p>
                <label>
                  选择文件</label>
                  <asp:FileUpload ID="FileUpload1" runat="server"  /><asp:RequiredFieldValidator
                      ID="RequiredFieldValidator1" runat="server" ErrorMessage="请选择要提交的Excel文件" ControlToValidate="FileUpload1"></asp:RequiredFieldValidator>
              </p>
              <p>
              <label>文件示例</label><img src="../images/ex_excel.jpg" />
              </p>
            </fieldset>
            <div class="clear"></div>
           <div class="clear"></div>
            <div style="margin-left:200px">
                <asp:Button ID="btnExcel" runat="server" Text="提 交" CssClass="button" 
                    onclick="btnExcel_Click"  />
                     
                <input class="button" type="button" value="返 回" onclick="javascript:window.location.href='CartList.aspx'" />
            </div>
          </div>
          <div class="tab-content detail" id="divThird" runat="server" visible="false">