how to insert xml file into sql server 2006 database structure using visual c#

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Kelley » how to insert xml file into sql server 2006...

how to insert xml file into sql server 2006 database structure using visual c#

Rate Topic

Display Mode

Topic Options

Author

Message

Raymond-710502

Posted Monday, April 14, 2008 4:00 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 14, 2008 3:52 AM
Points: 1, Visits: 0

i need help : i want to insert xml file into sql server2005 database table using c# such that i can access the file from c# console application

Post #484288

brandstefan

Posted Friday, February 01, 2013 1:31 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 01, 2013 1:23 PM
Points: 1, Visits: 1

Hi, Here is an exampel.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Xml;
using System.Data;

namespace XMLImportToSQL
{
public class XMLImport
{

//Create a Connectionstring to SQL Server
// Trust connection (Server=;Database=;Trusted_Connection=True;)
public static string SQLConn = "Server= Your server;Database= your database;User Id= User namn;Password= Password;"

public void SaveXmlToSqlServer()
{
//Create the XML Document for tranactions
m_xmld = new XmlDocument();

//Load the Xml file
m_xmld.Load(@"C:\XmlFile.xml");

//Get the list of name nodes
XmlNodeList financialyears = m_xmld.SelectNodes("/MainNod/Nod");

//Loop through the XmlNode

foreach (XmlNode financialyear in financialyears)
{
// Get the Costcenter Attribute Value
id = financialyear.ChildNodes.Item(0).InnerText;
fromdate = financialyear.ChildNodes.Item(1).InnerText;
todate = financialyear.ChildNodes.Item(2).InnerText;

// Update if value has change else Insert new row
using (SqlConnection conn = new SqlConnection(SQLConn))
{
SqlCommand sqlCmdUpdate = new SqlCommand();
sqlCmdUpdate = new SqlCommand("Update_Insert_Financialyears", conn);
sqlCmdUpdate.CommandType = CommandType.StoredProcedure;

sqlCmdUpdate.Parameters.AddWithValue("@id", id);
sqlCmdUpdate.Parameters.AddWithValue("@fromdate", fromdate);
sqlCmdUpdate.Parameters.AddWithValue("@todate", todate);

// Check to see if the state is closed.
if (conn.State == ConnectionState.Closed)
{
// Open the connection.
conn.Open();
}
sqlCmdUpdate.ExecuteNonQuery();

// Check to see if the state is open.
if (conn.State == ConnectionState.Open)
{
// Open the connection.
conn.Close();
}
}

}
}
}
}
Hope this will help you?

Regads
Stefan Brand

Post #1414841

Sean Lange

Posted Friday, February 01, 2013 1:47 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 1:17 PM
Points: 8,641, Visits: 8,273

Not sure they will see this. This was posted nearly 5 years ago and the poster has not logged in since then. BigGrin

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1414844

« Prev Topic | Next Topic »

Permissions