SQLBulkcopy

 
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Xml;
using System.Data.SqlClient;
namespace SqlBulkCopy1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string connectionString = "Data Source=AK\\SQLEXPRESS;Initial Catalog=Test3;Integrated Security=True";
DataSet ds = new DataSet();
DataTable sourcedata = new DataTable();
ds.ReadXml(@"http://netken.se/test/id=1&omgang=3485.xml");
sourcedata = ds.Tables[0];

using (SqlConnection sqlconn = new SqlConnection(connectionString))
{
sqlconn.Open();
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlconn))
{

 
bulkCopy.DestinationTableName = "Tbl_Test3";
bulkCopy.WriteToServer(sourcedata);
}
}
}