Why Datareader is useful?
Answers were Sorted based on User's Feedback
Answer / kamalakannan.a
Datareader is read only or forward only.So it is very fast
to fetch the data from database.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / manikandan
Data reader is usefull when we just want to acccess datas
from the database not when we want to perform DML
operations. and It is usefull when we want to perform
forward only reading of datas.It wont requires any
large volume of resources in the Front end.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / payal
1)it is used for forward record only.
2)we cannot update or save
3)speed is fast than dataset
4)not persist any record
5)it is usefual in case of display data according to
critiera on form using control like textbox,label etc.
who to use
in vb.net
dim sqlcmd as new sqlcmd("select ename from tblemp where
empid=5;
dim dr as new dataReader
dr=sqlcmd.executeReader()
if dr.hasRows then
txtbox1.text(dr("ename"))
end if
this display ename in textbox.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / anitha
Datareader is used to fetch the data frm data source
| Is This Answer Correct ? | 2 Yes | 0 No |
Define naming convention?
What are the objects in asp.net and tell the purpose of those objects
What is strong name in .net assembly?
Explain an assembly?
Write a program that accepts an array of numbers, and two numbers (an element and a position in the array) and inserts the given element into nth position of the array.
What is the main purpose of garbage collector?
What is the purpose of an Assembly?
What’s the difference between private and shared assembly?
Define manifest?
When do you use virutal keyword?
What is the difference between Namespace and Assembly?
What is MSIL.
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)