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
What are the differences between primary foreign and unique keys?
What describes a query?
What kind of data can be stored in viewstate?
what are configuration files?
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?
How are sessions stored?
Where is asp.net session stored?
is there any third party tools are using in .net technologies? what are there ? give me the brief introduction?
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?
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.
What is active web page?
Explain the role of global.asax?
Can we set which type of comparison we want to perform by the CompareValidator control?
Explain the asp.net session state modes.
What is the difference between Classic ASP and ASP.Net?