473,327 Members | 1,920 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

How to use a datareader instead of a dataset?

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

Nov 19 '05 #1
2 923
while(ldrReader.Read())
{
string lstrVal = ldrReader["ColName"].ToString();
}
ldrReader.Close();

--
Message posted via http://www.dotnetmonster.com
Nov 19 '05 #2
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

"Glen Wilkin via DotNetMonster.com" <fo***@DotNetMonster.com> wrote in
message news:fo***@DotNetMonster.com:
while(ldrReader.Read())
{
string lstrVal = ldrReader["ColName"].ToString();
}
ldrReader.Close();

--
Message posted via http://www.dotnetmonster.com


Nov 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Yasutaka Ito | last post by:
Hi, My friend had a little confusion about the working of DataReader after reading an article from MSDN. Following is a message from him... <!-- Message starts --> I was going thru DataReader...
5
by: Jason Huang | last post by:
Hi, Is it possible to bind DataReader to a DataGrid in C# windows form? And how? And can we update data in a DataSet by using the DataReader? Thanks for help. Jason
2
by: Patreek | last post by:
Hi, I'm writing my first real asp.net app at my job, and I'd like opinions please. In my classic ASP apps that I've written, I'd often have separate files for retreiving data and returning the...
6
by: Yasutaka Ito | last post by:
Hi, My friend had a little confusion about the working of DataReader after reading an article from MSDN. Following is a message from him... <!-- Message starts --> I was going thru DataReader...
11
by: ^MisterJingo^ | last post by:
Hi all, I have a form with 4 dropdownlist controls which I populate with data from DB tables. I have a class with a method which constructs a dataset, putting each DB table into a dataset table....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.