Hi guys

I am new in the programming field and I am trying to write code to display an xml file with 3 records under it, but this code writes 3 separate xml files each with one record, can anyone please help.

using System;
using System.Text;
using System.Collections.Generic;
using System.Linq;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using System.Xml;


namespace MCTest1
{
[TestClass]
public class UnitTest1
{

static int i = 0;
private TestContext testContextInstance;
public TestContext TestContext
{
get { return testContextInstance; }
set { testContextInstance = value; }
}


[DataSource("Microsoft.VisualStudio.TestTools.DataS ource.CSV", "|DataDirectory|\\Details.csv", "Details#csv", DataAccessMethod.Sequential), DeploymentItem("MCTest1\\Details.csv"), TestMethod]
public void Generatefiles()
{

System.Xml.XmlDocument xdoc = new System.Xml.XmlDocument();

string xml = "";
int counter = 3;

while (counter <= 3)
{
xml = "<PERSONALDETAILS>" +
"<SURNAME>" + testContextInstance.DataRow["SURNAME"] + "</SURNAME>" +
"<SURNAME>" + testContextInstance.DataRow["SURNAME"] + "</SURNAME>" +
"<SURNAME>" + testContextInstance.DataRow["SURNAME"] + "</SURNAME>" +
"</PERSONALDETAILS>";

counter = counter + 1;
}


string header = "<?xml version=\"1.0\" encoding=\"utf-8\" ?>" +
"<ns0:TransactionRequest xmlns:ns0=\"http://ABSA.DTM.NMB\">" +
"<DETAILS>";
string footer = "</DETAILS>" +
"</ns0:TransactionRequest>";

xdoc.LoadXml(header + xml + footer);


xdoc.Save(@"C:\logs\NMBMULTI" + DateTime.Now.ToString(i.ToString() + "yyyyMMdd" + testContextInstance.DataRow["SURNAME"]) + ".XML");
i++;



}
}
}