SqlCeResultSet.SetString 메서드

지정된 열 값을 전달된 String 값으로 설정합니다.

네임스페이스:  System.Data.SqlServerCe
어셈블리:  System.Data.SqlServerCe(System.Data.SqlServerCe.dll)

구문

‘선언
Public Sub SetString ( _
    ordinal As Integer, _
    value As String _
)
‘사용 방법
Dim instance As SqlCeResultSet
Dim ordinal As Integer
Dim value As String

instance.SetString(ordinal, value)

public void SetString(
    int ordinal,
    string value
)

public:
void SetString(
    int ordinal, 
    String^ value
)

member SetString : 
        ordinal:int * 
        value:string -> unit 

public function SetString(
    ordinal : int, 
    value : String
)

매개 변수

• ordinal
  유형: System.Int32
  설정할 열의 서수 위치입니다.

• value
  유형: System.String
  지정한 열에 할당할 값입니다.

주의

내부 열은 char, nchar, varchar, nvarchar, text 또는 ntext 형식이어야 합니다.

행이 업데이트 가능으로 표시되어 있지 않으면 예외가 throw됩니다.

지정한 위치에 필드가 없으면 예외가 throw됩니다.

예

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

참고 항목

참조

SqlCeResultSet 클래스

System.Data.SqlServerCe 네임스페이스