Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is ispostback property?

861


How response object is related to asp's response object?

850


Why would anyone need to implement their own hashtable or linked list?

2881


By default, Web API sends HTTP response with which of the following status code for all uncaught exception?

1539


What is page request in asp.net?

893


What will happen if the server confugration file and the application confugration file have different values for sassion state ASP.NET?

1171


What are validator? Name the validation controls in asp.net? How do you disable them?

975


8. Why do you want to work here?

1849


What is an asp.net web form?

1034


What is ipostback?

1014


What is the difference between session and viewstate?

903


What are the server controls in asp.net?

905


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.

1769


What is ViewState? What does the "EnableViewState" property do? Why would I want it on or off?

1077


How do I know asp.net mvc version? : Asp.Net MVC

970