amberdextrous
MIS
I have a problem creating an XML file from a SQL Server 2005 table. This is all within a VB 2005 program I'm making. I run a query against the table and store the results in a dataset. Then I call
Unfortunately, the table is poorly designed. All the columns have spaces in the names, so when the XML file is generated, you see a lot of this:
This looks quite bad when you have 20 columns and 30 records with these messy element tags. I'm trying to convince my manager to change the column names, but in the event he won't do it...
Is there a way I can specify in my VB code to replace blank spaces with underscores (_) in my XML documents' element tags? This way it won't insert "_x00A0_" whereever there's a space.
Code:
objDataSet.WriteXML()
Unfortunately, the table is poorly designed. All the columns have spaces in the names, so when the XML file is generated, you see a lot of this:
Code:
<Agency_x00A0_code>yadayada</Agency_x00A0_code>
This looks quite bad when you have 20 columns and 30 records with these messy element tags. I'm trying to convince my manager to change the column names, but in the event he won't do it...
Is there a way I can specify in my VB code to replace blank spaces with underscores (_) in my XML documents' element tags? This way it won't insert "_x00A0_" whereever there's a space.