SqlCeResultSet.Update Method
Sends changes from the current record to the underlying row on the server.
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
Syntax
'Declaration
Public Sub Update
'Usage
Dim instance As SqlCeResultSet
instance.Update
public void Update ()
public:
void Update ()
public void Update ()
public function Update ()
Remarks
Throws an InvalidOperation exception if the function is called on a non-updatable reader or if the reader is not positioned on a valid record.
Example
Dim conn As SqlCeConnection = Nothing
Try
File.Delete("Test.sdf")
Dim engine As New SqlCeEngine("Data Source = Test.sdf")
engine.CreateDatabase()
conn = New SqlCeConnection("Data Source = Test.sdf")
conn.Open()
Dim cmd As SqlCeCommand = conn.CreateCommand()
cmd.CommandText = "CREATE TABLE myTable (col1 INT)"
cmd.ExecuteNonQuery()
cmd.CommandText = "SELECT * FROM myTable"
Dim rs As SqlCeResultSet = cmd.ExecuteResultSet(ResultSetOptions.Updatable Or ResultSetOptions.Scrollable)
Dim rec As SqlCeUpdatableRecord = rs.CreateRecord()
' Insert 10 records
'
Dim i As Integer
For i = 0 To 9
rec.SetInt32(0, i)
rs.Insert(rec)
Next i
' Update the 5th record
'
If True = rs.ReadAbsolute(5) Then
rs.SetInt32(0, 55)
rs.Update()
End If
' Delete the 2nd record
'
If True = rs.ReadAbsolute(2) Then
rs.Delete()
End If
Catch e As Exception
MessageBox.Show(e.Message)
Finally
conn.Close()
End Try
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see .
Platforms
Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.
Version Information
.NET Compact Framework
Supported in: 2.0
See Also
Reference
SqlCeResultSet Class
SqlCeResultSet Members
System.Data.SqlServerCe Namespace