- Series 1: Introduction
to SQL databases and ADO.Net: Using
DataSources & the Wizards
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
- Learn how to add a SQL database
to your project.
- Learn how to create tables and
add data to your new tables inside Server Explorer.
- Create Data Sources to connect to
your database tables.
- Drag and drop a grid or
textboxes to your form.
Visual Studio creates navigation and editing
capabilities for us!
Windows Version Videos:
Creating your project and new
Adding a DataSource
Adding more forms and
connecting the form to the database.
Also learn how to format your
Completing the multi-form
application including a splash screen,
timer control, & about box.
finished project here.
Be sure to change .net
framework to version 3.5 or greater and target CPU
ASP Version Videos:
Setting up a DataGridView to
read a DB table and edit/delete records
Add a DetailsView control so
we can add new records.
Add an Orders form to
edit/delete orders for a specific customer. Shows
how to link a listbox with a grid!
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!!
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
- Learn how to create a new
SQL DB in server explorer. Examine the App.Config
connection string settings.
make a new datasource and show the customer data inside a
How to work with related
tables to select data and display in
Overview of Mgmt
Studio...queries, backups, logins.
- How to
create a new database
and new login.
- 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
- 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
parameterized SQL queries
- Series 5: Using command objects to
secure passwords with one-way encryption
- Database Password Encryption
- How to encrypt passwords
- How to encrypt
demo 2 with a "salt" value(more secure).
- Get the SaltyPW Sql
here. It is a backup of mine so restore
it in Sql management server to run it on