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

文件示例：
Excel：

记事本：

前台代码：

复制代码 代码如下:

<div runat="server" visible="false">
            <fieldset >
             <p>
                <label>
                  选择文件</label>
                  <asp:FileUpload runat="server"  /><asp:RequiredFieldValidator
                      runat="server" ErrorMessage="请选择要提交的Excel文件" ControlToValidate="FileUpload1"></asp:RequiredFieldValidator>
              </p>
              <p>
              <label>文件示例</label><img src="https://www.jb51.net/images/ex_excel.jpg" />
              </p>
            </fieldset>
            <div></div>
           <div></div>
            <div>
                <asp:Button runat="server" Text="提 交" CssClass="button" 
                     />
                  &nbsp;&nbsp;&nbsp;
                <input type="button" value="返 回" />
            </div>
          </div>
          <div runat="server" visible="false">
            <fieldset >
              <p>
                <label>
                  选择文件</label>
                  <asp:FileUpload runat="server" /> <asp:RequiredFieldValidator
                      runat="server" ErrorMessage="请选择要提交的tTXT文件"
                      ControlToValidate="FileUpload2"></asp:RequiredFieldValidator>
              </p>
              <p>
              <label>文件示例</label><img src="https://www.jb51.net/images/ex_txt.jpg" />
              </p>
            </fieldset>
            <div></div>
           <div></div>
            <div>
                <asp:Button runat="server" Text="提 交" CssClass="button"
                     />
                  &nbsp;&nbsp;&nbsp;
                <input type="button" value="返 回" />
            </div>
          </div>

复制代码 代码如下: