Hi All,

I have a console application to run a stored procedure and load an xml
document. Everything works fine but dataset automatically changes the column
names to upper case. How do I preserve case for column names?

This generated xml is validated aginst a schema and now because of case
mismatch, schema validation fails. Any help would be appreciated.

Thanks!

Hi,

I believe it changes case to what you have in your selection. Try to lower
case in your SQL statement

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"EAI" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
>
> I have a console application to run a stored procedure and load an xml
> document. Everything works fine but dataset automatically changes the
> column
> names to upper case. How do I preserve case for column names?
>
> This generated xml is validated aginst a schema and now because of case
> mismatch, schema validation fails. Any help would be appreciated.
>
> Thanks!
>
>