0.3 Creating a Database, a Table, and Connecting to the Database

Question 1

What are the steps to creating and connecting to a database?

Answer 1

1. Create the database
2. Create tables in the database
3. Obtain the connection string
4. Connect to the Database, using a data provider

Question 2

How do you create a database in ADO.net?

Answer 2

1. Open Server explorer in visual studio
2. Right click on data connections and select ‘add new connection’ and fill the following information:
   
   • Enter your server name
   • Choose windows authentication
   • Enter your database name
3. Click ok

Question 3

How do you create a table in ADO.net?

Answer 3

0. Find your database name in server explorer
1. Expand the database folder
2. Right click on the tables folder and select ‘add new table’
3. Enter your table creation command as so:
   CREATE TABLE [dbo].[TableName] (
   [ColumnName] DATATYPE CONSTRAINTS,
   [COLUMNNAME] DATATYPE CONSTRAINTS
   )
4. Click on the update button to create the database

Question 4

In ADO.net how do you obtain the connection string for your database?

Answer 4

Right click on the database in server explorer, select properties, and find and copy the database connection string

Question 5

How do you connect to a database in ADO.net?

Answer 5

SqlConnection conn = new SqlConnection(‘connection string’);

SqlCommand cmd = new SqlCommand(“Sql Query”, conn);

conn.Open();

SqlDataReader reader = cmd.ExecuteReader();