| |
| Lesson 1 - SQL Server, Data Access and Gridview |
| |
Download source code here.
- Create a SQL Server Database
- Create a table, populate it with data and select primary key
- Create a new ASP.NET application
- Create a database connection manager
- Create the database layer within a Data Access Component
- Create a gridwiew to display the data
|
|
|
| Lesson 2 - Multithreading, Progress Bar and Gridview |
| |
Download source code here.
- Create a new windows form application
- Create a gridview to display data (Lesson 1 skills)
- Create and configure a progress bar
- Use MethodInvoker to create delegates
- Create methods and make them thread safe using Monitor
|
|
|
| Lesson 3 - Disconnected DataSet and DataAdapter |
| |
Download source code here.
- Create a new windows form application
- Create a Disconnected DataSet, DataAdapter, DataSchema, DataTable and DataColumn
- Insert, Update and Delete data within the DataSet
- Save the changes made to the DataSet to the database
- Reject the changes made to the DataSet
- Filter data within the GridView
|
|
|
| Lesson 4 - Gridview, AJAX Modal and Field Validators |
| |
Download source code here.
- Improve look and feel of a Gridview using Styles, Color and Padding
- Insert data into a database using an AJAX modal popup
- Update, Delete and Filter data from a Gridview
- Implement a RequiredFieldValidator and a RegularExpressionValidator
|
|
|
| Lesson 5 - C# Class, Stored Procedure, Child Gridview, List<T> |
| |
Download source code here.
- Add a foreign key relationship in SQL Server
- Create a Class using C#
- Create a Stored Procedure
- Create and configure a child Gridview
- Call a method of a class
- Handle NULL exceptions
|
|
|
| Lesson 6 - Inheritance, Polymorphism and Encapsulation |
| |
Download source code here.
- Create a Child Gridview
- Inherit a class
- Implement polymorphism
- Access public, private and protected variables
|
|
|
| Lesson 7 - Events, Delegates, Stack and Heap |
| |
Download source code here.
- Create and implement a Delegate
- Create and implement custom event arguments and event handles
- Learn about the Stack and Heap in C# and in Managed Code
- View the Stack and Heap in the debug windows
- View values in the Call Stack
- Autos and Locals windows
- View a value type and reference type example
- View a pass by value and pass by reference example
|
|
|
| |
| |
| |
  |
| |
| |
| |
|
|
| |
|
|
| |
|
|
| |
| |
| Posts: 113 |
| Comments:
86 |
| Fundamentals:
16 |
| |
 |
| |
| |
|
| |
 |
| |
 |
| |
 |
| |
|
| 2011 December (2) |
| 2011 November (6) |
| 2011 October (7) |
| 2011 September (7) |
| 2011 August (9) |
| 2011 July (9) |
| 2011 June (8) |
| 2011 May (9) |
| 2011 April (7) |
| 2011 March (9) |
| 2011 February (8) |
| 2011 January (8) |
| 2010 December (7) |
| 2010 November (8) |
| 2010 October (4) |
| |
| |
|
| |
|
|
| |
| |
|
The sample code on this website is provided to illustrate a concept and should not be used in
applications or Web sites without proper professional consultation, as it may not illustrate
the safest coding practices. I assume no liability for incidental or consequential damages
should the sample code be used for purposes other than as intended.
|
| |
|
| | | |