C#: SqlConnection Connection String

C# SqlConnection Connection String Source Code Example

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

Prerequistes:

1. Install C# (Express or Standard Edition)
2. Install SQL Server Express
3. Download Northwind Database
4. 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 C# 2008 (Express or Standard) Edition
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();

           

        }
    }
}

Related posts:

1. VB.NET: SqlConnection Connection String SqlConnection Connection String VB.NET Source code example....
2. C# String.Format DateTime Source Code Example C# String.Format DateTime Source Code Example...
3. C# – Sql Parameters – Insert Statement C# - Illustrates using Sql parameters with Insert Statement...
4. VB.NET String Format DateTime Source Code Example VB.NET String Format DateTime Source Code Example...
5. C#: Sql Stored Procedure Source Code Example C# Sql Stored Procedure source code example with SqlDataReader...

Related posts brought to you by Yet Another Related Posts Plugin.