SqlCeConnection conn = new SqlCeConnection("Data Source=Database.sdf"); SqlCeCommand cmd = new SqlCeCommand("SELECT * FROM Employees", conn); SqlCeResultSet rs = cmd.ExecuteResultSet(ResultSetOptions.Scrollable); while (rs.Read()) { Console.WriteLine("ID: {0} Name: {1} Age: {2}", rs["ID"], rs["Name"], rs["Age"]); }
SqlCeConnection conn = new SqlCeConnection("Data Source=Database.sdf"); SqlCeCommand cmd = new SqlCeCommand("UPDATE Employees SET Age = @Age WHERE ID = @ID", conn); cmd.Parameters.AddWithValue("@Age", 35); cmd.Parameters.AddWithValue("@ID", 1); int rows = cmd.ExecuteNonQuery(); Console.WriteLine("{0} rows updated", rows);This example shows how to update data in a SQL Server Compact database using the ExecuteNonQuery method. The SqlCommand.Parameters property is used to specify parameter values for the command. Package Library: The package library for this code example is System.Data.SqlServerCe.