This video continues our discussion of the previous ADO.NET video by examining the remaining execute methods of the SqlCommand Object, and finally covers multiple active result set functionality that can be achieved with the SQL Server 2005 editions only. We first look at the ExecuteNonQuery method of the SqlCommand Object so we can see just how easy it is to perform inserts to a database. Then we show you how to use a SqlDataReader to populate a DataTable for binding to a gridview. Finally we discuss how to insert and retrieve xml data from your database, and close the video with our discussion of MARS.

« Previous Lesson — ASP.NET 2.0 Data Access and Data-Binding — Next Lesson »

This ship has sailed …

This webpage describes one video of hundreds hosted on this website. HOWEVER …

This video has been removed from our collection.

Read why I decided to keep old pages like this around. Or better yet, visit the home page … its the best place to get started.

About this video:

Duration: 24 Minutes, 45 Seconds
Recorded Using: Visual Web Developer 2005 Express Edition or Greater