ADO appears corrupted?

[Anil Gupte/iCinema.com]

I am having huge problems with my dataset. The change I made was that I was
reading all the information from a plain text file (include column names and
data etc.). Now, I have encrypted the file, then I decrypt it (it decrypts
just fine). I then put the strings obtained in an array and parse each line
(earlier, I was using readline and then parsing each line). Anyway, to cut
a long story short, it appears to create the DataSet, but nothing works - it
won't even recognize the column names. Even in my watch window, if I put in
an expression, I get an error as shown below:

ds.Tables("Profiles").Select("ProfileID='0'") Run-time exception thrown :
System.Data.EvaluateException - Cannot find column [ProfileID].

So you would think I don't have a column by that name. Well in the same
Watch Window, I get the following:

ds.Tables("Profiles").Columns(0).ColumnName "ProfileID" String

Which means that column exists! What is going on? And how can I fix it?

Please help! My software is stuck on this and I am trying to meet a
deadline!

Thanx in advance,
--
Anil Gupte

[Siv]

Anil,
Just a guess, but do you need the double quotes around the
"Select("ProfileID='0'") " ie will it work with

ds.Tables("Profiles").Select(ProfileID='0')

Siv
"Anil Gupte/iCinema.com" <an*******@icinema.comwrote in message
news:u1**************@TK2MSFTNGP03.phx.gbl...

>I am having huge problems with my dataset. The change I made was that I
was reading all the information from a plain text file (include column
names and data etc.). Now, I have encrypted the file, then I decrypt it
(it decrypts just fine). I then put the strings obtained in an array and
parse each line (earlier, I was using readline and then parsing each line).
Anyway, to cut a long story short, it appears to create the DataSet, but
nothing works - it won't even recognize the column names. Even in my watch
window, if I put in an expression, I get an error as shown below:

ds.Tables("Profiles").Select("ProfileID='0'") Run-time exception thrown :
System.Data.EvaluateException - Cannot find column [ProfileID].

So you would think I don't have a column by that name. Well in the same
Watch Window, I get the following:

ds.Tables("Profiles").Columns(0).ColumnName "ProfileID" String

Which means that column exists! What is going on? And how can I fix it?

Please help! My software is stuck on this and I am trying to meet a
deadline!

Thanx in advance,
--
Anil Gupte

[Steve Gerrard]

Anil Gupte/iCinema.com wrote:

I am having huge problems with my dataset. The change I made was
that I was reading all the information from a plain text file
(include column names and data etc.). Now, I have encrypted the
file, then I decrypt it (it decrypts just fine). I then put the
strings obtained in an array and parse each line (earlier, I was
using readline and then parsing each line). Anyway, to cut a long
story short, it appears to create the DataSet, but nothing works - it
won't even recognize the column names. Even in my watch window, if I
put in an expression, I get an error as shown below:
ds.Tables("Profiles").Select("ProfileID='0'") Run-time exception
thrown : System.Data.EvaluateException - Cannot find column
[ProfileID].
So you would think I don't have a column by that name. Well in the
same Watch Window, I get the following:

ds.Tables("Profiles").Columns(0).ColumnName "ProfileID" String

Which means that column exists! What is going on? And how can I fix
it?

My first guess would be that the column name 'appears' to be "ProfileID", but in
fact has some extra non-printing character on it.
What does
?ds.Tables("Profiles").Columns(0).ColumnName = "ProfileID"
evaluate to? Is it the same as
?
?ds.Tables("Profiles").Columns(0).ColumnName.Trim = "ProfileID"

If you have gone through text, compression, decompression, reconstruct table, it
seems possible. Going back to that code, and using Trim on all the names before
assigning them, might clean it up.

[Anil Gupte/iCinema.com]

No that will not work (Itriedd it just in case). In fact the correct way to
do it would be

dim strSelect as string = "ProfileID='" & defaultprofile & "'"

