Click here to Skip to main content
15,905,073 members
Home / Discussions / C#
   

C#

 
QuestionWhere's my (computer's) memory gone? Pin
Rob Philpott18-Sep-08 5:32
Rob Philpott18-Sep-08 5:32 
AnswerRe: Where's my (computer's) memory gone? Pin
Mark Salsbery18-Sep-08 6:41
Mark Salsbery18-Sep-08 6:41 
AnswerRe: Where's my (computer's) memory gone? Pin
Alan N18-Sep-08 6:52
Alan N18-Sep-08 6:52 
GeneralRe: Where's my (computer's) memory gone? Pin
Rob Philpott18-Sep-08 6:58
Rob Philpott18-Sep-08 6:58 
Questioninsight on data recording to msaccess Pin
djjedi18-Sep-08 5:16
djjedi18-Sep-08 5:16 
QuestionHow to Compare the two database tables(table1,Table2) and update the difference into (table2) using c# Pin
bruze18-Sep-08 5:08
bruze18-Sep-08 5:08 
QuestionSetting selected controls programatically. Pin
djjedi18-Sep-08 5:08
djjedi18-Sep-08 5:08 
AnswerRe: Setting selected controls programatically. Pin
Alan N18-Sep-08 7:23
Alan N18-Sep-08 7:23 
Question64-bit Programming Pin
HosamAly18-Sep-08 5:00
HosamAly18-Sep-08 5:00 
AnswerRe: 64-bit Programming Pin
Giorgi Dalakishvili18-Sep-08 5:04
mentorGiorgi Dalakishvili18-Sep-08 5:04 
Questionhow can i increse the size of the picture box with picture? Pin
maifs18-Sep-08 4:18
maifs18-Sep-08 4:18 
AnswerRe: how can i increse the size of the picture box with picture? Pin
Mbah Dhaim18-Sep-08 4:27
Mbah Dhaim18-Sep-08 4:27 
AnswerRe: how can i increse the size of the picture box with picture? Pin
nelsonpaixao18-Sep-08 13:58
nelsonpaixao18-Sep-08 13:58 
Questionhow can i increase the font size which is written in text box.. Pin
maifs18-Sep-08 4:11
maifs18-Sep-08 4:11 
AnswerRe: how can i increase the font size which is written in text box.. Pin
GuruPrasadh18-Sep-08 10:26
GuruPrasadh18-Sep-08 10:26 
Questionc# caching of sql query Pin
swjam18-Sep-08 3:53
swjam18-Sep-08 3:53 
AnswerRe: c# caching of sql query Pin
Simon P Stevens18-Sep-08 4:05
Simon P Stevens18-Sep-08 4:05 
GeneralRe: c# caching of sql query [modified] Pin
Mbah Dhaim18-Sep-08 4:17
Mbah Dhaim18-Sep-08 4:17 
GeneralRe: c# caching of sql query Pin
swjam18-Sep-08 4:32
swjam18-Sep-08 4:32 
GeneralRe: c# caching of sql query Pin
Simon P Stevens18-Sep-08 5:14
Simon P Stevens18-Sep-08 5:14 
swjam wrote:
above code does not guarantee that rows resulting from the first batch will not be in the second batch


Yes, that's why you have to combine it with the ROW_NUMBER() function to get a specific range of rows. The first link covers how to do this.

Or, like Mbah Dhaim suggested, you can use a sub SQL query to keep the already covered pages out of the results.

Obviously, if you are doing any of this, you need to be aware that new data may be being entered into the database, or existing data might be updated or removed between you accessing the pages.

It definitely works, whether it's efficient or not, I don't know. I'd make sure you run some tests, and read up on what would be the best indexes to use.

You might get more expert answers in the SQL server forum now you know what it is to ask about.

Good luck

Simon

QuestionPrinting a datagridview Pin
harcaype18-Sep-08 3:48
harcaype18-Sep-08 3:48 
AnswerRe: Printing a datagridview Pin
Giorgi Dalakishvili18-Sep-08 3:56
mentorGiorgi Dalakishvili18-Sep-08 3:56 
QuestionSearching DataTable Pin
Muammar©18-Sep-08 3:42
Muammar©18-Sep-08 3:42 
AnswerRe: Searching DataTable Pin
Giorgi Dalakishvili18-Sep-08 3:54
mentorGiorgi Dalakishvili18-Sep-08 3:54 
GeneralRe: Searching DataTable Pin
Muammar©18-Sep-08 4:52
Muammar©18-Sep-08 4:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.