Why Datareader is useful?

Categories >> Software >> Microsoft Related >> VB.NET
Suggest New Category

Question Posted / guest

5 Answers
9426 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Why Datareader is useful? ..

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

Why Datareader is useful? ..

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

Why Datareader is useful? ..

Answer / bhushanam

its connection oriented architecture.

Is This Answer Correct ?

3 Yes

0 No

Why Datareader is useful? ..

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.