class SqlHelper
    {
        private static readonly string connstr = ConfigurationManager.ConnectionStrings["lkfCon"].ConnectionString;

        public int ExecuteNonQuery(string cmdText, params SqlParameter[] parameters)
        {
            
            using (SqlConnection con = new SqlConnection(connstr))
            {
                con.Open();
                using (SqlCommand cmd = con.CreateCommand())
                {
                    cmd.CommandText = cmdText;
                    cmd.Parameters.AddRange(parameters);
                    return cmd.ExecuteNonQuery();
                }                 
             }
        }
    }