|
Command Objects
|
Returns
|
O/p Type
|
Used
|
||
|
1
|
Execute Non Query
|
No Of Rows Effected
|
int
|
Insert, Update
|
|
|
2
|
ExecuteReader
|
SqlDataReader
|
SqlDataReader
|
Fetch Data
|
|
|
3
|
ExecuteScalar
|
First Col of First Row
|
int, string
|
Count(*)
|
|
|
4
|
SqlDataReader
|
||||
|
Features
|
|||||
|
Forward Read-only
|
|||||
|
Initiate only using ExecuteReader()
|
|||||
|
5
|
Dataset
|
||||
|
The DataSet represents
a complete set of data independent of actual DataSource
|
|||||
|
Interaction with
existing data sources is controlled through the DataAdapter
|
|||||
Thursday 13 June 2013
Quick Reference to ADO.Net
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment