Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Write code for fetch record nos 15 to 25 from a dataset
containing 50 records?

Answers were Sorted based on User's Feedback



Write code for fetch record nos 15 to 25 from a dataset containing 50 records?..

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

Write code for fetch record nos 15 to 25 from a dataset containing 50 records?..

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

Write code for fetch record nos 15 to 25 from a dataset containing 50 records?..

Answer / pradeep kumar mishra

select * from DATABASE_NAME where nos>='" & 15 & "' and
nos<='" & 25 & "'

Is This Answer Correct ?    2 Yes 4 No

Write code for fetch record nos 15 to 25 from a dataset containing 50 records?..

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

Post New Answer

More Dot Net General Interview Questions

Please explain what is immutability, what is it for and how is it codified?

0 Answers  


Which property is used in the email to send the content as HTML

1 Answers  


Is .net an object oriented language? What are their components?

0 Answers  


Can I write il programs directly?

0 Answers  


What is PageIndex in DataGrid?What is the event used in the Datagrid for while moving from one page to another page in the Grid?write code for it

2 Answers  


What's the problem with .net generics?

0 Answers  


What does msil do?

0 Answers  


What's the .net collection class that allows an element to be accessed using a unique key?

0 Answers  


What does stateless mean?

0 Answers   BirlaSoft,


Difference between class and interface in .net?

0 Answers  


Explain is the jit an interpreter?

0 Answers  


what is the default value of CHAR type?in C# using asp.net?

7 Answers   Bosch,


Categories