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 |
What are the different types of Lock available in Visual Basic?
Name some of the keywords used in vb.net?
Name a feature which is common to all .net languages?
What is the Difference between Web User Control and Web Custom Control?
What is the difference between c# and vb.net?
What is normal jit?
hey friends, Firstly I pick the records from the database into the DataGridView, Then I want that If I made any changes to the records in the GridView & Click on Update Button, Changes are Reflected into the main Database .Plz do reply back
What is the strong name in .net assembly?
What is code access security?
how to restore database using vb.net?
4 Answers Eclat, PCS, Pepon, Restor, TCS,
What is branching logic control in VB.NET?
Sir, what code to store data from vb net sql server 2008 to 2005 and at the same time in order to validate the data entered is not the same, but there have been contacts in the module. Examples such as the log table that I created, the user name as the primary key.