ds.ReadXml(Server.MapPath("~/Data.xml"))
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; using System.Configuration; namespace WebApplication1 { public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Unnamed1_Click(object sender, EventArgs e) { string cs = ConfigurationManager.ConnectionStrings["CS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { DataSet ds = new DataSet(); ds.ReadXml(Server.MapPath("~/Data.xml")); DataTable mOb = ds.Tables["managedObject"]; DataTable mOb_p = ds.Tables["p"]; con.Open(); using (SqlBulkCopy sb = new SqlBulkCopy(con)) { sb.DestinationTableName = "managedObject"; sb.ColumnMappings.Add("managedObject_Id", "managedObject_Id"); sb.ColumnMappings.Add("class", "class"); sb.ColumnMappings.Add("version", "version"); sb.ColumnMappings.Add("distName", "distName"); sb.ColumnMappings.Add("id", "id"); sb.ColumnMappings.Add("cmData_Id", "cmData_Id"); sb.BatchSize = 500000; sb.BulkCopyTimeout = 10800; sb.WriteToServer(mOb); } using (SqlBulkCopy sb = new SqlBulkCopy(con)) { sb.DestinationTableName = "p"; sb.ColumnMappings.Add("name", "name"); sb.ColumnMappings.Add("p_text", "p_text"); sb.ColumnMappings.Add("managedObject_Id", "managedObject_Id"); sb.BatchSize = 500000; sb.BulkCopyTimeout = 10800; sb.WriteToServer(mOb_p); } } } } }
BatchSize
SqlBulkCopy
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)