Accessing and Updating Data in ASP.NET 2.0: Deleting Data

A Multipart Series on ASP.NET 2.0"s Data Source Controls

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. Deleting Data - see how to delete data using a SqlDataSource control. Also looks at how to programmatically cancel a delete. (Subscribe to this Article Series! )

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.

Deleting Data - see how to delete data using a SqlDataSource control. Also looks at how to programmatically cancel a delete.

(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 by allowing for a declarative approach to working with data. In short, the data source controls make it possible to retrieve, insert, update, and delete data without having to write the tedious dedata access code that was so commonplace in ASP.NET version 1.x. (A previous installment of this article series examined using the SqlDataSource to insert data into a database.)

In this article we will focus on using the SqlDataSource control to delete records from a database. Specifically, we will look at three examples: using a SqlDataSource and a bit of server-side code to delete a record selected from a drop-down list; and using the GridView Web control"s built-in deleting support; and how to programmatically cancel a delete operation. Read on to learn more!
Read More >

>>Source Link
>>Blog: 4GuysFromRolla.com Headlines
>>Publish Date: 6/21/2007 7:11:52 AM
>>Keywords: data controls

Related Posts
>>Accessing and Updating Data in ASP.NET 2.0: Inserting Data #
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 declarat
>>Accessing and Updating Data in ASP.NET 2.0: Declaratively Caching Data #
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 declarat
>>Accessing and Updating Data in ASP.NET 2.0: Programmatically Accessing Data using the Data Source Controls #
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 declarat
>>Building a User Control that Displays RSS Feeds Using a DataList and an XmlDataSource Control #
Displaying data in ASP.NET verison 1.x required writing code to programmatically retrieve the data and then more code to bind the data to a data Web control, such as the DataGrid. ASP.NET 2.0 simpli
>>Working with Data in ASP.NET 2.0 #
A ton of great articles and tutorials on working with data in ASP.NET 2.0 applications has been published recently. This post highlights a few of them (including tools like SubSonic and NHibernate):
>>Filtering Custom Paged Results #
Introduction The ASP.NET 2.0 data web controls - the GridView, DetailsView, and FormView - all provide built-in paging support that can be enabled at the tick of a checkbox. Unfortunately, this built-
>>Video: Binding Data to ASP.NET 2.0 Server Controls #
In my last blog entry I wrote about how to bind data to different ASP.NET 2.0 server controls using the SqlDataSource, XmlDataSource and ObjectDataSource. I also discussed how controls could be embedd
>>Using ObjectDataSource to do the dirty work for your custom data source #
Since ASP.NET 2.0 was released in 2005 many of you have taken advantage of the new data source control controls . Drop a GridView on the page. Bind it to a data source. Check a few checkboxes. Run the
>>Microsoft ASP.NET Futures #
Microsoft ASP.NET Futures contains an early developer preview of features providing a wide range of new functionality for both ASP.NET and Silverlight. This comes from the latest announcements : ASP
>>ASP.NET Futures Release #
I am super excighted about the ASP.NET Futures release we did recently. I think it shows off some cool new thinking in the ASP.NET space, for Ajax applications and of course Silverlight support. I

Friends, Technology, Web2.0 - What I am reading