ado out of memory or inner join with different dataadapter

Question

4.00/5 (1 vote)

See more:

I have a question, I have a master detail table and have a blob field in the detail, due to large ammount of data I get an error "out of memory".
My question is this :
a) I know there is an SQL syntax that selects top 10 records, like T-SQL limit, and when view the 10 top mivw to next 10.
b) How to create the join with 2 adapters and datasets and the detail's table select has a query with a parameter that points to thhe primary key if the master.
I provide the code.

select * from scan where id_2 (FK) = @id_

Posted 3-Mar-11 7:14am

Member 3892343

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Henry Minute · Answer 1 · 2011-03-03T07:30:00

Solution 1

Many of the data aware controls in .NET have a VirtualMode property that enables this sort of behaviour.

You haven't stated which controls your application is using so I do not know if this will be of any use to you. In case it might be here[^] is a link to the relevant page on MSDN for the DataGridView.

Posted 3-Mar-11 7:30am

Henry Minute

Comments

Tarun.K.S 15-Apr-11 3:03am

From OP :
I found the sql string uses two select and top sql functions, find virtual mode but in a grid component, the detail has a blob field which I enetered in a picture box.

ado out of memory or inner join with different dataadapter

1 solution

Solution 1

Add your solution here

Preview 0

ado out of memory or inner join with different dataadapter

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us