using System; using System.Data; using System.Data.SqlClient; class ExecuteInsertUpdateDelete { public static void DisplayRow(SqlCommand mySqlCommand, string ID){ mySqlCommand.CommandText ="SELECT ID, FirstName FROM Employee WHERE ID = '" + ID + "'"; SqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(); while (mySqlDataReader.Read()) { Console.WriteLine("mySqlDataReader[" ID"] = " + mySqlDataReader["ID"]); Console.WriteLine("mySqlDataReader[" FirstName"] = " + mySqlDataReader["FirstName"]); } mySqlDataReader.Close(); } public static void Main() { SqlConnection mySqlConnection =new SqlConnection("server=(local)SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;"); SqlCommand mySqlCommand = mySqlConnection.CreateCommand(); mySqlCommand.CommandText ="INSERT INTO Employee (ID, FirstName) VALUES (" + " 9, 'Jason')"; mySqlConnection.Open(); int numberOfRows = mySqlCommand.ExecuteNonQuery(); Console.WriteLine("Number of rows added = " + numberOfRows); DisplayRow(mySqlCommand, "9"); mySqlCommand.CommandText = "UPDATE Employee SET FirstName = 'New' WHERE ID = '9'"; numberOfRows = mySqlCommand.ExecuteNonQuery(); Console.WriteLine("Number of rows updated = " + numberOfRows); DisplayRow(mySqlCommand, "9"); mySqlCommand.CommandText ="DELETE FROM Employee WHERE ID = '9'"; numberOfRows = mySqlCommand.ExecuteNonQuery(); Console.WriteLine("Number of rows deleted = " + numberOfRows); mySqlConnection.Close(); } }