ExecteReader,ExecuteNonQuery,ExecuteScalar

Posted on 05/02/2011. Filed under: Asp.Net Concepts |

ExecteReader:Use for accessing data.It provide a forward only ,read only,Connected record set.

ExecuteNonQuery:Use for Data manipuation such as insert,update,delete.

ExecuteScalar:used to retreive single value 1row ,1col its example when you want to retrieve agregate functions .

Advertisement

Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Liked it here?
Why not try sites on the blogroll...

Follow

Get every new post delivered to your Inbox.