value in dataset: not resolved???

Hi, I'm here again

I found a code snippet to retrieve the value of the first row and the column 'RightsID' of the tblUsers in a dataset (DSUsers)

The Column RightsID is an integer in the underlying access database.

The strange thing is that I can show the requested value in a messagebox by the following code:

MsgBox(DSUsers.Tables("tblUsers").Rows(0)("RightsID"), MsgBoxStyle.Critical, "Bedrijf gevonden")

The shown value is '2' and this is correct.

But when I want to assign the value to a defined integer variable, the value is '0', which is not correct because it should be '2'
I used the following code:

dim UserRights as Integer
UserRights = DSUsers.Tables("tblUsers").Rows(0)("RightsID")

Is there anybody who can help me???

Thanx,

Tom

a stab in the dark i know but what type is RightsID in the database? Is it an integer or a string?

RightsID is an integer in the underlying database.

Tom

zip up the application and the database and i'll have a look for you.

thanks nswan,

I found another way to get to the same result, but I still am interested to know why I can't assign that value to the variable.

The problem is in Form1 and in the Sub 'Checkuser'. It are the last two lines which I commented.

The sourcecode is added and the database is added in the next post (I only added the userdatabase because the other database is not necessary for this specific problem).


Kind regards,

Tom

database

i'll have to check later when i get home as i don't have VS 2003 here only 2002.

no problem,

thanks in advance,

Tom