Answer Posted / manish t
the command in the above code uses cmd.executereader ()
which means an datareader object is returned as a result of
the execution .....which essentially means one datar reader
object getting assigned to another datareader object
dr = cmd.executereader
so it is simply assigning of objects and does not require
new keyword as the datareader inside the execute reader has
already allocated space and it is just assigning it to a
different object ...this is true with executedataset as
well ...remember the rule is that corret type should be
returned. it is same in case of any objects ..try creating
an object A with new keyword and another object B of same
type without new key word ...and then assign the A to B and
you will find that By ref all properties are avialable to b
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How to aggregating data across related tables?
Define table relations?
Which object needs to be closed?
What are the steps you will take to improve performance? Will you use dataset or datareader?
Explain ODP.net
What does executequery return?
How to enable and disable connection pooling?
Is it possible to load multiple tables in a Dataset?
What are the different methods by which we can populate a dataset?
What is difference between datatable and dataset?
Define data access layer?
What is oledb driver?
What is ole2 format?
What is microsoft ado?
How we can provide data to ado.net?