ExecuteNonQuery

code02.cs

 using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
            {
                connection.Open();

                using (SqlCommand cmd = new SqlCommand(@"SELECT * FROM Table WHERE Id = @Input", connection))
                {
                    cmd.Parameters.Add("Input", SqlDbType.Int).Value = 1;

                    cmd.ExecuteNonQuery();
                }
            }