If you are using two select queries and retrieving data. how
do you access second query's result set using data reader?
Answer Posted / uday kumar vuriti
If we have 2 select queries as follws
select * from dept
select * from emp
SqlDataReader dr;
//To Read 1st Select query dept
dr.Read();
//To Read 2nd Select query emp
dr.NextResult();
So the answer is dr.NextResult();
| Is This Answer Correct ? | 27 Yes | 0 No |
Post New Answer View All Answers
What is ispostback property?
How response object is related to asp's response object?
Why would anyone need to implement their own hashtable or linked list?
By default, Web API sends HTTP response with which of the following status code for all uncaught exception?
What is page request in asp.net?
What will happen if the server confugration file and the application confugration file have different values for sassion state ASP.NET?
What are validator? Name the validation controls in asp.net? How do you disable them?
8. Why do you want to work here?
What is an asp.net web form?
What is ipostback?
What is the difference between session and viewstate?
What are the server controls in asp.net?
a web application needs to be created to accept the product name and quantity of a toy from a customer. After the customer has entered the product name the application needs to display the discounted price of the product to the customer (company is offering 35% discount on all products). The application should allow the customer to select the product name from a list box. and also while i'm data binding to a label with custom data binding with some declarations : "The Discounted Price is "+((System.Convert.todouble(lblprodprice.text)*(system.convert.todouble(txtqty.text)) - ((System.convert.todouble(lblprodprice.text)*(system.convert.todouble(txtqty.text)*0.35)). Where i need to give this declaration in asp.net 2.0.
What is ViewState? What does the "EnableViewState" property do? Why would I want it on or off?
How do I know asp.net mvc version? : Asp.Net MVC