private static void ExecuteNonQuery(string connectionString, string sql)
{
using (var connection = new SqlConnection(connectionString))
{
var command = connection.CreateCommand();
command.CommandText = sql;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
}