Labs

=Labs=

SQL Server detach/attach || || || Review of updated ERD and GUI || ||
 * No. || Date || Objective || Attachment ||
 * 1 || 12/2/10 || An intro of GUI based programming in C# || [[file:Lab1-CSharpGUISamples.zip]] ||
 * 2 || 16/2/10 || Implementation of GUI in C# || [[file:Lab 2 - C# GUI.pdf]] ||
 * 3 || 19/2/10 || Debugging in C#, Project Discussion, Intro of SQL Server and Visio. ||  ||
 * 4 || 23/2/10 || Creating ERD in Visio. || [[file:Lab 4.pdf]] ||
 * 5 || 2/3/10 || Creating database, tables and relatinships in SQL Server ||  ||
 * 6 || 5/3/10 || Creating database, tables and relatinships in SQL Server
 * 7 || 9/3/10 || Database forward engineering and reverse engineering using Visio and SQL Server || [[file:Lab 6.pdf]]
 * 8 || 26/3/10 || First demo of Project ERD and Interface. SQL Queries ||  ||
 * 9 || 30/3/10 || SQL (Simple SELECT and JOIN) || [[file:Lab 7.pdf]] ||
 * 10 || 2/4/10 || Database connectivity in C#
 * 11 || 6/4/10 || SQL ( Joins, Group By ) || [[file:Lab 9.pdf]] ||
 * 12 || 9/4/10 || SQL( Joins, Group By, Subqueries, Datetime functions) || [[file:Lab 10.pdf]] ||
 * 13 || 20/4/10 || SQL (Insert/Update/Delete) || [[file:Lab11.pdf]] ||
 * 14 || 30/4/10 || Stored Procedures || [[file:Lab12.pdf]] ||
 * 15 || 4/5/10 || Data Import/Export using Bulk Copy Program (BCP) || [[file:Lab13.rar]] ||
 * 16 || 18/5/10 || Indexing, Transactions & Concurrency || [[file:Lab 14.pdf]] ||
 * 17 || 21/5/10 || Handling of Txn in C# code, Project Review and Updates ||  ||
 * 18 || 25/5/10 || Project Review and Updates ||  ||
 * 19 || 28/5/10 || Data Reporting in C# ||  ||