SqlCeCommand.ExecuteResultSet メソッド (ResultSetOptions)
CommandText を Connection に送信し、ResultSetOptions を使用して SqlCeResultSet を構築します。
名前空間: System.Data.SqlServerCe
アセンブリ: System.Data.SqlServerCe (System.Data.SqlServerCe.dll)
構文
'宣言
Public Function ExecuteResultSet ( _
options As ResultSetOptions _
) As SqlCeResultSet
'使用
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
)
member ExecuteResultSet :
options:ResultSetOptions -> SqlCeResultSet
public function ExecuteResultSet(
options : ResultSetOptions
) : SqlCeResultSet
パラメーター
- options
型: System.Data.SqlServerCe.ResultSetOptions
ResultSet の構築時に使用する ResultSetOptions。
戻り値
型: System.Data.SqlServerCe.SqlCeResultSet
使用例
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
SqlCeConnection conn = null;
try
{
File.Delete("Test.sdf");
SqlCeEngine engine = new SqlCeEngine("Data Source = Test.sdf");
engine.CreateDatabase();
conn = new SqlCeConnection("Data Source = Test.sdf");
conn.Open();
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "CREATE TABLE myTable (col1 INT, col2 MONEY, col3 NVARCHAR(200))";
cmd.ExecuteNonQuery();
cmd.CommandText = "SELECT * FROM myTable";
SqlCeResultSet rs = cmd.ExecuteResultSet(ResultSetOptions.Updatable |
ResultSetOptions.Scrollable);
SqlCeUpdatableRecord rec = rs.CreateRecord();
rec.SetInt32(0, 34);
rec.SetDecimal(1, (decimal)44.66);
rec.SetString(2, "Sample text");
rs.Insert(rec);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
finally
{
conn.Close();
}