Are you looking for right? Are you also searching for a topic Part 18 Load xml data into sql server table using sqlbulkcopy? If this is the case then please see it right here
Mục lục bài viết
Part 18 Load xml data into sql server table using sqlbulkcopy | Website offers computer tips.
[button size=”medium” style=”primary” text=”WATCH VIDEO BELOW” link =”” target=””]
In this video we will discuss
1. What is the use of SqlBulkCopy class
2. Loading xml data into sql server table using sqlbulkcopy
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.
What is the use of SqlBulkCopy class
SqlBulkCopy class is used to bulk copy data from different data sources to SQL Server database. This class is present in System.Data.SqlClient namespace. This class can be used to write data only to SQL Server tables. However, the data source is not limited to SQL Server, any data source can be used, as long as the data can be loaded to a DataTable instance or read with a IDataReader instance.
From a performance standpoint, SqlBulkCopy makes it very easy and efficient to copy large amounts of data.
Loading xml data into sql server table using sqlbulkcopy
The following are the steps to achieve this using SqlBulkCopy class
Step 1 : Create the database tables using the following sql script
Create table Departments
(
ID int primary key,
Name nvarchar(50),
Location nvarchar(50)
)
GO
Create table Employees
(
ID int primary key,
Name nvarchar(50),
Gender nvarchar(50),
DepartmentId int foreign key references Departments(Id)
)
GO
Step 2 : Create a new empty asp.net web application project. Name it Demo.
Step 3 : Add a new xml file to the project. Name it Data.xml. Copy and paste the following XML.
[?xml version=”1.0″ encoding=”utf-8″ ?]
[Data]
[Department Id=”1″]
[Name]IT[/Name]
[Location]New York[/Location]
[/Department]
[Department Id=”2″]
[Name]HR[/Name]
[Location]London[/Location]
[/Department]
[Department Id=”3″]
[Name]Payroll[/Name]
[Location]Mumbai[/Location]
[/Department]
[Employee Id=”1″]
[Name]Mark[/Name]
[Gender]Male[/Gender]
[DepartmentId]1[/DepartmentId]
[/Employee]
[Employee Id=”2″]
[Name]John[/Name]
[Gender]Male[/Gender]
[DepartmentId]1[/DepartmentId]
[/Employee]
[Employee Id=”3″]
[Name]Mary[/Name]
[Gender]Female[/Gender]
[DepartmentId]2[/DepartmentId]
[/Employee]
[Employee Id=”4″]
[Name]Steve[/Name]
[Gender]Male[/Gender]
[DepartmentId]2[/DepartmentId]
[/Employee]
[Employee Id=”5″]
[Name]Ben[/Name]
[Gender]Male[/Gender]
[DepartmentId]3[/DepartmentId]
[/Employee]
[/Data]
Step 4 : Include the database connection string in web.config file
[connectionStrings]
[add name=”CS” connectionString=”server=.;database=Sample;integrated security=true”/]
[/connectionStrings]
Step 5 : Add a new WebForm to the project. Drag and drop a button control on the webform. Double click the button control to generate the click event handler. Copy and paste the following code in the the click event handler method.
string cs = ConfigurationManager.ConnectionStrings[“CS”].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath(“~/Data.xml”));
DataTable dtDept = ds.Tables[“Department”];
DataTable dtEmp = ds.Tables[“Employee”];
con.Open();
using (SqlBulkCopy sb = new SqlBulkCopy(con))
sb.DestinationTableName = “Departments”;
sb.ColumnMappings.Add(“ID”, “ID”);
sb.ColumnMappings.Add(“Name”, “Name”);
sb.ColumnMappings.Add(“Location”, “Location”);
sb.WriteToServer(dtDept);
using (SqlBulkCopy sb = new SqlBulkCopy(con))
sb.DestinationTableName = “Employees”;
sb.ColumnMappings.Add(“ID”, “ID”);
sb.ColumnMappings.Add(“Name”, “Name”);
sb.ColumnMappings.Add(“Gender”, “Gender”);
sb.ColumnMappings.Add(“DepartmentId”, “DepartmentId”);
sb.WriteToServer(dtEmp);
Note: Please make sure to include the following using declarations
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
Text version of the video
Slides
All ADO .NET Text Articles
All ADO .NET Slides
All Dot Net and SQL Server Tutorials in English
All Dot Net and SQL Server Tutorials in Arabic
..
You can also view more information regarding internet tips about the game by us here: https://bem2.vn
You can read more share computer tips here:View more information here.
sqlbulkcopy c#,load xml data into sql server,insert xml data into sql table using c#,c# sqlbulkcopy datatable example,c# sqlbulkcopy xml data,sqlbulkcopy example,c# sqlbulkcopy example,c# sqlbulkcopy class,bulk copy class c#,asp.net sqlbulkcopy datatable,asp.net c# sqlbulkcopy,insert data using sqlbulkcopy in c#,c# bulkcopy datatable.
#Part #Load #xml #data #sql #server #table #sqlbulkcopy.
We hope this information is useful to you, thank you very much for following this article.
In this video we will discuss
1. What is the use of SqlBulkCopy class
2. Loading xml data into sql server table using sqlbulkcopy
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.
What is the use of SqlBulkCopy class
SqlBulkCopy class is used to bulk copy data from different data sources to SQL Server database. This class is present in System.Data.SqlClient namespace. This class can be used to write data only to SQL Server tables. However, the data source is not limited to SQL Server, any data source can be used, as long as the data can be loaded to a DataTable instance or read with a IDataReader instance.
From a performance standpoint, SqlBulkCopy makes it very easy and efficient to copy large amounts of data.
Loading xml data into sql server table using sqlbulkcopy
The following are the steps to achieve this using SqlBulkCopy class
Step 1 : Create the database tables using the following sql script
Create table Departments
(
ID int primary key,
Name nvarchar(50),
Location nvarchar(50)
)
GO
Create table Employees
(
ID int primary key,
Name nvarchar(50),
Gender nvarchar(50),
DepartmentId int foreign key references Departments(Id)
)
GO
Step 2 : Create a new empty asp.net web application project. Name it Demo.
Step 3 : Add a new xml file to the project. Name it Data.xml. Copy and paste the following XML.
[?xml version=”1.0″ encoding=”utf-8″ ?]
[Data]
[Department Id=”1″]
[Name]IT[/Name]
[Location]New York[/Location]
[/Department]
[Department Id=”2″]
[Name]HR[/Name]
[Location]London[/Location]
[/Department]
[Department Id=”3″]
[Name]Payroll[/Name]
[Location]Mumbai[/Location]
[/Department]
[Employee Id=”1″]
[Name]Mark[/Name]
[Gender]Male[/Gender]
[DepartmentId]1[/DepartmentId]
[/Employee]
[Employee Id=”2″]
[Name]John[/Name]
[Gender]Male[/Gender]
[DepartmentId]1[/DepartmentId]
[/Employee]
[Employee Id=”3″]
[Name]Mary[/Name]
[Gender]Female[/Gender]
[DepartmentId]2[/DepartmentId]
[/Employee]
[Employee Id=”4″]
[Name]Steve[/Name]
[Gender]Male[/Gender]
[DepartmentId]2[/DepartmentId]
[/Employee]
[Employee Id=”5″]
[Name]Ben[/Name]
[Gender]Male[/Gender]
[DepartmentId]3[/DepartmentId]
[/Employee]
[/Data]
Step 4 : Include the database connection string in web.config file
[connectionStrings]
[add name=”CS” connectionString=”server=.;database=Sample;integrated security=true”/]
[/connectionStrings]
Step 5 : Add a new WebForm to the project. Drag and drop a button control on the webform. Double click the button control to generate the click event handler. Copy and paste the following code in the the click event handler method.
string cs = ConfigurationManager.ConnectionStrings[“CS”].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath(“~/Data.xml”));
DataTable dtDept = ds.Tables[“Department”];
DataTable dtEmp = ds.Tables[“Employee”];
con.Open();
using (SqlBulkCopy sb = new SqlBulkCopy(con))
sb.DestinationTableName = “Departments”;
sb.ColumnMappings.Add(“ID”, “ID”);
sb.ColumnMappings.Add(“Name”, “Name”);
sb.ColumnMappings.Add(“Location”, “Location”);
sb.WriteToServer(dtDept);
using (SqlBulkCopy sb = new SqlBulkCopy(con))
sb.DestinationTableName = “Employees”;
sb.ColumnMappings.Add(“ID”, “ID”);
sb.ColumnMappings.Add(“Name”, “Name”);
sb.ColumnMappings.Add(“Gender”, “Gender”);
sb.ColumnMappings.Add(“DepartmentId”, “DepartmentId”);
sb.WriteToServer(dtEmp);
Note: Please make sure to include the following using declarations
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
Text version of the video
Slides
All ADO .NET Text Articles
All ADO .NET Slides
All Dot Net and SQL Server Tutorials in English
All Dot Net and SQL Server Tutorials in Arabic
..
