Database Reference
In-Depth Information
// Create connection
SqlConnection conn = new SqlConnection(@” server = .\sql2012;
integrated security = true; ");
try
{
// Open connection
conn.Open();
Console.WriteLine("Connection opened.");
// Display connection properties
Console.WriteLine("Connection Properties:");
Console.WriteLine("\tConnection String: {0}",
conn.ConnectionString);
Console.WriteLine( "\tDatabase: {0}", conn.Database);
Console.WriteLine( "\tDataSource: {0}", conn.DataSource);
Console.WriteLine("\tServerVersion: {0}", conn.ServerVersion);
Console.WriteLine( "\tState: {0}", conn.State);
Console.Writel_ine("\tWorkstationld: {0}", conn.Workstationld);
}
catch (SqlException ex)
{
// Display error
Console.WriteLine("Error: " + ex.Message + ex.StackTrace);
}
finally
{
// Close connection
conn.Close();
Console.WriteLine("Connection closed.");
}
Console.ReadLine();
}
}
}
3.
To set ConnectionDisplay as the startup project, select the project in Solution
Explorer, right-click and select Set as StartUp Project, and run it by pressing
Ctrl+F5. If the connection is successful, you'll see output like that shown in
Figure 12-3.
