Hi Old Hand,

You are absolutely correct that it is only important in the presentation layer but the application is already in use with the long names. To go back and...

I think I haven't explained the whole picture very clearly. Let me start from the begining. I am using C# .NET V1.1 for an application that will retreive data from...

Here is the code from the client side application written in C# .NET

private void LoadDataSet(string returnxml)

{

 System.IO.StringReader xmlSR = new System.IO.StringReader(returnXml);

 dsMedication.ReadXml(xmlSR,XmlReadMode.Auto);

 //Other functionality here

}

As you can see the above code reads in...

Below is part of the stored procedure that returns the xml:

select '<MDS>'

select  1 as TAG,

          0 as parent,

          Q1.MedicationID as [Medication!1!MedicationID],

          Q1.PatientID as [Medication!1!MedicationName]

from Medication Q1

WHERE  Q1.MedicationID = @MedicationID...