Write code for fetch record nos 15 to 25 from a dataset containing 50 reco

Advertise your Business Here

Refer this Site

Login | Sign Up


	To Refer this Site to Your Friends Click Here

Categories >> Software >> Microsoft Related >> Dot Net >> Dot Net General

Dot Net Framework Interview Questions

Dot Net Remoting Interview Questions

Dot Net WindowsForms Interview Questions

Dot Net General Interview Questions

Dot Net AllOther Interview Questions

Question

Write code for fetch record nos 15 to 25 from a dataset
containing 50 records?

Question Submitted By :: Balajitu

I also faced this Question!!

Rank

Answer Posted By

Re: Write code for fetch record nos 15 to 25 from a dataset containing 50 records?

Answer
# 1

select * from DATABASE_NAME where nos>='" & 15 & "' and 
nos<='" & 25 & "'

Is This Answer Correct ?

1 Yes

3 No

Pradeep Kumar Mishra

Re: Write code for fetch record nos 15 to 25 from a dataset containing 50 records?

Answer
# 2

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

3 No

Nithyananthababu

Re: Write code for fetch record nos 15 to 25 from a dataset containing 50 records?

Answer
# 3

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 ?

4 Yes

0 No

Monika

Re: Write code for fetch record nos 15 to 25 from a dataset containing 50 records?

Answer
# 4

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 ?

0 Yes

0 No

Kinjal

Question	Asked @	Answers
Other Dot Net General Interview Questions


How different are interface and abstract class in .Net?		2
differance between checkbox and rediobutton in vb.net?		1
what is event inheritance and event delegation?		1
What is Global Assembly Cache (GAC) and what is the Purpose of it?		1
What base class do all Web Forms inherit from?		1
What is the Difference between imperative and interrogative code?		1
What is the Difference between directcast and ctype?	Wipro	3
How can you automatically generate interface for the remotable object in .NET with Microsoft tools?		1
What is the difference between the C#.NET and VB.NET?		4
How to write an MMC snap-in for my Windows service?		1
DateTime[] dt = new DateTime[10] for(i=0; i<10; i++) { dt[i] = DateTime(2008, 1, i+1) } How many heap object will be created for the above array. Choose the correct answer below. Ans: 1, 10, 11, 12		3
Difference between Debugging and tracing in .net		1
what is managed data and managed code?		2
what is the use of "mustinherit" keyword?		2
Types of JIT and what is econo-JIT ?	TCS	2
Which Security Algorithm used to encrypt the data? a) DES b)RC2 c)Triple DES d)All the above	Value-Labs	1
What are the contents of assembly?		3
What is MSIL, IL, CTS?		2
What is CCW (COM Callable Wrapper)		1
What?s typical about a Windows process in regards to memory allocation?		1

For more Dot Net General Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com