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

来源：互联网发布：美国新英格兰大学知乎编辑：程序博客网时间：2024/05/22 11:55
                // 写入数据库                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();                    }                }
阅读全文
0 0