function A() { SqlConnection connString = new SqlConnection(SqlCred); SqlCommand cmdInsert = new SqlCommand("Query here", connString); try { connString.Open(); cmdInsert.ExecuteNonQuery(); connString.Close(); connString.Dispose(); } catch {} }
function B() { using(SqlConnection connString = new SqlConnection(SqlCred)) { using sqlcmd cmd = (//stuff//) { connString.Open(); cmd.executenonquery(); } } }
namespace Program { public class Program class { SqlConnection connString = new SqlConnection(SqlCred); functionX(connString); functionY(connString); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)