DataSet columns Names

EAI

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!

Nov 17 '05 #1

Subscribe Post Reply

1899

Dmytro Lapshyn [MVP]

Hi,

You can try to configure table and column mappings in the DataAdapter you
use to fill the dataset. In this case, the column names in the dataset can
be quite different from those returned by an SQL query.

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"EAI" <EA*@EAI.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

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!

Nov 17 '05 #2

by: Bill C. | last post by:

Hi, I've got a simple console app that just reads an XML file into a DataSet then prints out a description of each table in the DataSet, including column names and row values for each column. ...

.NET Framework

Manual binary serialization of a dataset is slow for me - why?

by: hs | last post by:

Hi I am serializing a dataset using a binary formatter as follows: IFormatter formater = new BinaryFormatter(); formatter.Serialize(stream, ds); // ds=DataSet, stream=MemoryStream .... DataSet...

C# / C Sharp

Arrays and dataset

by: Trond | last post by:

I have a webservice that is returning a dataset. In dataset there is a table with 4 columns. (LDate, LTime, LDepth and ServiceNumber) I then try to read only 2 of the columns into array (double...

C# / C Sharp

Help with DataSet return values

by: Rob | last post by:

Hi, I've been going at this for a few days and can't see the problem. Does anyone see a problem with this code? I have a call to a function that returns a dataset and when I assign values to...

ASP.NET

Retreiving Column names from Dataset / dataAdapter

by: | last post by:

Need help finding simple way to retrieve a fields (or columns) collection from a Dataset without filling it first.

Visual Basic .NET

Documents on MDI forms with Dataset?

by: al | last post by:

Greetings, Thanks in advance for your kind attension. I have been searching for documents about dynamically coding MDI forms when working with datasets. Does anyone know of any??? MTIA,...

Visual Basic .NET

Deterimine columns of dataset from code - reflection?

by: Klaus Jensen | last post by:

Hi! How do I explore in code, which properties (columns) are in a datatable? I need to run some code for each column. I guess the answer is reflection somehow, but I dont know where to start....

Visual Basic .NET

Multiple Table DataSet

by: samoore33 | last post by:

I want to list all of the items in a dataset in a textbox. The dataset has multiple tables. When I try to use the code below, even though I dim myState as the DataTable("state"). It still looks for...

Visual Basic .NET

Debug-Look at data inside a dataset?

by: Laurel | last post by:

Is there a way, in the debugger, to look at the contents of a dataset? I tried drilling down into my dataset and it's like exploring the registry! Anyway, I didn't find anything useful. The code...

C# / C Sharp

VB.NET/ADO.NET populating a dataset

by: JordanMartz | last post by:

''' <summary> ''' Populates the DataGridView ''' </summary> Private Sub PopulateDataGridView() ' Set the column header names. userAccessGrid.ColumnCount = 5 ...

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Similar topics