using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); string insertCommand = "INSERT INTO Students (FirstName, LastName) VALUES ('John', 'Doe')"; SqlCommand command = new SqlCommand(insertCommand, connection); int rowsAffected = command.ExecuteNonQuery(); Console.WriteLine("Rows affected: " + rowsAffected); }
using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); string updateCommand = "UPDATE Students SET LastName = 'Smith' WHERE FirstName = 'John'"; SqlCommand command = new SqlCommand(updateCommand, connection); int rowsAffected = command.ExecuteNonQuery(); Console.WriteLine("Rows affected: " + rowsAffected); }In the above example, we are updating the LastName column of the Students table where the FirstName is 'John'. The update statement is passed to the SqlCommand object and executed using the ExecuteNonQuery method. The number of rows affected is printed to the console. Package library: System.Data.SqlClient.