asp.net数据库update

using System.Data.SqlClient;

public void UpdateUser(int userId, string newName)
{
    string connectionString = "your_connection_string";
    string updateQuery = "UPDATE Users SET Name = @Name WHERE Id = @Id";

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlCommand command = new SqlCommand(updateQuery, connection);
        command.Parameters.AddWithValue("@Name", newName);
        command.Parameters.AddWithValue("@Id", userId);

        connection.Open();
        int rowsAffected = command.ExecuteNonQuery();
        if (rowsAffected == 0)
        {
            Console.WriteLine("No rows updated.");
        }
        else
        {
            Console.WriteLine("Update successful.");
        }
    }
}

string updateQuery = "UPDATE Users SET Name = @Name WHERE Id = @Id";
SqlCommand command = new SqlCommand(updateQuery, connection);
command.Parameters.AddWithValue("@Name", newName);
command.Parameters.AddWithValue("@Id", userId);

using (SqlConnection connection = new SqlConnection(connectionString))
{
    // 执行数据库操作
}
// 连接会在 using 块结束时自动关闭