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 |
How do you turn off cookies for one page in your site?
What is the best way to crack the certification?
Explain security measures exist for .net remoting in system.runtime.remoting?
What are Satellite Assemblies? How you will create this? How will you get the different language strings?
What is Garbage Collection in .Net and what is the Garbage collection process?
what are the controls used to upload a file from client to server?
What is the single responsibility principle?
Writing a Stored procedure to insert the values into a table
What are the drawbacks for Model-View-Controller Architecture?
What are the differences in C# .Net and ASP .Net.
Please explain what is heap and what is stack?
can we use private assembly in other project in dot net.