Exercise 1
Create a Customer Class that reads details from the Northwind database

In this exercise, you will create a customer class in a web application. The class will contain a method that reads the customers table.

1. Create an empty Web Application project called Business Application.
2. Add a class file called Customers.cs to the project.
3. Import the these namespaces in to the class:
   using System.Data.SqlClient;
using System.Data;
4. Declare at class level these ADO.Net objects:
   private SqlConnection conn;
private SqlDataAdapter da;
private DataSet ds;
5. Add a GetCustomers() method that returns a DataSet to the class.
6. Add code to GetCustomers() that reads data from the Customers table and copies this to the DataSet: – change the name of DataSource to your instance of SQL Server.
   public DataSet GetCustomers()
{
conn = new SqlConnection(@"DataSource=.; Initial
Catalog=Northwind;Integrated Security=True");
string queryString
="SELECT CustomerID, CompanyName FROM dbo.Customers";
da = new SqlDataAdapter(queryString, conn);
ds = new DataSet();
da.Fill(ds, "Customers");
return ds;
}
7. View code file.

Exercise 2
Show Customer Data on a Web Form

In this exercise, you will add a web form that shows customer data. The form will use the customer class to access the database.

1. Add a web form called Default.aspx to the project. Set this as the start page.
2. Add a GridView control to Default.aspx called gvCustomers.
3. In the form’s Page_Load event handler create a Customers object & call the GetCustomers method.
   Customers custObject = new Customers();
DataSet ds = custObject.GetCustomers();
4. Bind the GridView to the DataSet returned from the GetCustomers method.
   gvCustomers.DataSource = ds.Tables["Customers"];
gvCustomers.DataBind();
5. View code file.
6. Run the application to test if customer data is displayed.
7. Enhance the application, for example:
   • Allow customer data to be updated.
   • Move the Customer class to a separate project
   • Improve the UI

Back to beginning