dim dr as datarow() = ds.Tables("Profiles").Select(strSelect)
--
Anil Gupte
www.keeninc.net
www.icinema.com
www.wizo.tv
"Siv" <[e-mail] in message
news:9B**********************************@microsof t.com...

Anil,
Just a guess, but do you need the double quotes around the
"Select("ProfileID='0'") " ie will it work with

ds.Tables("Profiles").Select(ProfileID='0')

Siv
"Anil Gupte/iCinema.com" <an*******@icinema.comwrote in message
news:u1**************@TK2MSFTNGP03.phx.gbl...

>>I am having huge problems with my dataset. The change I made was that I
was reading all the information from a plain text file (include column
names and data etc.). Now, I have encrypted the file, then I decrypt it
(it decrypts just fine). I then put the strings obtained in an array and
parse each line (earlier, I was using readline and then parsing each
line). Anyway, to cut a long story short, it appears to create the
DataSet, but nothing works - it won't even recognize the column names.
Even in my watch window, if I put in an expression, I get an error as
shown below:

ds.Tables("Profiles").Select("ProfileID='0'") Run-time exception thrown :
System.Data.EvaluateException - Cannot find column [ProfileID].

So you would think I don't have a column by that name. Well in the same
Watch Window, I get the following:

ds.Tables("Profiles").Columns(0).ColumnName "ProfileID" String

Which means that column exists! What is going on? And how can I fix it?

Please help! My software is stuck on this and I am trying to meet a
deadline!

Thanx in advance,
--
Anil Gupte

[Anil Gupte/iCinema.com]

I meant to send this to the group:
I thought that I had checked that, but surprisingly I get

ds.Tables("Profiles").Columns(0).ColumnName = "ProfileID"

and

ds.Tables("Profiles").Columns(0).ColumnName.Length = 10

!!! It should be 9!

However, I cut and paste the first line into Notepad and Word, but cannot
see any extraneous characters. Any idea how to solve this puzzle? How does
one see a "null character"?

Thanx,
Anil Gupte

But anyway, that was the right track. I usedd Trim and it worked! I am
still wondering where these characters got introduced and what they are
(they are not spaces or tabs or even the vbNull character).

Thanx,
--
Anil Gupte
www.keeninc.net
www.icinema.com
www.wizo.tv
"Anil Gupte/iCinema.com" <an*******@icinema.comwrote in message
news:u1**************@TK2MSFTNGP03.phx.gbl...

>I am having huge problems with my dataset. The change I made was that I
was reading all the information from a plain text file (include column
names and data etc.). Now, I have encrypted the file, then I decrypt it
(it decrypts just fine). I then put the strings obtained in an array and
parse each line (earlier, I was using readline and then parsing each line).
Anyway, to cut a long story short, it appears to create the DataSet, but
nothing works - it won't even recognize the column names. Even in my watch
window, if I put in an expression, I get an error as shown below:

ds.Tables("Profiles").Select("ProfileID='0'") Run-time exception thrown :
System.Data.EvaluateException - Cannot find column [ProfileID].

So you would think I don't have a column by that name. Well in the same
Watch Window, I get the following:

ds.Tables("Profiles").Columns(0).ColumnName "ProfileID" String

Which means that column exists! What is going on? And how can I fix it?

Please help! My software is stuck on this and I am trying to meet a
deadline!

Thanx in advance,
--
Anil Gupte

[Armin Zingler]

"Anil Gupte/iCinema.com" <an*******@icinema.comschrieb

I meant to send this to the group:
I thought that I had checked that, but surprisingly I get

ds.Tables("Profiles").Columns(0).ColumnName = "ProfileID"

and

ds.Tables("Profiles").Columns(0).ColumnName.Length = 10

!!! It should be 9!

However, I cut and paste the first line into Notepad and Word, but
cannot see any extraneous characters. Any idea how to solve this
puzzle? How does one see a "null character"?

for each c in ds.Tables("Profiles").Columns(0).ColumnName
debug.print(ascw(c).tostring("X2"))
next

Output?
Armin