Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harissarwar
Starting Member
15 Posts |
 Posted - 2008-06-30 : 04:43:12
|
| While using SqlCommand we have three options for exicuting a query.1. ExecuteScalar (For Aggregate Function)2. ExecuteNonQuery (For Insert, Del, etc operations)3. ExecuteScalar (For retriving results of select query)I want to know when we run a certain query where the results arestored temporarily.How DataReader gets data from the Sql Server after running ExecuteScalar Command?Lets say i have run a StoredProcedure through SqlCommand named as "SelectList" with ExecuteScalar. If i use two queries in "SelectList" Will the result of both the queries will be accessible through DataReader or the result of last query will be available?If i want to access multiple table results in application in a singleprocedure how can i do that? |
|
|
|
|
|
Inner Detail After Running a Query