Quick Reference to ADO.Net

	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