Click here to Skip to main content
15,794,593 members
Please Sign up or sign in to vote.
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_

1 solution

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.
Share this answer
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.

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900