Coding the project

This chart does not represent the real data yet. It is just a theoretical preview. So, double-click on the Load Data button, which brings up the event handler in Default.aspx.cs. Delete the Page_Load stub. We'll start with the code shown in Figure 20.5.5 for this project:

Figure 20.5.5: The starting code for this project

Adding a namespace

The first thing is you have to add a namespace. So, go to the top of the file, and under using System, enter the following:

using System.Data.SqlClient;

This line is used for connections and commands.

Building the connection string

...