C#---批量导入数据库

谛听-

于 2017-05-17 15:24:43 发布

阅读量522

点赞数

分类专栏： C#

本文链接：https://blog.youkuaiyun.com/u012319493/article/details/72392784

版权

C# 专栏收录该内容

37 篇文章

订阅专栏

                // 写入数据库
                System.Data.DataTable tb1 = new System.Data.DataTable();
                tb1.Columns.Add("BuildingID");
                tb1.Columns.Add("GXID");
                tb1.Columns.Add("GYID");
                tb1.Columns.Add("GZID");

                for (int i = 0; i < grids.Count; i++)
                {
                    if (grids[i].Count > 0)
                    {
                        for (int l = 0; l < grids[i].Count; l++)
                        {
                             System.Data.DataRow thisrow = tb1.NewRow();
                             thisrow["BuildingID"] = grids[i][l].id;
                             thisrow["GXID"] = grids[i][l].x;
                             thisrow["GYID"] = grids[i][l].y;
                             thisrow["GZID"] = grids[i][l].z;
                             tb1.Rows.Add(thisrow);
                        }

                        using (SqlBulkCopy bcp = new SqlBulkCopy("Data Source=localhost;Initial Catalog=GZCover3D;Integrated Security=True")
                        {
                            bcp.BatchSize = grids[i].Count;
                            bcp.BulkCopyTimeout = 1000;
                            bcp.DestinationTableName = "tbBuildingGrid3D";
                            bcp.WriteToServer(tb1);
                            bcp.Close();
                        }
                        tb1.Clear();
                    }
                }