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...

What is the difference between ExecuteReader,ExecuteNonQuery
and ExecuteScalar.

Answer Posted / divya sharma

Execute Non Query- its for manipulation
(insert,delete,update),returns number of rows affected.

Execute Reader- accesses data in read only,forward only way
(perform commands such as select).

Execute scalar- returns only one value i.e. 1st row,1st
column, after execution of query.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between primary foreign and unique keys?

1125


What describes a query?

983


What kind of data can be stored in viewstate?

1027


what are configuration files?

1098


I have an external link in my application say www.xyztest.com. Today this site works on http protocal. Tommorow it may run on https. So i cant hardcore the protocal in the site. When a user clicks on the link how can i know if the external site works on http or https and takes him to that place?

1959


How are sessions stored?

1042


Where is asp.net session stored?

978


is there any third party tools are using in .net technologies? what are there ? give me the brief introduction?

2472


Can you edit data in the Repeater control? Which template must you provide, in order to display data in a Repeater control? How can you provide an alternating color scheme in a Repeater control? What property must you set, and what method must you call in your code, in order to bind the data from some data source to the Repeater control?

1090


if i want to give an alert message like "try after sometime" to a web page which is being seen by other person.if a web page is not seen by anyone then it should display otherwise it show a display a message stating that other person is viewing so try after some time........how can i implement this.

2279


What is active web page?

997


Explain the role of global.asax?

1044


Can we set which type of comparison we want to perform by the CompareValidator control?

1092


Explain the asp.net session state modes.

1112


What is the difference between Classic ASP and ASP.Net?

1165