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 |
Explain asp.net?
Is .net a programming language?
Difference between dispose and finallize method?
Can I write il programs directly?
What is the procedure to add assemly to gac to make it shared one?
Name the classes that are introduced in the system.numerics namespace.
What's the use of system.diagnostics.process class in .net?
I want to serialize instances of my class. Should I use xmlserializer, soapformatter or binaryformatter?
Explain about .Net products?
Explain what is the difference between web application and enterprise application?
What does jit compilation do in .net?
String[] a = new string[10] for(i=0; i<10; i++) { a[i] = i; } How many heap object will be created for this array. Choose the answer below. Ans: 1, 10, 11, 12