SqlCeCommand.ExecuteResultSet Method (ResultSetOptions)
Sends the CommandText to the Connection and builds a SqlCeResultSet by using the ResultSetOptions.
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
Syntax
'Declaration
Public Function ExecuteResultSet ( _
options As ResultSetOptions _
) As SqlCeResultSet
'Usage
Dim instance As SqlCeCommand
Dim options As ResultSetOptions
Dim returnValue As SqlCeResultSet
returnValue = instance.ExecuteResultSet(options)
public SqlCeResultSet ExecuteResultSet (
ResultSetOptions options
)
public:
SqlCeResultSet^ ExecuteResultSet (
ResultSetOptions options
)
public SqlCeResultSet ExecuteResultSet (
ResultSetOptions options
)
public function ExecuteResultSet (
options : ResultSetOptions
) : SqlCeResultSet
Parameters
- options
The ResultSetOptions to use when building the ResultSet.
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, col2 MONEY, col3 NVARCHAR(200))"
cmd.ExecuteNonQuery()
cmd.CommandText = "SELECT * FROM myTable"
Dim rs As SqlCeResultSet = cmd.ExecuteResultSet(ResultSetOptions.Updatable Or ResultSetOptions.Scrollable)
Dim rec As SqlCeUpdatableRecord = rs.CreateRecord()
rec.SetInt32(0, 34)
rec.SetDecimal(1, System.Convert.ToDecimal(44.66))
rec.SetString(2, "Sample text")
rs.Insert(rec)
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
SqlCeCommand Class
SqlCeCommand Members
System.Data.SqlServerCe Namespace