Section 1: Creating Our Project, Database and Tables

In Section 1 of this tutorial by Nannette Thacker, we learn how to create a project and our SQL Server Database Tables using Visual Web Developer or Visual Studio 2005 or 2008. We will look at the design of our Excel Spreadsheet and create a new database and tables for our imported data.

We learn how to use the Solution Explorer (Solution Explorer in VWD and Server Explorer in Visual Studio), and use the Database Explorer. We learn how to add a table, set a primary key, and use the Identity Specifications property when creating a table column.

• Introduction: C# and VB Project: A Tutorial Using Data Sets, Table Adapters, WebForms, Controls, File Upload, Excel Import
• Section 1: Creating Our Project, Database and Tables

Download the ZIP files:
C#: ShiningStarCExcel.zip
VB: ShiningStarVBExcel.zip

As you're learning ASP.net, you may feel overwhelmed with bugs and errors. Don't underestimate God's concern with your daily troubles. He wants you to turn to Him as a flower turns to the sunshine. When you are struggling with a task, ask Him for help. He promises He will be there for you.

God is our refuge and strength, an ever-present help in trouble. Psalm 46:1

May your dreams be in ASP.NET!
Nannette Thacker