Accessing and Updating Data in ASP.NET 2.0: Inserting Data
Posted by: 4GuysFromRolla.com Headlines,
on 01 May 2007 |
View original | Bookmarked: 0 time(s)
| A Multipart Series on ASP.NET 2.0's Data Source Controls |
|---|
ASP.NET 2.0 introduced a number of new Web controls designed for accessing and modifying data.
These controls allow page developers to declaratively access and modify data without writing any
code to perform the data access. This article is one in a series of articles on ASP.NET 2.0's new data
source controls.
Data Source Control Basics - explores the concepts
and advantages of data source controls, and compares their usage in ASP.NET 2.0 to data access techniques in ASP.NET 1.x.Accessing Database Data - shows how to use the
SqlDataSource and AccessDataSource controls to query data from a relational database.Filtering Database Data with Parameters - learn how to
retrieve just a subset of database data based on hard-coded values and values from the querystring, other Web controls on the page,
session variables, and so on.Retrieving XML Data with XmlDataSource Control - see how
to retrieve both remote and local XML data and display it in a data Web control.Creating Custom Parameter Controls - learn how
to create your own custom, declarative Parameter controls for use in the data source controls' parameters collections.Examining the Data Source Control's Events - explore the
events raised during a data source control's lifecycle.Declaratively Caching Data - learn how to cache data
to the data cache simply by setting a couple of data source control properties.Programmatically Accessing Data using the Data Source Controls -
programmatically retrieve, insert, delete, and update data using the SqlDataSource and AccessDataSource controls.Inserting Data - learn how to insert data using
a SqlDataSource control. Also examines how to retrieve the IDENTITY column value for the just-inserted record.
(Subscribe to this Article Series!
 ) |
ASP.NET 2.0's data source and data Web controls make working with data much easier than in previous versions. These controls
allow for a declarative approach to working with data, without needing to write any cumbersome data access code. The
articles we have explored in the series thus far have focused on understanding the core concepts of the data source
controls and how to retrieve data from the database. In addition to retrieving data, the data source controls can also
insert, update, and delete data.
In this article we will focus on using the SqlDataSource control to insert records into a database. We will look at three examples:
using a SqlDataSource and to insert a record using values entered by the user through various TextBoxes, DropDownLists, and
other Web controls on an ASP.NET page; inserting using a SqlDataSource and a DetailsView
control; and determining the value of the just-inserted record's IDENTITY column. Read on to learn more!
Read More >