SqlCeDataAdapter Constructor (String, String)
SelectCommand와 연결 문자열을 사용하여 SqlCeDataAdapter 클래스의 새 인스턴스를 초기화합니다.
네임스페이스: System.Data.SqlServerCe
어셈블리: System.Data.SqlServerCe(system.data.sqlserverce.dll에 있음)
구문
‘선언
Public Sub New ( _
selectCommandText As String, _
selectConnectionString As String _
)
public SqlCeDataAdapter (
string selectCommandText,
string selectConnectionString
)
public:
SqlCeDataAdapter (
String^ selectCommandText,
String^ selectConnectionString
)
public SqlCeDataAdapter (
String selectCommandText,
String selectConnectionString
)
public function SqlCeDataAdapter (
selectCommandText : String,
selectConnectionString : String
)
매개 변수
- selectCommandText
SqlCeDataAdapter에 대한 SelectCommand 속성의 CommandText로 사용될 SQL SELECT 문인 String입니다.
- selectConnectionString
주의
SqlCeDataAdapter의 인스턴스를 만들 때는 다음 읽기/쓰기 속성의 초기 값이 아래와 같이 설정됩니다.
속성 |
초기 값 |
MissingMappingAction.Passthrough |
|
MissingSchemaAction.Add |
해당 속성을 별도로 호출하여 이러한 속성의 값을 변경할 수 있습니다.
예
다음 예제에서는 명령 텍스트와 연결 문자열을 전달하여 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);
}
플랫폼
개발 플랫폼
Windows Vista, Windows Mobile 5.0, Windows XP Professional with Service Pack 2 (SP2), Windows Server 2003, Windows Mobile 2003 for Pocket PC, Windows CE 5.0
버전 정보
.NET Framework 및 NET Compact Framework
3.5에서 지원됨
.NET Framework
3.0에서 지원됨
.NET Compact Framework 및 .Net Framework
2.0에서 지원됨
참고 항목
참조
SqlCeDataAdapter Class
SqlCeDataAdapter Members
System.Data.SqlServerCe Namespace
MissingMappingAction
MissingSchemaAction