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

Posted by: 4GuysFromRolla.com Headlines, on 01 Aug 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.
  • Deleting Data - see how to delete data using a SqlDataSource control. Also looks at how to programmatically cancel a delete.
  • Updating Basics - learn the basics of updating database data using a SqlDataSource control. Also examines using the GridView to provide a web-based editing interface.
  • (Subscribe to this Article Series! )

    ASP.NET 2.0's 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. Previous installments of this article series have looked at returning, inserting, and deleting data using the SqlDataSource control. However, we have yet to look at updating data.

    In addition to the SqlDataSource control, ASP.NET 2.0 introduces three new data Web controls: the GridView, the DetailsView, and the FormView. These controls can work in unison with the data source controls to facilitate inserting, updating, and deleting data. In this article we will examine basics of using the SqlDataSource and GridView controls to update records from a database. In particular, we look at enabling editing support in the GridView. Future installments will explore more advanced updating scenarios, such as customizing the GridView's editing interface and programmatically setting the updated values. Read on to learn more!
    Read More >

    Category: SQL | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 1076 | Hits: 48

    Similar Posts

    • Introducing Versatile DataSources more
    • Connecting to SQL Azure with Telerik OpenAccess more
    • How to display data from different tables using one data source more
    • Project Turing: Beginning RIA Svcs more
    • An alternative to Crystal more
    • Building a class browser with Microsoft Ajax 4.0 Preview 5 more
    • ASP.NET AJAX 4.0 Preview 5 released to CodePlex more
    • Take Caution with WinForms DataGridView RowPrePaint more
    • A Tool For Querying Multiple Databases more
    • Project Turing: Beginning RIA Services more

    News Categories

    .NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD