how to save it ??

// Update database
SqlDataAdapter adp=new SqlDataAdapter("select * from tableName","your_conn_str");
SqlCommandBuilder cb = new SqlCommandBuilder(adp);
DataSet ds = new DataSet();
ds.ReadXml("file.xml");
DataTable dt = ds.Tables["tableName"];
dt.Rows.Add("val1", "val2");
// Adding row
adp.Update(ds, "tableName");

Follow these steps:

1. Define a column of type "XML" in your desired table.

2. Run the INSERT query along with passing the XML data as a string. For example:

INSERT INTO MyTable(Data)
Values '<?xml version="1.0"?>
<company>
<companyname>
<group>Accenture BPO</group>
<group>Accenture IT </group>
<group>Accenture Infotech</group>
</companyname>
<companyname>HCL</companyname>
</company>'

So, if you need to save the XML programmatically, you just need to set the XML as a string value before executing the INSERT statement.

Your question is stated so poorly that nobody can possibly give you the answer you need. You didn't mention the platform, language, or what type of database you're using, so we have to guess at those as a well.

Loading and parsing the XML file in the application is actually a very simple matter. Getting the data into a database is the tricky part, because you have to be somewhat familiar with how to write a stored procedure (assuming you're using SQL Server).

Do you want to save the entire file in the database as a single field, or do you want to save the individual fields from the file as a row of columns? Both of the answers below assume that you know hoe to open a connection to your database and call a stored procedure, and that you actually have the ability to write the necessary stored procedure.

0) To save the entire file:

XDocument doc = XDocument.Load(filename);
string myDocAsString = doc.ToString();

At this point, your entire file is represented by the string, and can be saved in a single column in your database.

1) To save each record in the XML file in your database, you have to load/parse the XML file into individual objects. The best way to do that has already been described, and for some unknown reason, voted as a 1. Look at Amit Kumar Tiwari's answer closely. A DataSet can parse XML data into DataTable objects, and then you can pass those objects to the database.

Instead of being so quick to vote answers you don't like with a 1, try giving us more info so we can help you .