Information on Phase I of the Project

• Use .NET to query your database in ISQL01

  Visit http://iisqlsrv.cs.washington.edu/cse444_ta/example.aspx to see a simple example.

  The following files show the C# code for this example. Each file corresponds to a web form.

  • This file example.aspx.cs is the start page that has buttons to serve different functions.
  • This file results.aspx.cs shows how to connect to your database, execute a query, and return the result of the query.
  • The html view of results.aspx that has the datagrid and span I use in results.aspx.cs

  Basically, in phase 1 you need to be able to do execute certain queries (according to your domain) and show the results of the queries. There are two things you need to do. First, develop a simple interface (in my case, example.aspx) that shows the queries that users can perform. Second, in your project you need to connect to your database, execute the query, and put the results on the web.

  In my example, when you click the "Get Results" Button, the code for that button (in the first file) will execute the Response.Redirect("results.aspx") command and go to results.aspx (the code in the second file).

  Once invoked, results.aspx (the code is in results.aspx.cs) will connect to the specified database, execute the query, and return the results.

  This is just one of the many ways to implement phase I. You don't have to follow the layout of the example. I just want to demonstrate a simple way to query your database using C# and .NET.