• Series 1: Introduction to SQL databases and ADO.Net:  Using DataSources & the Wizards

1. Series 1 demonstrates the easiest method of connecting to a SQL database within Visual Studio. You will learn how to create a new SQL database, add some DataSource objects, and create a multi-form application. You will be able to modify, insert, and delete records... all with a minimal amount of coding!
2. Learn how to add a SQL database to your project.
3. Learn how to create tables and add data to your new tables inside Server Explorer.
4. Create Data Sources to connect to your database tables.
5. Drag and drop a grid or textboxes to your form.

See how Visual Studio creates navigation and editing capabilities for us!

Windows Version Videos:

Creating your project and new database.
Adding a DataSource
Adding more forms and connecting the form to the database. Also learn how to format your data.
Completing the multi-form application including a splash screen, timer control, & about box.

Get the finished project here. Be sure to change .net framework to version 3.5 or greater and target CPU to x86.

ASP Version Videos:

1. Setting up a DataGridView to read a DB table and edit/delete  records

2. Add a DetailsView control so we can add new records.

3. Add an Orders form to edit/delete orders for a specific customer. Shows how to link a listbox with a grid!

4. Add a DetailsView Control to the Order form so we can add new records.

5.How to make the DetailsView calculate tax and total due for a new record!!  (Very cool)

Get the finished website project here. BE SURE TO RUN THE DATASOURCE WIZARD TO CREATE A NEW CONNECTION STRING FOR YOUR MACHINE!

• Series 2: Using Server Explorer Wizards, & Management Studio Express

• Windows Project Videos:

1.  Learn how to create a new SQL DB in server explorer. Examine the App.Config connection string settings.
2. Now, make a new datasource and show the customer data inside a grid.
3. How to work with related tables to select data and display in synchronized grids!

• SQL Management Studio Express

1. Overview of Mgmt Studio...queries, backups, logins.
2. How to create a new database and new login.
3. How to attach a new database (Northwind & Pubs databases) using a script to SQL Server Express.

• Series 3: Using ADO.net in code & the Disconnected Model

• SQL projects using ADO in code
  
  Get my Database for these projects( customers-05)
  
  ADO in code Part 1: Using a grid control  Video
  ADO in code Part 2: Modifying records    Video
  
  
  How to select data from related tables (Shows how to use two tables to get details view of customer orders)
   
• More complex database programming:
  
  ATM 3 DB version
  Working with Related tables & data sources
• Creating a UI with your own Textboxes in SQL 2008
  
  Custom Databinding with SQL 2008 (includes DB) Be sure to look at connection string in app.config file.

• Series 4: Using ADO.net in code & the Connected Model

• Introduction to the SQL Command Object for connected environments
• SQL Command Object: How to execute SQL statements, Stored Procedures, Scalar commands, create a table, & save table data as XML.
  
• Using parameterized SQL queries

• Series 5: Using command objects to secure passwords with one-way encryption

• Database Password Encryption
• How to encrypt passwords demo 1
• How to encrypt passwords demo 2 with a "salt" value(more secure).
  • Get the SaltyPW Sql database here. It is a backup of mine so restore it in Sql management server to run it on your machine.