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 PageIndex in DataGrid?What is the event used in the Datagrid for while moving from one page to another page in the Grid?write code for it
What is cyclomatic complexity and why is it important?
What is an anonymous method and how is it different from a lambda expression?
Which property is used in the email to send the content as HTML
Explain the top .net class that everything is derived from?
Is .net core installed?
If you are executing these statements in commandobject. Select * from table1; select * from table2? How you will deal result set? 42. How do you sort a dataset.
What is the difference between .net 2000 and .net 2005(features)? Which one is better?
Describe the Managed Execution Process
How do you start, pause, continue or stop a Windows service off the command line?
How many types of exception handlers are there in .NET?
What is use of ContextUtil class?