DataSet Losing Data when Column Name Contains Colon

  • Thread starter Thread starter Jacques
  • Start date Start date
J

Jacques

Hi,

Somebody else has posted something in regards to this before, but that
was back in 2002. You can see his post at:

http://groups.google.com/groups?hl=...roups?hl=en&lr=&ie=UTF-8&q=dataset+colon+.net

Microsoft has also made mention of this same problem. You can see
Microsoft's FIX at:

http://support.microsoft.com/default.aspx?scid=kb;en-us;818962

The FIX was posted in late 2003, but I have not seen any resolution to
the problem. The problem must still exist since I am experiencing it
today (2004).

So, my problem is this:

I have a dataset that gets populated by calling multiple stored
procedures. The dataset is successfully populated. The stored
procedure returns column names that contain colons (":"). When I do
WriteXml(fileName, WriteSchema), I the dataset is saved successfully.
When I load the file back, using ReadXml(fileName, ReadSchema), the
dataset (its datatables, rather) have appropriate structures. The
problem, though, is that the datatables that have column names that
contain colons, result in the column being completely populated with
DBNULL. I need help finding a work around to this. Any help is
greatly appreciated. Keep in mind that I cannot change the stored
procedure (in order to return appropriate column names).

I hope I was clear as to what my problem is.

Again, any help is greatly appreciated.

Regards.
Jacques
 
Sorry, I don't have a solution to this - just the same problem as you! Just
wondering if you ever found a solution...

Ed.
 
Hi,

I appreciate the response. I have not came upon a solution yet.
Currently I am just using an ugly hack waiting for a solution. I am,
sadly enough, just removing the colons from the column name. There
are probably other characters that cause the problem, but I'm unaware
of them. Microsoft should've fixed this by now since they know about
it.

Thanks again.
 
Back
Top