[ShikhaTan]

How to save XML database in SQL Server 2012/2014 using C#

[ShikhaTan]

Use DataSet to get the XML string.

private void SaveXMLToDatabase()
{

   DataSet dataSet = new DataSet("dataSet");
    DataTable table = dataSet.Tables.Add("Items");
    table.Columns.Add("id", typeof(int));
    table.Columns.Add("Item", typeof(string));

    // Add ten rows.
    DataRow row;
    for(int i = 0; i <10;i++)
    {
        row = table.NewRow();
        row["id"]= i;
        row["Item"]= "Item" + i;
        table.Rows.Add(row);
    }

     string xmlString = dataSet.GetXml();
// INSERT TO SQL DATABASE

}