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 |
thak you Mr Govind for replying to my question. My next question is that how to retrieve image stored in an SQL server table and assign it to any image control or picture control using VB.net
What is the importance of a Button control?
Write a program for calculator in VB.NET
6 Answers CMC, College School Exams Tests, IBM, NIIT, Practical Viva Questions, Subex,
How many classes a dll can contain?
Write a program that accepts an array of numbers and a number, and return a string “Yes” if the number is found in the array, “No” if the number is not found in the array.
What is redim keyword?
Can you please explain the difference between dispose and finalize()?
Is vb.net a programming language?
when do we need a multiple document interface?
Name a feature which is common to all .net languages?
wht is the use of console application?
What is the feature anonymous type?
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)