GridView读取数据XLS ACCESS MDB 并写入到数据库

最新推荐文章于 2023-12-06 17:52:12 发布

厦门德仔

最新推荐文章于 2023-12-06 17:52:12 发布

阅读量1.8k

点赞数

分类专栏： # WebForm 文章标签： access dataset string button server 数据库

本文链接：https://blog.csdn.net/david_520042/article/details/5027945

版权

WebForm 专栏收录该内容

77 篇文章 0 订阅

订阅专栏

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ReadExcel_CS.aspx.cs" Inherits="ReadExcel_CS" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="写入数据库" />
        <asp:GridView ID="GridView1" runat="server">
             </asp:GridView>
         
            <asp:GridView ID="GridView2" runat="server">
             </asp:GridView>
    </div>
    </form>
</body>
</html>
-------------------------------------

   using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class ReadExcel_CS : System.Web.UI.Page
{
     public DataTable DT;
     protected void Page_Load(object sender, EventArgs e)
     {
         //read excel file
         string strConn;
         strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
         "Data Source=C://test.xls;" +
         "Extended Properties=Excel 8.0;";

         OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);

         DataSet myDataSet = new DataSet();
         myCommand.Fill(myDataSet, "ExcelInfo");
         this.GridView1.DataSource = myDataSet.Tables["ExcelInfo"].DefaultView;
         this.GridView1.DataBind();

          DT = (DataTable)myDataSet.Tables["ExcelInfo"];
         /*
         //read access file
         string strConn2;
         strConn2 = "Provider=Microsoft.Jet.OLEDB.4.0;" +
         "Data Source=c://test.mdb;" +
         "Persist Security Info=True;";

         OleDbDataAdapter myCommand2 = new OleDbDataAdapter("select * from test", strConn2);

         DataSet myDataSet2 = new DataSet();
         myCommand2.Fill(myDataSet2, "AccessInfo");
         this.GridView2.DataSource = myDataSet2.Tables["AccessInfo"].DefaultView;
         this.GridView2.DataBind();
          */

     }
     protected void Button1_Click(object sender, EventArgs e)
     {
         /*
         //写入数据库david
         for (int i = 1; i < GridView1.Rows.Count; i++)
         {
             for (int j = 1; j < 3 ; j++)
             {
                 string a = GridView1.Rows[i].Cells[j].ToString() ;
                 Response.Write(a.ToString() );
             }

         }
          */
         for (int i = 0; i < DT.Rows.Count; i++)
         {
             //for (int j = 0; j < DT.Columns.Count; j++)
             //{
                 string A=DT.Rows[i][0].ToString();
                 string B= DT.Rows[i][1].ToString();
                 string C = DT.Rows[i][2].ToString();
                 string D = DT.Rows[i][3].ToString();

                 string sqlinsert = "insert TEST(A,B,C,D)values('"+A+"','"+B+"','"+C+"','"+D+"')";
                 DataAccess.DataAccessSHDB.GetNonQuery(sqlinsert.ToString());
                 //Response.Write(a.ToString()+",");
             //}
         }
     }
}

厦门德仔

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
GridView读取数据XLS ACCESS MDB 并写入到数据库

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://www.w3.org/1999/xhtml" > 无标题页   ----------------
复制链接

扫一扫