Accessing a Data Field

12 Apr 2005 4:36 AM

glennTK

Hello Group,

I'm trying to access a single field of data from a dataset in a web form
without displaying it on the form. I'm trying to write a Login form and
need to equate values. Would anyone be able to provide a code snippet for
such.

I would have thought there'd be something like the following possible to do:

FieldValue = DsUsers.Row(x).Column(y)

But have not been able to determine such. Thank you,
Glenn T. Kitchen

12 Apr 2005 5:56 AM

Cor Ligthert

Glenn,

The standard beginners question with datasets.

>
> FieldValue = DsUsers.Row(x).Column(y)
>

FieldValue = DsUsers.Table(x).Row(x).Items(y)

Items is default so this goes as well
DsUsers.Table(x).Rows(x)(y)

I hope this helps,

Cor

12 Apr 2005 9:52 AM

Glenn T. Kitchen

Hi Cor,

Thank you.

So could we look at a dataset as being a database, having tables within,
except that it's cached?

I'm gonna do some practicing with the stuff to see how it works out. Thanks
for your help.
Glenn

Show quoteHide quote

"Cor Ligthert" <notmyfirstn***@planet.nl> wrote in message
news:#eRk3RyPFHA.3988@tk2msftngp13.phx.gbl...
> Glenn,
>
> The standard beginners question with datasets.
> >
> > FieldValue = DsUsers.Row(x).Column(y)
> >
> FieldValue = DsUsers.Table(x).Row(x).Items(y)
>
> Items is default so this goes as well
> DsUsers.Table(x).Rows(x)(y)
>
> I hope this helps,
>
> Cor
>
>

12 Apr 2005 10:11 AM

Cor Ligthert

Glenn,

> So could we look at a dataset as being a database, having tables within,
> except that it's cached?

Often is toldt, that you can look to it as a database in memory. Although it
is possible to store it in an XML file on disk, can you not see it as a real
database because that you can only read/write complete files from/to disk.

Therefore I am not really glad with that description database because it
gives wrong idea's.

Cor

12 Apr 2005 10:53 AM

Glenn T. Kitchen

Cor,

I see your point and I now have a better perception of what a dataset is. I
did some work with the "new concept of a field" and everything is working
fine.

I wasn't far off... :-)

Thank you,
glenn

Show quoteHide quote

"Cor Ligthert" <notmyfirstn***@planet.nl> wrote in message
news:O2pvRg0PFHA.2652@TK2MSFTNGP10.phx.gbl...
> Glenn,
>
> > So could we look at a dataset as being a database, having tables within,
> > except that it's cached?
>
> Often is toldt, that you can look to it as a database in memory. Although
it
> is possible to store it in an XML file on disk, can you not see it as a
real
> database because that you can only read/write complete files from/to disk.
>
> Therefore I am not really glad with that description database because it
> gives wrong idea's.
>
>
> Cor
>
>