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

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 is cyclomatic complexity and why is it important?

0 Answers  


What is an anonymous method and how is it different from a lambda expression?

0 Answers  


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

1 Answers  


Explain the top .net class that everything is derived from?

0 Answers  






Is .net core installed?

0 Answers  


If you are executing these statements in commandobject. Select * from table1; select * from table2? How you will deal result set? 42. How do you sort a dataset.

0 Answers  


What is the difference between .net 2000 and .net 2005(features)? Which one is better?

0 Answers  


Describe the Managed Execution Process

0 Answers  


How do you start, pause, continue or stop a Windows service off the command line?

1 Answers  


How many types of exception handlers are there in .NET?

2 Answers  


What is use of ContextUtil class?

1 Answers  


Categories