Click here to Skip to main content
16,018,529 members
Home / Discussions / C#
   

C#

 
QuestionTo convert xml file to pdf file Pin
praveen pandey25-Nov-06 2:50
praveen pandey25-Nov-06 2:50 
QuestionDatabase connectivity problem Pin
ranandbe25-Nov-06 0:46
ranandbe25-Nov-06 0:46 
QuestionDraw Pin
MHASSANF25-Nov-06 0:40
MHASSANF25-Nov-06 0:40 
AnswerRe: Draw Pin
CPallini25-Nov-06 1:16
mveCPallini25-Nov-06 1:16 
Questionhow to insert my DatagridView1.Columns to another DatagridView? Pin
hdv21224-Nov-06 23:24
hdv21224-Nov-06 23:24 
AnswerRe: how to insert my DatagridView1.Columns to another DatagridView? Pin
Stathread25-Nov-06 7:19
Stathread25-Nov-06 7:19 
Questionany C# GUI samples/tutorials for .Net Compact Framework on WinCE Pin
George_George24-Nov-06 22:54
George_George24-Nov-06 22:54 
QuestionLimiting the retrived results using ODBC on MS access [modified] Pin
cbh_24-Nov-06 22:01
cbh_24-Nov-06 22:01 
Hi Wink | ;)

im trying to Limit the number of results retrived by a Query so for Example i want to retrive the first 30 and then navigate throw the results 30 by 30.

the problem in my Query that i cant used the TOP 30 command because im Ordering my results with date then status plus alot of ordering.

and this ordering will cause the retrived results to be retrived in a random ID_no order as one of my friends suggested that i use the TOP 30 along with
Where Id no > X Order BY Id_no as in the example below.

but i think if there is no Command in MS Access or that i dont know it because of my lack of knowledge i will have to order by my Where Criteria along with the TOP 30 command.

Another Sol. just popped to my head is to save the results to a Dataset and then using a Table in the Dataset i can just retrived Index based.

i guess i will try the Dataset sollution also if there is any better one plz Help.

By the way im using ODBC COnnection, OdbcCommand and ODBCDatareader.


Thanks in Advance.

Example for Retriving by the TOP and Where command:
1)
Select TOP 30 A.ID_no , .......etc<br />
From A , ......etc<br />
Where A.ID_no > 1<br />
Order by ID_no ;


2)
Select TOP 30 A.ID_no , .......etc<br />
From A , ......etc<br />
Where A.ID_no > 30<br />
Order by ID_no ;


and i continue like that.


Have fun and Stay good Wink | ;)


-- modified at 4:16 Saturday 25th November, 2006
AnswerRe: Limiting the retrived results using ODBC on MS access Pin
Eduard Keilholz26-Nov-06 20:36
Eduard Keilholz26-Nov-06 20:36 
QuestionPacking and unpacking bits Pin
ScruffyDuck24-Nov-06 21:31
ScruffyDuck24-Nov-06 21:31 
AnswerRe: Packing and unpacking bits Pin
Guffa24-Nov-06 23:16
Guffa24-Nov-06 23:16 
GeneralRe: Packing and unpacking bits Pin
ScruffyDuck24-Nov-06 23:33
ScruffyDuck24-Nov-06 23:33 
GeneralRe: Packing and unpacking bits Pin
CPallini25-Nov-06 0:07
mveCPallini25-Nov-06 0:07 
AnswerRe: Packing and unpacking bits Pin
Guffa25-Nov-06 0:34
Guffa25-Nov-06 0:34 
GeneralRe: Packing and unpacking bits Pin
ScruffyDuck25-Nov-06 1:08
ScruffyDuck25-Nov-06 1:08 
GeneralRe: Packing and unpacking bits Pin
Luc Pattyn25-Nov-06 3:10
sitebuilderLuc Pattyn25-Nov-06 3:10 
GeneralRe: Packing and unpacking bits Pin
Guffa25-Nov-06 4:14
Guffa25-Nov-06 4:14 
GeneralRe: Packing and unpacking bits Pin
ScruffyDuck25-Nov-06 6:19
ScruffyDuck25-Nov-06 6:19 
QuestionHow to Add ToolStripButtons on a Child Form Dynamically... Pin
IamHuM24-Nov-06 21:21
IamHuM24-Nov-06 21:21 
QuestionUPDATING .MDB (please help me guyz!) Pin
Muammar©24-Nov-06 20:52
Muammar©24-Nov-06 20:52 
Questionconvert Java source codes to C# source codes? Pin
George_George24-Nov-06 20:26
George_George24-Nov-06 20:26 
AnswerRe: convert Java source codes to C# source codes? Pin
CWIZO25-Nov-06 4:06
CWIZO25-Nov-06 4:06 
GeneralRe: convert Java source codes to C# source codes? Pin
George_George25-Nov-06 21:28
George_George25-Nov-06 21:28 
QuestionCall one function from another Pin
Andrei Ungureanu24-Nov-06 13:15
Andrei Ungureanu24-Nov-06 13:15 
AnswerRe: Call one function from another Pin
Amar Chaudhary24-Nov-06 13:21
Amar Chaudhary24-Nov-06 13:21 

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.