In this tutorial we will cover adding data to a pre-existing database table.
Adding Data to a Database Table
Download the Adding Data Project Source
In this tutorial we will cover adding data to a pre-existing database table. If you do not already have a table created please see the creating a basic table database tutorial to learn how to create a table or download the basic database table source file from the last tutorial.
Yes, it is possible to find a good web host. Sometimes it takes a while. After trying several, we went with Server Intellect and have been very happy. They are the most professional, customer service friendly and technically knowledgeable host we've found so far.
1. In the server explorer expand the CustomerInfo.mdf file (or the database file you plan to work with). Expand the Tables folder and right click on the Customers table.
2. In the dropdown list, select Show Table Data.
3. Leave the customer ID column Blank and select the FirstName column. In the FirstName column type John then press the TAB key.
4. In the LastName column type Doe then press the TAB key.
5. In the AccountStatus column type Closed then press the TAB key.
6. In the MemberSince column enter a date and make sure it is entered as a standard in the following order mm/dd/yyyy, then press TAB.
7. In the account balance column enter 5000 and then press the TAB key one more time to create the data row.
8. Create a couple more rows of data. The names and dates can be anything you want, just so you can see how the data is entered.
-The image below is an example of the data I entered into the table.
We are using Server Intellect and have found that by far, they are the most friendly, responsive, and knowledgeable support team we've ever dealt with!