This tutorial will show you how to use C# and AJAX to create a Data Access Component that will display data from a SQL database and also allow edits of the data.
Using Visual Studio.NET to manage and manipulate data can save us a lot of time. VS.NET ships with built-in tools making it extremely easy for us to work with data sources. However, it also allows us to create our own Data Access Components, allowing us more control.

In this tutorial you will learn how to create a Data Access Component (DAC) and how we can write a method that will allow us to update the records within the database using a FormView control. Instead of using the built-in Update function, we will be writing our own to demonstrate the control we have.

Before we do anything else, we need a database. In this example, we will be working with a SQL database with one table, which has three columns – id, name and age. Once we have set up our database, we will add some sample records to work with. If you already have a database you wish to work with, then great.

The first thing we want to do is to create our class. This will handle all the interaction with our database – reading and writing. We will need to write a method for reading the data, and then a method for updating records. We will start off with reading the database:

At present, the above code is just for retrieving the data from the database. We use a List collection to gather all records from the database, and then return to the object that calls the method. In this case, we will use the ObjectDataSource to call the method, but that’s a little later in the ASPX code. Because we want to add the functionality of adding data to the database, we will need to add another method, which will look something like this:

This method uses SQL statements to update the database record with variables to it from whatever calls it. In this example, the ObjectDataSource will be calling it, which we will get to a little later.

So the entire code-behind for the class looks something like this:

Now we are done writing the class, we need to implement it into the ASPX page.
To do this, all we will do is include two controls: GridView and ObjectDataSource. We reference the Class name we just created with the TypeName of the data source and then we reference the methods: GetAll method is used to select data, and Update method is used to update data. The ASPX page will look something like this:

We can further improve this by adding a little AJAX to make the editing process a lot smoother. By adding a ScriptManager and UpdatePanel, we are forcing just the form to reload instead of the whole page:

Download Source Files