Db Location Of Sql Express.

How do you know what exactly to use as the database name?



In school the prof says he is not exactly a database programmer but gave us some code he had from an old one. That code worked fine if you want to actually connect to the database at school but I want to send everything right through sqlexpress on my own machine so I can work on the programs at home.



The following is the code to connect to the school database, how would I change it to connect through sqlexpress instead?








Code Snippet

using System;

using System.Data;

using System.Data.SqlClient;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;



namespace Database

{

/// <summary>

/// Summary description for Class1.

/// </summary>

public class Class1

{

SqlConnection connection;

public Class1()

{

}//closes constructor

public void connect(string computerID)

{

connection = new SqlConnection("Data Source = " + computerID +

"; Initial Catalog = test; Integrated Security = SSPI");

try

{

if(connection.State == ConnectionState.Closed)

connection.Open();

}//closes try

catch(Exception ex)

{

MessageBox.Show("connection no" + ex.Message.ToString());

}//closes catch

}//closes connection method

public void Write(string Name, string ID, string Grade, string Average)

{

string add = "INSERT INTO Example VALUES('" + Name + "', '" +

ID + "', '" + Grade + "', '" + Average + "');";

try

{

connect("DNV-WS-RM336INS");

SqlCommand command = new SqlCommand(add, connection);

command.ExecuteNonQuery();

}//closes try

catch(Exception ex)

{

MessageBox.Show(ex.Message.ToString());

}//closes catch

this.connection.Close();

}//closes write mehtod

public string Read()

{

string Info = "";

SqlCommand command = new SqlCommand("select * from Example;", connection);

SqlDataReader reader = command.ExecuteReader();

try

{

while(reader.Read())

Info += reader.GetString(1).ToString() + " " +

reader.GetString(2).ToString() + " " +

reader.GetString(3).ToString() + " " +

reader.GetString(4).ToString() + "
";

}//closes try

catch(Exception ex)

{

MessageBox.Show("read Method " + ex);

//Console.WriteLine("Error retrieving data.");

}//closes catch

reader.Close();

return Info;

}//closes read method

}//closes class

}//closes namespace



What I tried was replacing the dialog for the school database with just the text sqlexpress but that certainly didn't work.