CODE EXAMPLE FOR CSHARP

how c# connection

using (var conn = new SqlConnection(connectionstring))  
{  
    // your sql magic goes here
}