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 |
Why do we use msmq?
Should I use readerwriterlock instead of monitor.enter/exit?
Writing a Stored procedure to insert the values into a table
How viewstate is being formed and how it is stored on client in .net?
Explain how to redirect tracing to a file?
What is the use com component in .net?
Why MVC programming model preferred?
What is the best way to crack the certification?
With these events, why wouldn't microsoft combine invalidate and paint, so that you wouldn't have to tell it to repaint, and then to force it to repaint?
How is .net able to support multiple languages?
Explain what are the deferred execution and the immediate execution in linq?
What's a windows process in .net?