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 DTS and explain the purpose of it?
Explain soap and xml?
How can you turn-on and turn-off cas?
Name for built-in permission sets in .Net
What is the advantage of .net?
How different are interface and abstract class in .Net?
for the textbox if i want to allow only numbers.what ever the characters u enter it should not take.which event u used?
What is UDDI and how to register the web service in it?
Can u explain me What is encapsulation?
7 Answers Deloitte, GK companies,
Readonly vs. const?
What are three common acronyms used in .net, and what do they stand for?
I want to serialize instances of my class. Should I use xmlserializer, soapformatter or binaryformatter?