Using SqlCeResultSet

Listing 4.

SqlCeUpdatableRecord newRecord = resultSet.CreateRecord();

newRecord.SetString(1, ".NET Compact Framework Programming with Visual Basic .NET");
newRecord.SetString(2, "Paul Yao");
newRecord.SetString(3, "0321174048");
newRecord.SetInt32(4, 5);

resultSet.Insert(newRecord);