SqlCeDataAdapter 생성자 (String, String)

SelectCommand와 연결 문자열을 사용하여 SqlCeDataAdapter 클래스의 새 인스턴스를 초기화합니다.

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

구문

‘선언
Public Sub New ( _
    selectCommandText As String, _
    selectConnectionString As String _
)
‘사용 방법
Dim selectCommandText As String
Dim selectConnectionString As String

Dim instance As New SqlCeDataAdapter(selectCommandText, _
    selectConnectionString)

public SqlCeDataAdapter(
    string selectCommandText,
    string selectConnectionString
)

public:
SqlCeDataAdapter(
    String^ selectCommandText, 
    String^ selectConnectionString
)

new : 
        selectCommandText:string * 
        selectConnectionString:string -> SqlCeDataAdapter

public function SqlCeDataAdapter(
    selectCommandText : String, 
    selectConnectionString : String
)

매개 변수

• selectCommandText
  유형: System.String
  SqlCeDataAdapter 에 대한 SelectCommand 속성의 CommandText로 사용될 SQL SELECT 문인 String입니다.

• selectConnectionString
  유형: System.String
  연결 문자열입니다.

주의

SqlCeDataAdapter의 인스턴스를 만들 때는 다음 읽기/쓰기 속성의 초기 값이 아래와 같이 설정됩니다.

해당 속성을 별도로 호출하여 이러한 속성의 값을 변경할 수 있습니다.

예

다음 예제에서는 명령 텍스트와 연결 문자열을 전달하여 SqlCeDataAdapter를 만듭니다.

Public Sub Snippet5()
    ' Create DataAdapter
    '
    Dim adp As New SqlCeDataAdapter("SELECT * FROM products", "Data Source = MyDatabase.sdf")

    Dim cb As New SqlCeCommandBuilder(adp)

    ' Create and fill the dataset (select only first 5 rows)
    '
    Dim ds As New DataSet()
    adp.Fill(ds, 0, 5, "Table")

    ' Modify dataSet
    '
    Dim table As DataTable = ds.Tables("Table")
    table.Rows(1)("Product Name") = "Asian Chai"

    ' Add handlers
    '
    AddHandler adp.RowUpdating, AddressOf OnRowUpdating
    AddHandler adp.RowUpdated, AddressOf OnRowUpdated

    ' Update, this operation fires two events (RowUpdating/RowUpdated)  
    '
    adp.Update(ds, "Table")

    ' Remove handlers
    '
    RemoveHandler adp.RowUpdating, AddressOf OnRowUpdating
    RemoveHandler adp.RowUpdated, AddressOf OnRowUpdated

End Sub 'Snippet5


Private Shared Sub OnRowUpdating(ByVal sender As Object, ByVal e As SqlCeRowUpdatingEventArgs)
    Console.WriteLine("OnRowUpdating")
    Console.WriteLine(e.Command.CommandText)
    Console.WriteLine(e.StatementType)
    Console.WriteLine(e.Status)

End Sub 'OnRowUpdating


Private Shared Sub OnRowUpdated(ByVal sender As Object, ByVal e As SqlCeRowUpdatedEventArgs)
    Console.WriteLine("OnRowUpdated")
    Console.WriteLine(e.Command.CommandText)
    Console.WriteLine(e.StatementType)
    Console.WriteLine(e.Status)

End Sub 'OnRowUpdated

public void Snippet5()
{
    // Create DataAdapter
    //
    SqlCeDataAdapter adp = new SqlCeDataAdapter(
        "SELECT * FROM products",
        "Data Source = MyDatabase.sdf");

    SqlCeCommandBuilder cb = new SqlCeCommandBuilder(adp);

    // Create and fill the dataset (select only first 5 rows)
    //
    DataSet ds = new DataSet();
    adp.Fill(ds, 0, 5, "Table");

    // Modify dataSet
    //
    DataTable table = ds.Tables["Table"];
    table.Rows[1]["Product Name"] = "Asian Chai";

    // Add handlers
    //
    adp.RowUpdating += new SqlCeRowUpdatingEventHandler(OnRowUpdating);
    adp.RowUpdated += new SqlCeRowUpdatedEventHandler(OnRowUpdated);

    // Update, this operation fires two events (RowUpdating/RowUpdated)  
    //
    adp.Update(ds, "Table");

    // Remove handlers
    //
    adp.RowUpdating -= new SqlCeRowUpdatingEventHandler(OnRowUpdating);
    adp.RowUpdated -= new SqlCeRowUpdatedEventHandler(OnRowUpdated);
}

private static void OnRowUpdating(object sender, SqlCeRowUpdatingEventArgs e)
{
    Console.WriteLine("OnRowUpdating");
    Console.WriteLine(e.Command.CommandText);
    Console.WriteLine(e.StatementType);
    Console.WriteLine(e.Status);
}

private static void OnRowUpdated(object sender, SqlCeRowUpdatedEventArgs e)
{
    Console.WriteLine("OnRowUpdated");
    Console.WriteLine(e.Command.CommandText);
    Console.WriteLine(e.StatementType);
    Console.WriteLine(e.Status);
}

참고 항목

참조

SqlCeDataAdapter 클래스

SqlCeDataAdapter 오버로드

System.Data.SqlServerCe 네임스페이스

MissingMappingAction

MissingSchemaAction