Please help: How to Traverse a Dataset using VB.NET

Hi, all.

I could not find reference on how to traverse a Dataset in VB.NET like I
used to do with the recordsets in classic ASP.

Can anybody give me a hand (or a code sample) for that?

In other words, I want to perform this in VB.NET:

Classic ASP (recordset):
while not RS.EOF
response.write (RS("category_name"))
RS.MoveNext
wend
RS.Close

VB.NET (dataset):
????

Thanks in advance for any tip.

All the best,
Pedro.

[Non-text portions of this message have been removed]

Messages in this topic (1) Reply (via web post) | Start a new topic

.

Hi Pedro,

I strongly suggest downloading Reflector if you don't have it (
http://www.aisto.com/roeder/dotnet ). This will allow you to browse all
classes and attributes of the .NET framework at will, and even look at
disassembled code.

In short, a DataSet contains a collection of DataTable objects, which you
can traverse to find the correct table. Once there, you can roam among the
selected DataTable's Rows collection, each member of which has a Columns
collection, etc.

Really, though, if you just want to display a column from the default
view of a DataSet, why not just bind it to a DataGrid/GridView or a
Repeater?

Peter

On 9/27/07, Pedro Carneiro < pedro.carneiro%40agehab.go.gov.br">pedro.carneiroagehab.go.gov.br&gt; wrote:
&gt;
> Hi, all.
>;
> I could not find reference on how to traverse a Dataset in VB.NET like I
> used to do with the recordsets in classic ASP.
>;
> Can anybody give me a hand (or a code sample) for that?
&gt;
> In other words, I want to perform this in VB.NET:
>
> Classic ASP (recordset):
> while not RS.EOF
&gt; response.write (RS("category_name"))
> RS.MoveNext
> wend
>; RS.Close
>
>; VB.NET (dataset):
> ????
>;
> Thanks in advance for any tip.
>;
> All the best,
&gt; Pedro.
&gt;

[Non-text portions of this message have been removed]

Messages in this topic (0) Reply (via web post) | Start a new topic

•  20
  New Members

Visit Your Group