Referencing Typed DataSet DataRows in .NET 2.0

4 Feb 2007 5:18 PM

gauty

In .NET 1.x, you referenced a strongly typed row in a typed dataset by
such VB code as:

    drForum = dsForum.Forum(0)        'Get row 0 in the typed dataset
ds

or

    drForum = dsForum.Forum.Rows(0)

and then you could reference the columns in the row by code such as

    drForum.AuthorName

Things seem to have changed in .NET 2.0 (which I'm fairly new to) and
I can't for the life of me figure out how to do the same thing! I know
the answer will be pathetically easy, but having serached around all
over the place, all I can find is references to filling typed datasets
by using adapters, which all seems over complicated for what I want to
do.

Any help greatly appreciated!

4 Feb 2007 11:54 PM

Cor Ligthert [MVP]

Gauty,

I had that idea for a moment as well, but it is not, what can is that you
can use now tableadapters, which are in fact a kind of strongly typed
dataadapters, which residence as well in a dataset.

Cor

Show quote

"gauty" <ga***@bigfoot.com> schreef in bericht
news:1170609483.260384.220750@j27g2000cwj.googlegroups.com...
> In .NET 1.x, you referenced a strongly typed row in a typed dataset by
> such VB code as:
>
>    drForum = dsForum.Forum(0)        'Get row 0 in the typed dataset
> ds
>
> or
>
>    drForum = dsForum.Forum.Rows(0)
>
> and then you could reference the columns in the row by code such as
>
>    drForum.AuthorName
>
> Things seem to have changed in .NET 2.0 (which I'm fairly new to) and
> I can't for the life of me figure out how to do the same thing! I know
> the answer will be pathetically easy, but having serached around all
> over the place, all I can find is references to filling typed datasets
> by using adapters, which all seems over complicated for what I want to
> do.
>
> Any help greatly appreciated!
>

5 Feb 2007 3:09 AM

RobinS

In VS2005, you set up a Strongly Typed Dataset using the DataSet Designer.
It generates the code-behind that you're using for dsForum, etc., that you
can use. It also creates a table adapter that you can use for doing
updates.

Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
-----------------------------------------------
Show quote

"gauty" <ga***@bigfoot.com> wrote in message
news:1170609483.260384.220750@j27g2000cwj.googlegroups.com...
> In .NET 1.x, you referenced a strongly typed row in a typed dataset by
> such VB code as:
>
>    drForum = dsForum.Forum(0)        'Get row 0 in the typed dataset
> ds
>
> or
>
>    drForum = dsForum.Forum.Rows(0)
>
> and then you could reference the columns in the row by code such as
>
>    drForum.AuthorName
>
> Things seem to have changed in .NET 2.0 (which I'm fairly new to) and
> I can't for the life of me figure out how to do the same thing! I know
> the answer will be pathetically easy, but having serached around all
> over the place, all I can find is references to filling typed datasets
> by using adapters, which all seems over complicated for what I want to
> do.
>
> Any help greatly appreciated!
>