Connect To SQLServer

This simple snippet creates a connection to an SQLServer database.

1. using System;
2. using System.Data;
3. using System.Data.SqlClient;
5. class Program
6. {
7.     private static SqlConnection _con = null;
9.     static void Main(string[] args)
10.     {
11.         string host = ""; //Enter your host
12.         string catalog = ""; // Enter your database name
13.         string strProvider = "Data Source=" + host + ";Initial Catalog=" + catalog + ";Integrated Security=True";
15.         try
16.         {
17.             _con = new SqlConnection(strProvider);
18.             _con.Open();
20.             if (_con.State == ConnectionState.Open)
21.             {
22.                 Console.WriteLine("Connection Open");
23.             }
24.         }
25.         catch (Exception e)
26.         {
27.             Console.WriteLine(e.Message);
28.         }
30.         Console.ReadKey();
31.     }
32. }