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 |
Value type & data types difference. Example from .NET.
How to Create and Consume a Web Service?
Write the .net syntax for 'for loop'?
What is close method? How its different from finalize and dispose?
Is there any attempt system for microsoft technology papers?
If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
What is your observations between vb.net and vc#.net?
Garbage collector thread is what kind of a thread?
Which namespace is require to used XML in .NET?
0 Answers Sans Pareil IT Services,
Should I use readerwriterlock instead of monitor.enter/exit?
What is .NET Framework?
Explain me what is encapsulation?