The following C# tutorials are available:
| C# / MS-SQL Tutorials | |||
| 1 | Installing a C# Web Development Environment 4 Feb 2008 | A step by step guide to installing a C# web development environment. 1 - Introduction 2 - Installing IIS 3 - Installing the Applications | |
| 2 | Creating a Simple Web App 4 Feb 2008 | A step by step guide to creating your first C# web application. 1 - Introduction 2 - Create the Web App 3 - Editing the Default Page 4 - Writing Some Code 5 - Creating a Web Form 6 - Processing a Web Form 7 - Processing Input | |
| 3 | Exploring Logic 6 Feb 2008 | Going deeper into programming logic. 1 - Introduction 2 - If - Then - Else 3 - Ternary Operations 4 - Switch - Case 5 - Operators | |
| 4 | A Real Web Application 9 May 2008 | This tutorial will go into object oriented programming and how to interface with a database backend to build a real-world web application. 1 - Introduction 2 - Setting Up Our Project 3 - Programming The Page Layout 4 - Make the Form Dance 5 - Databases - Configuration 6 - Databases - Creating Structure 7 - Accessing the Database 8 - Database Access Improved 9 - Security 10 - Displaying Database Results 11 - Urban Renewal | |
| 5 | Using Microsoft SQL Server 13 May 2009 | This tutorial covers SQL and Microsoft SQL Server Express 2005. A firm understanding of SQL and relational databases is a great help when building web apps. This tutorial covers basic SQL usage. Slightly more advanced SQL will be covered in the next tutorial. 1 - Introduction 2 - Managing SQL Server - Create a User 3 - Managing SQL Server - Create a Database 4 - The Database Branch 5 - Basic SQL - INSERT 6 - Basic SQL - SELECT 7 - Basic SQL - UPDATE 8 - Basic SQL - DELETE and CREATE | |
| 6 | Mildly Advanced SQL 13 May 2009 | The previous tutorial focused on using Microsoft SQL Server and some very basic SQL queries. In this tutorial we'll be going into slightly more advanced SQL. We'll also go into how a database should be designed. 1 - Introduction 2 - Database Structure 3 - Joins 4 - Subqueries 5 - Conclusion | |
| 7 | A Blogging Application 10 June 2009 | With the previous tutorials completed, we'll focus on building a blogging application from scratch using C# with a MS-SQL database backend. 1 - Introduction 2 - Planning 3 - Creating the DB 4 - Designing the Blog Display 5 - Coding the Blog Display 6 - User Authentication - 1 7 - User Authentication - 2 8 - User Authentication - 3 9 - Blog Creation 10 - Edit and Delete a Blog 11 - User Management 12 - Add New Users 13 - Comments 14 - Adding, Editing and Deleting Comments 15 - Tweaks and Security 16 - Conclusion 17 - Addendum | |