ASP.NET Database Projects

Database Setup

1) Run "SQL Server Management Studio" (or "SQL Query Analyzer" in case you use MS SQL Server 2000) and connect to sql2005.development.ccs.neu.edu (or sql2000.development.ccs.neu.edu in case you use MS SQL Server 2000) via SQL Server authentication (If you cannot remember details, please visit this link for SQL 2005 or this Link for SQL 2000). Please type in your username and MS SQL password. After connected, Run the database engine query from the menu or by clicking the shortcut icon.

1) Copy the script in the file db design and paste it into the query window you just opened. Two tables will be created: groups lists various sports groups, and members lists the members with their name, contact and the sports group they belong to. You are required to understand the design of the two tables.

2) Click the button or press "F5" to execute the script to create the two tables. The returned message of the execution is “The command(s) completed successfully.”

3) Remove all the script in the query window. Copy the script in the file initial data and paste it into the query window. Click the button with green arrow to execute the script to populate the two tables. The returned messages include “XXX rows affected”. We utilize the data from pubs.dbo.authors to populate the table members.

4) Now you can test the database you just set up. Remove all the script in the query window. Then execute statement “select * from members” and “select * from groups”, respectively. You will see the two tables have been created and populated.

Some Useful Links

• Introduction to HTML: http://www.cwru.edu/help/introHTML/toc.html

• Detailed specifications and guidelines of HTML, and others: http://www.w3.org/

• MSDN with official references to ASP.NET and Visual C#, and others: http://msdn1.microsoft.com/en-us/default.aspx

• Examples of creating HTML, using ASP.NET, writing C# programming: http://www.google.com

Play with ASP.NET Web Applications

We are going to use C# programming language, ASP.NET and ADO.NET for our web applications. Although C#, ASP.NET and ADO.NET contain large amount of concepts and techniques, we will use only a small part of them. You are required to study and understand some sample programs, and make necessary modifications to implement new features.

You are supposed to have basic knowledge about HTML, and commonly used programming languages such as C++ and Java. C# is an objected-oriented programming language, which is very similar to C++ and Java. The language components used in our samples are quite self-explained. On every Windows machine in the CCIS network, you can find related help documents in MSDN library (run Microsoft Visual Studio .NET Document):

• for C#: under directory “Visual Studio .NET\Visual Basic and Visual C#”
• for ADO.NET: under directory “Visual Studio .NET\.NET Framework\Programming with .NET Framework\Accessing Data with ADO.NET”
• for ASP.NET: under directory “Visual Studio .NET\.NET Framework\Building Applications\Creating ASP.NET Web Applications”

In addition, an excellent book “Microsoft Visual C# .NET (Core Reference)” can be found at amazon, which covers C#, ADO.NET and ASP.NET.

To access Microsoft SQL Server, we are going to use components in ADO.NET, rather than ODBC, and we are going to use SQL Server authentication (that is, with explicit username and password) in the web programs, rather than Windows authentication. To enable debugging and for some other purposes, copy the script in web configuration to a file named web.config (using the text editor Notepad, notice the file name shouldn’t end with .txt), and upload this file to \\Development\net\home\your-username\www. If you do not know how to upload your files, please visit this URL.

We will play and study ALL the following six sample applications IN ORDER. Each sample application is briefly explained.

• 1^st application: list all group names
• 2^nd application: list all members (with optional exercise)
• 3^rd application: search members (with optional exercise)
• 4^th application: insert new members (with optional exercise)
• 5^th application: update and delete members (with optional exercise)
• 6^th application: jump from one web page to another
• 7^th application: Hide your user name and password

To learn about changing web controls’ visual look, please reference Apply Styles to Controls. For a complete attributes of styles, please reference CSS Attributes.