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 |
If we write any code for DataGrid methods, what is the access specifier used for that methods in the code behind file and why?
Where?s Windows service database located?
Differences between namespace, class, assembly?
ctype(123.34,integer) - should it throw an error? Why or why not?
How would ASP and ASP.NET apps run at the same time on the same server?
How to prepare parametrized (with more than one parameters) crystal report.pls tell me the code procedure, if any body can?
Is do-it (chennai) a good institute to learn dot-net???? are the trainers well experienced??
What is a Manifest?
Which namespace does it belong to by default?
what user controls are and what server controls are and the differences between the two.
What is a metadata in .net?
What are the advantages of .net?