C#: SqlConnection Connection String

Posted by on Thursday, December 3, 2009 · Leave a Comment 

C# SqlConnection Connection String Source Code Example

Purpose: – Illustrates using Sql Connection in C# to create a Connection String.
Prerequistes:

  1. Install Visual Studio 2022
  2. Watch this video to enable web forms in Visual Studio 2022 Enable Web Forms websites in Visual Studio 2022
  3. Install SQL Server Express
  4. Download Northwind Database
  5. Attach Northwind Database to Databases in Sql Express

Notes:

  • Console Application is used to simplify things, but Windows Forms or Web Forms could also be used
  • You can build a library of syntax examples by using same project over and over and just commenting out what you do not want to execute in Program.cs

Instructions:

  1. Use Visual Studio 2022
  2. Create new project; select Console Application; name of Project could be CSharp_Syntax.
  3. Right-click project name in solution explorer; add new folder; name of folder could be DatabaseADONET
  4. Right-click folder; add class; class name could be clsSqlConnectionConnectionString.cs
  5. Copy code into clsSqlConnectionConnectionString.cs
  6. Copy code into Program.cs
  7. Click green arrow to start with debugging

Step 1: Use View Plain to Cut-n-paste code into clsSqlConnectionConnectionString.cs

using System.Data;
using System.Data.SqlClient;
using System;
 
public class clsSqlConnectionConnectionString
{
    static SqlConnection con;
 
    public void Main()
    {
        con = new SqlConnection("Server=.\\SQLEXPRESS;Initial Catalog=master;Integrated Security=SSPI");
        con.InfoMessage += new SqlInfoMessageEventHandler(con_InfoMessage);
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "PRINT('This is how to create an InfoMessage event')";
        cmd.Connection = con;
 
        try
        {
            con.Open();
            cmd.ExecuteNonQuery();
        }
        finally
        {
            con.Close();
        }
        Console.ReadLine();
    }
 
    static void
con_InfoMessage(object Sender, SqlInfoMessageEventArgs ev)
    {
        foreach (SqlError err in ev.Errors)
        {
            Console.WriteLine("Entering InfoMessage Event Handler");
            Console.WriteLine("Source- " + err.Source);
            Console.WriteLine("State- " + err.State);
            Console.WriteLine("Number- " + err.Number);
            Console.WriteLine("Procedure- " + err.Procedure);
            Console.WriteLine("Server- " + err.Server);
            Console.WriteLine("Message- " + err.Message);
            Console.WriteLine("Exiting InfoMessage Event Handler");
        }
    }
}

Step 2: Use View Plain to Cut-n-paste code into Program.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
 
namespace CSharp_Syntax
{
class Program
{
static void Main(string[] args)
{
//DatabaseADONET
 
clsSqlConnectionConnectionString mySqlConnectionConnectionString = new clsSqlConnectionConnectionString();
mySqlConnectionConnectionString.Main();
 
}
}
}

Filed under Code Samples · Tagged with , , , ,