How to use a datareader instead of a dataset?

[Shapper]

Hello,

I have this ASP.NET / VB code which uses a dataset:
----
For Each row As DataRow In dsContent("index").Tables(0).Rows
Dim div As HtmlGenericControl =
CType(Page.FindControl(row("name").ToString), HtmlGenericControl)
If row("content").ToString <> "" Then
div.InnerHtml = row("content").ToString
Else
div.InnerHtml = "&nbsp;"
End If
Next
----

How can I change this code to use a DataReader names drContent instead
of dsContent?

I am having problems with the "For" loop and then with the "row".

Thank You,
Miguel

 

[Glen Wilkin via DotNetMonster.com]

while(ldrReader.Read())
{
string lstrVal = ldrReader["ColName"].ToString();
}
ldrReader.Close();

 

[Shapper]

Hi,

I am having some problems. Could you tell me how the following two lines
would become?

Dim div As HtmlGenericControl =
CType(Page.FindControl(drContent("name").ToString), HtmlGenericControl)

If drContent("content").ToString <> "" Then

Note - In my original code when I do:

....dsContent("index")...

I am accessing my DataGrid function and get the records which [page]
field value is equal to "index".

When I use

....row("name").ToString...

I am accessing the [name] field value of a certain record.

Anyway, the "While drContent.Read()" is working, as I changed it to
"While drContent("index").Read()" but the rest it's not.

Thanks,
Miguel