Interested to Buy Any Domain ? << Click Here >> for more details...
What?s the role of the DataReader class in ADO.NET connections?
- 7 Answers
- 16111 Views
- Honeywell, Ksb, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ajay singh negi
DataReader object is a simply used to read data from the
result sets and because of this feature we call this object
as forward only or read only cursor. It requires a live
connection with the data source. Threw looping you can
efficiently access all or a part of data from the result
set. Note you cannot directly initialize a DataReader
object. Execute reader method of the command object is used
to obtain a valid DataReader object. After using DataReader
you need to close the connection otherwise it is stayed
alive and it is explicitly closed.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / guest
returns a read-only dataset from the data source when the
command is executed.
| Is This Answer Correct ? | 8 Yes | 3 No |
Answer / satyambabu
the data reader on the other hand is directly connected to
the database management syatem .it is passess the all
quries to database managemant system,which execute them and
returns the result back to the application.
datareader no maintain the buffer
it is used to small number of operations
| Is This Answer Correct ? | 5 Yes | 1 No |
DataReader has play vital role in ADO.NET when retrieve the
dataset.Its forward and read only optiion.They are not have
the pointer.It can only move the record with value
pointer.It is effiecnt data retrieval mechnism in ADO.Net.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / kamal
This is used to retrieve data from a data source in read-
only and forward-only mode
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / santosh
Data reader is belongs to connecting architectutre.It read
the the data in forward direction.It retrive data from
database through sqlcommand.It is faster as comapre to data
Adupter in disconnecting architecture.
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / ilayaraja
it is used to retrieve the records in forward only
manner.it is always connected with data source. also fast
retrieval of records when compared to other (dataset..).
| Is This Answer Correct ? | 3 Yes | 5 No |
Explain the difference between sqlcommand object and command behavior object?
What is the difference between connected environment and a disconnected environment?
How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
How can we serialize the dataset object?
Which keyword is used to accept variable number of parameters?
make a login control??
How To Update A Column In A DataGrid Using C#.NET? I am getting InvalidCastException as (Specified cast is not valid) while updating 2nd column in a datagrid? Id,firstname,lastname are the three columns of my datagrid respectively. I wanted to edit the second column(lastname) and update it. I did the following code in DataGrid's updatecommand(),but failed to update ! Int varid=(int)DataGrid1.DataKeys[e.Item.ItemIndex]; TextBox lnm=(TextBox)e.Item.Cells[2].Controls[0]; string str=lnm.Text ; SqlCommand cmd=new SqlCommand("update customer set lastname='" + str + "' where id=" + varid + "",con); cmd.ExecuteNonQuery(); DataGrid1.EditItemIndex=- 1; DataGrid1.DataBind();
What are the parameters that control most of connection pooling behaviors?
What is ado.net objects?
What is ado.net and its architecture?
What is ado.net connection?
How to creating a SqlCommand Object?
-
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)
