SqlCeResultSet.SetInt32 Método

Asigna al valor de la columna especificada el valor de tipo Int32 pasado como parámetro.

Espacio de nombres:  System.Data.SqlServerCe
Ensamblado:  System.Data.SqlServerCe (en System.Data.SqlServerCe.dll)

Sintaxis

'Declaración
Public Sub SetInt32 ( _
    ordinal As Integer, _
    value As Integer _
)
'Uso
Dim instance As SqlCeResultSet
Dim ordinal As Integer
Dim value As Integer

instance.SetInt32(ordinal, value)

public void SetInt32(
    int ordinal,
    int value
)

public:
void SetInt32(
    int ordinal, 
    int value
)

member SetInt32 : 
        ordinal:int * 
        value:int -> unit 

public function SetInt32(
    ordinal : int, 
    value : int
)

Parámetros

• ordinal
  Tipo: System.Int32
  Posición ordinal de la columna cuyo valor se va a establecer.

• value
  Tipo: System.Int32
  Valor que se va a asignar a la columna especificada.

Comentarios

La columna subyacente debe ser de tipo int.

Si la fila no está marcada como actualizable, se produce una excepción.

Si no existe ningún campo en la posición especificada, se produce una excepción.

Ejemplos

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()

    ' For optimal performance use base table access
    '
    cmd.CommandText = "myTable"
    cmd.CommandType = CommandType.TableDirect

    Dim rs As SqlCeResultSet = cmd.ExecuteResultSet(ResultSetOptions.Updatable Or ResultSetOptions.Scrollable)

    Dim rec As SqlCeUpdatableRecord = rs.CreateRecord()

    ' Insert two records
    '
    rec.SetInt32(0, 34)
    rec.SetDecimal(1, System.Convert.ToDecimal(44.66))
    rec.SetString(2, "Sample text 1")

    rs.Insert(rec)

    rec.SetInt32(0, 35)
    rec.SetDecimal(1, System.Convert.ToDecimal(94.25))
    rec.SetString(2, "Sample text 2")

    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();

    // For optimal performance use base table access
    //
    cmd.CommandText = "myTable";
    cmd.CommandType = CommandType.TableDirect;

    SqlCeResultSet rs = cmd.ExecuteResultSet(ResultSetOptions.Updatable | 
        ResultSetOptions.Scrollable);

    SqlCeUpdatableRecord rec = rs.CreateRecord();

    // Insert two records
    //
    rec.SetInt32(0, 34);
    rec.SetDecimal(1, (decimal)44.66);
    rec.SetString(2, "Sample text 1");

    rs.Insert(rec);

    rec.SetInt32(0, 35);
    rec.SetDecimal(1, (decimal)94.25);
    rec.SetString(2, "Sample text 2");

    rs.Insert(rec);
}
catch (Exception e)
{
    MessageBox.Show(e.Message);
}
finally
{
    conn.Close();
}

Vea también

Referencia

SqlCeResultSet Clase

Espacio de nombres System.Data.SqlServerCe