Write code for fetch record nos 15 to 25 from a dataset
containing 50 records?
Answers were Sorted based on User's Feedback
Answer / monika
insert a new column "Rowid int identity" and then you can
access the data with the query like
select * from tablename where rowid >=15 and rowid<=25
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / kinjal
one extra int field add in database and set identity.
if that datafield name is id then write the query
select * from database_table where id>=15 and id<=25.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pradeep kumar mishra
select * from DATABASE_NAME where nos>='" & 15 & "' and
nos<='" & 25 & "'
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / nithyananthababu
We can use the ROW_NUMBER Proberty from sql 2005
We can easily get the data's via roll numbers
| Is This Answer Correct ? | 0 Yes | 4 No |
what is prototype design pattern in .net
What is prerender event of a page?
What are the challenging issues you have faced in implementation project/Maintainance project in .net Functionality? How you have overcome that issue?
Different levels of priority provided by .net.
Is there built-in support for tracing?
Explain me difference between public and static modifiers?
What is CLR, CLS,CTS
4 Answers Deloitte, Vee Technologies,
How will you register com+ services?
What's the .net collection class that allows an element to be accessed using a unique key?
Difference abstract class and interface in .net?
What does msil do?
Explain weg config settings for exception managment in asp.net?