freelanceprogrammers.org Forum Index » ASP

View previous topic :: View next topic

exception out of memory

rajsekharmca@... Posted: Sat Sep 10, 2005 5:31 pm

Joined: 10 Sep 2005

Posts: 1

exception out of memory

Hi,

I`m Rajsekhar, I`m working on asp.net,vb.net and sql server 2000.

I have one problem:

I have one screen in that all Vendors are displayed and each vendor
having multiple customers. If I click the hyperlink of particlular
vendor relavent customer list is open.

The problem is for a particular vendor I have nearly 1 lakh
customers. I have to show all the customers in a Grid. Is it possible
to display all the records into a sigle grid?

regards
Rajsekhar

charlesmarkc... Posted: Sat Sep 10, 2005 9:19 pm

Joined: 07 Jan 2006

Posts: 63

exception out of memory

Yes if you use ExecuteReader rather than DataSets/DataTables.

http://www.learnasp.com/freebook/learn/dbopensqlserver.aspx
shows how to use a Reader to display a grid, code like this is recommended.

On 9/10/05, RAJASEKHAR <rajsekharmca@...> wrote:
>
> Hi,
>
> I`m Rajsekhar, I`m working on asp.net
<http://asp.net>,vb.net<http://vb.net>and sql server 2000.
>
> I have one problem:
>
> I have one screen in that all Vendors are displayed and each vendor
> having multiple customers. If I click the hyperlink of particlular
> vendor relavent customer list is open.
>
> The problem is for a particular vendor I have nearly 1 lakh
> customers. I have to show all the customers in a Grid. Is it possible
> to display all the records into a sigle grid?
>

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

freelanceprogrammers.org Forum Index » ASP

All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help