Binding Kelas
Definisi
Penting
Beberapa informasi terkait produk prarilis yang dapat diubah secara signifikan sebelum dirilis. Microsoft tidak memberikan jaminan, tersirat maupun tersurat, sehubungan dengan informasi yang diberikan di sini.
Mewakili pengikatan sederhana antara nilai properti objek dan nilai properti kontrol.
public ref class Binding
[System.ComponentModel.TypeConverter(typeof(System.Windows.Forms.ListBindingConverter))]
public class Binding
[<System.ComponentModel.TypeConverter(typeof(System.Windows.Forms.ListBindingConverter))>]
type Binding = class
Public Class Binding
- Warisan
-
Binding
- Atribut
Contoh
Contoh kode berikut membuat Formulir Windows dengan beberapa kontrol yang menunjukkan pengikatan data sederhana. Contoh membuat DataSet dengan dua tabel bernama Customers
dan Orders
, dan bernama DataRelationcustToOrders
. Empat kontrol (a DateTimePicker dan tiga TextBox kontrol) terikat data ke kolom dalam tabel. Untuk setiap kontrol, contoh membuat dan menambahkan Binding ke kontrol melalui DataBindings properti . Contoh mengembalikan BindingManagerBase untuk setiap tabel melalui formulir BindingContext. Empat Button kontrol kenaikan atau penurunan Position properti pada BindingManagerBase objek.
#using <system.dll>
#using <system.data.dll>
#using <system.drawing.dll>
#using <system.windows.forms.dll>
#using <system.xml.dll>
using namespace System;
using namespace System::Data;
using namespace System::Drawing;
using namespace System::Globalization;
using namespace System::Windows::Forms;
#define null 0L
public ref class Form1: public Form
{
private:
System::ComponentModel::Container^ components;
Button^ button1;
Button^ button2;
Button^ button3;
Button^ button4;
TextBox^ text1;
TextBox^ text2;
TextBox^ text3;
BindingManagerBase^ bmCustomers;
BindingManagerBase^ bmOrders;
DataSet^ ds;
DateTimePicker^ DateTimePicker1;
public:
Form1()
{
// Required for Windows Form Designer support.
InitializeComponent();
// Call SetUp to bind the controls.
SetUp();
}
private:
void InitializeComponent()
{
// Create the form and its controls.
this->components = gcnew System::ComponentModel::Container;
this->button1 = gcnew Button;
this->button2 = gcnew Button;
this->button3 = gcnew Button;
this->button4 = gcnew Button;
this->text1 = gcnew TextBox;
this->text2 = gcnew TextBox;
this->text3 = gcnew TextBox;
this->DateTimePicker1 = gcnew DateTimePicker;
this->Text = "Binding Sample";
this->ClientSize = System::Drawing::Size( 450, 200 );
button1->Location = System::Drawing::Point( 24, 16 );
button1->Size = System::Drawing::Size( 64, 24 );
button1->Text = "<";
button1->Click += gcnew System::EventHandler( this, &Form1::button1_Click );
button2->Location = System::Drawing::Point( 90, 16 );
button2->Size = System::Drawing::Size( 64, 24 );
button2->Text = ">";
button2->Click += gcnew System::EventHandler( this, &Form1::button2_Click );
button3->Location = System::Drawing::Point( 90, 100 );
button3->Size = System::Drawing::Size( 64, 24 );
button3->Text = "<";
button3->Click += gcnew System::EventHandler( this, &Form1::button3_Click );
button4->Location = System::Drawing::Point( 150, 100 );
button4->Size = System::Drawing::Size( 64, 24 );
button4->Text = ">";
button4->Click += gcnew System::EventHandler( this, &Form1::button4_Click );
text1->Location = System::Drawing::Point( 24, 50 );
text1->Size = System::Drawing::Size( 150, 24 );
text2->Location = System::Drawing::Point( 190, 50 );
text2->Size = System::Drawing::Size( 150, 24 );
text3->Location = System::Drawing::Point( 290, 150 );
text3->Size = System::Drawing::Size( 150, 24 );
DateTimePicker1->Location = System::Drawing::Point( 90, 150 );
DateTimePicker1->Size = System::Drawing::Size( 200, 800 );
this->Controls->Add( button1 );
this->Controls->Add( button2 );
this->Controls->Add( button3 );
this->Controls->Add( button4 );
this->Controls->Add( text1 );
this->Controls->Add( text2 );
this->Controls->Add( text3 );
this->Controls->Add( DateTimePicker1 );
}
public:
~Form1()
{
if ( components != nullptr )
{
delete components;
}
}
private:
void SetUp()
{
// Create a DataSet with two tables and one relation.
MakeDataSet();
BindControls();
}
protected:
void BindControls()
{
/* Create two Binding objects for the first two TextBox
controls. The data-bound property for both controls
is the Text property. The data source is a DataSet
(ds). The data member is the
"TableName.ColumnName" string. */
text1->DataBindings->Add( gcnew Binding( "Text",ds,"customers.custName" ) );
text2->DataBindings->Add( gcnew Binding( "Text",ds,"customers.custID" ) );
/* Bind the DateTimePicker control by adding a new Binding.
The data member of the DateTimePicker is a
TableName.RelationName.ColumnName string. */
DateTimePicker1->DataBindings->Add( gcnew Binding( "Value",ds,"customers.CustToOrders.OrderDate" ) );
/* Add event delegates for the Parse and Format events to a
new Binding object, and add the object to the third
TextBox control's BindingsCollection. The delegates
must be added before adding the Binding to the
collection; otherwise, no formatting occurs until
the Current object of the BindingManagerBase for
the data source changes. */
Binding^ b = gcnew Binding( "Text",ds,"customers.custToOrders.OrderAmount" );
b->Parse += gcnew ConvertEventHandler( this, &Form1::CurrencyStringToDecimal );
b->Format += gcnew ConvertEventHandler( this, &Form1::DecimalToCurrencyString );
text3->DataBindings->Add( b );
// Get the BindingManagerBase for the Customers table.
bmCustomers = this->BindingContext[ ds, "Customers" ];
/* Get the BindingManagerBase for the Orders table using the
RelationName. */
bmOrders = this->BindingContext[ ds, "customers.CustToOrders" ];
}
private:
void DecimalToCurrencyString( Object^ /*sender*/, ConvertEventArgs^ cevent )
{
/* This method is the Format event handler. Whenever the
control displays a new value, the value is converted from
its native Decimal type to a string. The ToString method
then formats the value as a Currency, by using the
formatting character "c". */
// The application can only convert to string type.
if ( cevent->DesiredType != String::typeid )
return;
cevent->Value = (dynamic_cast<Decimal^>(cevent->Value))->ToString( "c" );
}
void CurrencyStringToDecimal( Object^ /*sender*/, ConvertEventArgs^ cevent )
{
/* This method is the Parse event handler. The Parse event
occurs whenever the displayed value changes. The static
ToDecimal method of the Convert class converts the
value back to its native Decimal type. */
// Can only convert to Decimal type.
if ( cevent->DesiredType != Decimal::typeid )
return;
cevent->Value = Decimal::Parse( cevent->Value->ToString(), NumberStyles::Currency, nullptr );
/* To see that no precision is lost, print the unformatted
value. For example, changing a value to "10.0001"
causes the control to display "10.00", but the
unformatted value remains "10.0001". */
Console::WriteLine( cevent->Value );
}
private:
void button1_Click( Object^ /*sender*/, System::EventArgs^ /*e*/ )
{
// Go to the previous item in the Customer list.
bmCustomers->Position -= 1;
}
void button2_Click( Object^ /*sender*/, System::EventArgs^ /*e*/ )
{
// Go to the next item in the Customer list.
bmCustomers->Position += 1;
}
void button3_Click( Object^ /*sender*/, System::EventArgs^ /*e*/ )
{
// Go to the previous item in the Orders list.
bmOrders->Position = bmOrders->Position - 1;
}
void button4_Click( Object^ /*sender*/, System::EventArgs^ /*e*/ )
{
// Go to the next item in the Orders list.
bmOrders->Position = bmOrders->Position + 1;
}
private:
// Create a DataSet with two tables and populate it.
void MakeDataSet()
{
// Create a DataSet.
ds = gcnew DataSet( "myDataSet" );
// Create two DataTables.
DataTable^ tCust = gcnew DataTable( "Customers" );
DataTable^ tOrders = gcnew DataTable( "Orders" );
// Create two columns, and add them to the first table.
DataColumn^ cCustID = gcnew DataColumn( "CustID",Int32::typeid );
DataColumn^ cCustName = gcnew DataColumn( "CustName" );
tCust->Columns->Add( cCustID );
tCust->Columns->Add( cCustName );
// Create three columns, and add them to the second table.
DataColumn^ cID = gcnew DataColumn( "CustID",Int32::typeid );
DataColumn^ cOrderDate = gcnew DataColumn( "orderDate",DateTime::typeid );
DataColumn^ cOrderAmount = gcnew DataColumn( "OrderAmount",Decimal::typeid );
tOrders->Columns->Add( cOrderAmount );
tOrders->Columns->Add( cID );
tOrders->Columns->Add( cOrderDate );
// Add the tables to the DataSet.
ds->Tables->Add( tCust );
ds->Tables->Add( tOrders );
// Create a DataRelation, and add it to the DataSet.
DataRelation^ dr = gcnew DataRelation( "custToOrders",cCustID,cID );
ds->Relations->Add( dr );
/* Populate the tables. For each customer and order,
create two DataRow variables. */
DataRow^ newRow1; // = new DataRow();
DataRow^ newRow2; // = new DataRow();
// Create three customers in the Customers Table.
for ( int i = 1; i < 4; i++ )
{
newRow1 = tCust->NewRow();
newRow1[ "custID" ] = i;
// Add the row to the Customers table.
tCust->Rows->Add( newRow1 );
}
tCust->Rows[ 0 ][ "custName" ] = "Alpha";
tCust->Rows[ 1 ][ "custName" ] = "Beta";
tCust->Rows[ 2 ][ "custName" ] = "Omega";
// For each customer, create five rows in the Orders table.
for ( int i = 1; i < 4; i++ )
{
for ( int j = 1; j < 6; j++ )
{
newRow2 = tOrders->NewRow();
newRow2[ "CustID" ] = i;
newRow2[ "orderDate" ] = System::DateTime( 2001, i, j * 2 );
newRow2[ "OrderAmount" ] = i * 10 + j * .1;
// Add the row to the Orders table.
tOrders->Rows->Add( newRow2 );
}
}
}
};
int main()
{
Application::Run( gcnew Form1 );
}
using System;
using System.Data;
using System.Drawing;
using System.Globalization;
using System.Windows.Forms;
public class Form1 : System.Windows.Forms.Form
{
private System.ComponentModel.Container components;
private Button button1;
private Button button2;
private Button button3;
private Button button4;
private TextBox text1;
private TextBox text2;
private TextBox text3;
private BindingManagerBase bmCustomers;
private BindingManagerBase bmOrders;
private DataSet ds;
private DateTimePicker DateTimePicker1;
public Form1()
{
// Required for Windows Form Designer support.
InitializeComponent();
// Call SetUp to bind the controls.
SetUp();
}
private void InitializeComponent()
{
// Create the form and its controls.
this.components = new System.ComponentModel.Container();
this.button1 = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
this.button3 = new System.Windows.Forms.Button();
this.button4 = new System.Windows.Forms.Button();
this.text1= new System.Windows.Forms.TextBox();
this.text2= new System.Windows.Forms.TextBox();
this.text3= new System.Windows.Forms.TextBox();
this.DateTimePicker1 = new DateTimePicker();
this.Text = "Binding Sample";
this.ClientSize = new System.Drawing.Size(450, 200);
button1.Location = new System.Drawing.Point(24, 16);
button1.Size = new System.Drawing.Size(64, 24);
button1.Text = "<";
button1.Click+=new System.EventHandler(button1_Click);
button2.Location = new System.Drawing.Point(90, 16);
button2.Size = new System.Drawing.Size(64, 24);
button2.Text = ">";
button2.Click+=new System.EventHandler(button2_Click);
button3.Location = new System.Drawing.Point(90, 100);
button3.Size = new System.Drawing.Size(64, 24);
button3.Text = "<";
button3.Click+=new System.EventHandler(button3_Click);
button4.Location = new System.Drawing.Point(150, 100);
button4.Size = new System.Drawing.Size(64, 24);
button4.Text = ">";
button4.Click+=new System.EventHandler(button4_Click);
text1.Location = new System.Drawing.Point(24, 50);
text1.Size = new System.Drawing.Size(150, 24);
text2.Location = new System.Drawing.Point(190, 50);
text2.Size = new System.Drawing.Size(150, 24);
text3.Location = new System.Drawing.Point(290, 150);
text3.Size = new System.Drawing.Size(150, 24);
DateTimePicker1.Location = new System.Drawing.Point(90, 150);
DateTimePicker1.Size = new System.Drawing.Size(200, 800);
this.Controls.Add(button1);
this.Controls.Add(button2);
this.Controls.Add(button3);
this.Controls.Add(button4);
this.Controls.Add(text1);
this.Controls.Add(text2);
this.Controls.Add(text3);
this.Controls.Add(DateTimePicker1);
}
protected override void Dispose( bool disposing ){
if( disposing ){
if (components != null){
components.Dispose();}
}
base.Dispose( disposing );
}
public static void Main()
{
Application.Run(new Form1());
}
private void SetUp()
{
// Create a DataSet with two tables and one relation.
MakeDataSet();
BindControls();
}
protected void BindControls()
{
/* Create two Binding objects for the first two TextBox
controls. The data-bound property for both controls
is the Text property. The data source is a DataSet
(ds). The data member is the
"TableName.ColumnName" string. */
text1.DataBindings.Add(new Binding
("Text", ds, "customers.custName"));
text2.DataBindings.Add(new Binding
("Text", ds, "customers.custID"));
/* Bind the DateTimePicker control by adding a new Binding.
The data member of the DateTimePicker is a
TableName.RelationName.ColumnName string. */
DateTimePicker1.DataBindings.Add(new
Binding("Value", ds, "customers.CustToOrders.OrderDate"));
/* Add event delegates for the Parse and Format events to a
new Binding object, and add the object to the third
TextBox control's BindingsCollection. The delegates
must be added before adding the Binding to the
collection; otherwise, no formatting occurs until
the Current object of the BindingManagerBase for
the data source changes. */
Binding b = new Binding
("Text", ds, "customers.custToOrders.OrderAmount");
b.Parse+=new ConvertEventHandler(CurrencyStringToDecimal);
b.Format+=new ConvertEventHandler(DecimalToCurrencyString);
text3.DataBindings.Add(b);
// Get the BindingManagerBase for the Customers table.
bmCustomers = this.BindingContext [ds, "Customers"];
/* Get the BindingManagerBase for the Orders table using the
RelationName. */
bmOrders = this.BindingContext[ds, "customers.CustToOrders"];
}
private void DecimalToCurrencyString(object sender, ConvertEventArgs cevent)
{
/* This method is the Format event handler. Whenever the
control displays a new value, the value is converted from
its native Decimal type to a string. The ToString method
then formats the value as a Currency, by using the
formatting character "c". */
// The application can only convert to string type.
if(cevent.DesiredType != typeof(string)) return;
cevent.Value = ((decimal) cevent.Value).ToString("c");
}
private void CurrencyStringToDecimal(object sender, ConvertEventArgs cevent)
{
/* This method is the Parse event handler. The Parse event
occurs whenever the displayed value changes. The static
ToDecimal method of the Convert class converts the
value back to its native Decimal type. */
// Can only convert to decimal type.
if(cevent.DesiredType != typeof(decimal)) return;
cevent.Value = Decimal.Parse(cevent.Value.ToString(),
NumberStyles.Currency, null);
/* To see that no precision is lost, print the unformatted
value. For example, changing a value to "10.0001"
causes the control to display "10.00", but the
unformatted value remains "10.0001". */
Console.WriteLine(cevent.Value);
}
private void button1_Click(object sender, System.EventArgs e)
{
// Go to the previous item in the Customer list.
bmCustomers.Position -= 1;
}
private void button2_Click(object sender, System.EventArgs e)
{
// Go to the next item in the Customer list.
bmCustomers.Position += 1;
}
private void button3_Click(object sender, System.EventArgs e)
{
// Go to the previous item in the Orders list.
bmOrders.Position-=1;
}
private void button4_Click(object sender, System.EventArgs e)
{
// Go to the next item in the Orders list.
bmOrders.Position+=1;
}
// Create a DataSet with two tables and populate it.
private void MakeDataSet()
{
// Create a DataSet.
ds = new DataSet("myDataSet");
// Create two DataTables.
DataTable tCust = new DataTable("Customers");
DataTable tOrders = new DataTable("Orders");
// Create two columns, and add them to the first table.
DataColumn cCustID = new DataColumn("CustID", typeof(int));
DataColumn cCustName = new DataColumn("CustName");
tCust.Columns.Add(cCustID);
tCust.Columns.Add(cCustName);
// Create three columns, and add them to the second table.
DataColumn cID =
new DataColumn("CustID", typeof(int));
DataColumn cOrderDate =
new DataColumn("orderDate",typeof(DateTime));
DataColumn cOrderAmount =
new DataColumn("OrderAmount", typeof(decimal));
tOrders.Columns.Add(cOrderAmount);
tOrders.Columns.Add(cID);
tOrders.Columns.Add(cOrderDate);
// Add the tables to the DataSet.
ds.Tables.Add(tCust);
ds.Tables.Add(tOrders);
// Create a DataRelation, and add it to the DataSet.
DataRelation dr = new DataRelation
("custToOrders", cCustID , cID);
ds.Relations.Add(dr);
/* Populate the tables. For each customer and order,
create two DataRow variables. */
DataRow newRow1;
DataRow newRow2;
// Create three customers in the Customers Table.
for(int i = 1; i < 4; i++)
{
newRow1 = tCust.NewRow();
newRow1["custID"] = i;
// Add the row to the Customers table.
tCust.Rows.Add(newRow1);
}
// Give each customer a distinct name.
tCust.Rows[0]["custName"] = "Alpha";
tCust.Rows[1]["custName"] = "Beta";
tCust.Rows[2]["custName"] = "Omega";
// For each customer, create five rows in the Orders table.
for(int i = 1; i < 4; i++)
{
for(int j = 1; j < 6; j++)
{
newRow2 = tOrders.NewRow();
newRow2["CustID"]= i;
newRow2["orderDate"]= new DateTime(2001, i, j * 2);
newRow2["OrderAmount"] = i * 10 + j * .1;
// Add the row to the Orders table.
tOrders.Rows.Add(newRow2);
}
}
}
}
Imports System.ComponentModel
Imports System.Data
Imports System.Drawing
Imports System.Globalization
Imports System.Windows.Forms
Public Class Form1
Inherits Form
Private components As Container
Private button1 As Button
Private button2 As Button
Private button3 As Button
Private button4 As Button
Private text1 As TextBox
Private text2 As TextBox
Private text3 As TextBox
Private bmCustomers As BindingManagerBase
Private bmOrders As BindingManagerBase
Private ds As DataSet
Private DateTimePicker1 As DateTimePicker
Public Sub New
' Required for Windows Form Designer support.
InitializeComponent
' Call SetUp to bind the controls.
SetUp
End Sub
Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
If disposing Then
If (components IsNot Nothing) Then
components.Dispose()
End If
End If
MyBase.Dispose(disposing)
End Sub
Private Sub InitializeComponent
' Create the form and its controls.
With Me
.components = New Container
.button1 = New Button
.button2 = New Button
.button3 = New Button
.button4 = New Button
.text1 = New TextBox
.text2 = New TextBox
.text3 = New TextBox
.DateTimePicker1 = New DateTimePicker
.Text = "Binding Sample"
.ClientSize = New Size(450, 200)
With .button1
.Location = New Point(24, 16)
.Size = New Size(64, 24)
.Text = "<"
AddHandler button1.click, AddressOf button1_Click
End With
With .button2
.Location = New Point(90, 16)
.Size = New Size(64, 24)
.Text = ">"
AddHandler button2.click, AddressOf button2_Click
End With
With .button3
.Location = New Point(90, 100)
.Size = New Size(64, 24)
.Text = ">"
AddHandler button3.click, AddressOf button3_Click
End With
With .button4
.Location = New Point(150, 100)
.Size = New Size(64, 24)
.Text = ">"
AddHandler button4.click, AddressOf button4_Click
End With
With .text1
.Location = New Point(24, 50)
.Size = New Size(150, 24)
End With
With .text2
.Location = New Point(190, 50)
.Size = New Size(150, 24)
End With
With .text3
.Location = New Point(290, 150)
.Size = New Size(150, 24)
End With
With .DateTimePicker1
.Location = New Point(90, 150)
.Size = New Size(200, 800)
End With
With .Controls
.Add(button1)
.Add(button2)
.Add(button3)
.Add(button4)
.Add(text1)
.Add(text2)
.Add(text3)
.Add(DateTimePicker1)
End With
End With
End Sub
Public Shared Sub Main
Application.Run(new Form1)
End Sub
Private Sub SetUp
' Create a DataSet with two tables and one relation.
MakeDataSet
BindControls
End Sub
Private Sub BindControls
' Create two Binding objects for the first two TextBox
' controls. The data-bound property for both controls
' is the Text property. The data source is a DataSet
' (ds). The data member is the
' TableName.ColumnName" string.
text1.DataBindings.Add(New _
Binding("Text", ds, "customers.custName"))
text2.DataBindings.Add(New _
Binding("Text", ds, "customers.custID"))
' Bind the DateTimePicker control by adding a new Binding.
' The data member of the DateTimePicker is a
' TableName.RelationName.ColumnName string
DateTimePicker1.DataBindings.Add(New _
Binding("Value", ds, "customers.CustToOrders.OrderDate"))
' Add event delegates for the Parse and Format events to a
' new Binding object, and add the object to the third
' TextBox control's BindingsCollection. The delegates
' must be added before adding the Binding to the
' collection; otherwise, no formatting occurs until
' the Current object of the BindingManagerBase for
' the data source changes.
Dim b As Binding = New _
Binding("Text", ds, "customers.custToOrders.OrderAmount")
AddHandler b.Parse, AddressOf CurrencyStringToDecimal
AddHandler b.Format, AddressOf DecimalToCurrencyString
text3.DataBindings.Add(b)
' Get the BindingManagerBase for the Customers table.
bmCustomers = Me.BindingContext(ds, "Customers")
' Get the BindingManagerBase for the Orders table using the
' RelationName.
bmOrders = Me.BindingContext(ds, "customers.CustToOrders")
End Sub
Private Sub DecimalToCurrencyString(sender As Object, cevent As ConvertEventArgs)
' This method is the Format event handler. Whenever the
' control displays a new value, the value is converted from
' its native Decimal type to a string. The ToString method
' then formats the value as a Currency, by using the
' formatting character "c".
' The application can only convert to string type.
If cevent.DesiredType IsNot GetType(String) Then
Exit Sub
End If
cevent.Value = CType(cevent.Value, decimal).ToString("c")
End Sub
Private Sub CurrencyStringToDecimal(sender As Object, cevent As ConvertEventArgs)
' This method is the Parse event handler. The Parse event
' occurs whenever the displayed value changes. The static
' ToDecimal method of the Convert class converts the
' value back to its native Decimal type.
' Can only convert to decimal type.
If cevent.DesiredType IsNot GetType(decimal) Then
Exit Sub
End If
cevent.Value = Decimal.Parse(cevent.Value.ToString, _
NumberStyles.Currency, nothing)
' To see that no precision is lost, print the unformatted
' value. For example, changing a value to "10.0001"
' causes the control to display "10.00", but the
' unformatted value remains "10.0001".
Console.WriteLine(cevent.Value)
End Sub
Private Sub button1_Click(sender As Object, e As System.EventArgs)
' Go to the previous item in the Customer list.
bmCustomers.Position -= 1
End Sub
Private Sub button2_Click(sender As Object, e As System.EventArgs)
' Go to the next item in the Customer list.
bmCustomers.Position += 1
End Sub
Private Sub button3_Click(sender As Object, e As System.EventArgs)
' Go to the previous item in the Order list.
bmOrders.Position -= 1
End Sub
Private Sub button4_Click(sender As Object, e As System.EventArgs)
' Go to the next item in the Orders list.
bmOrders.Position += 1
End Sub
' Creates a DataSet with two tables and populates it.
Private Sub MakeDataSet
' Create a DataSet.
ds = New DataSet("myDataSet")
' Creates two DataTables.
Dim tCust As DataTable = New DataTable("Customers")
Dim tOrders As DataTable = New DataTable("Orders")
' Create two columns, and add them to the first table.
Dim cCustID As DataColumn = New DataColumn("CustID", _
System.Type.GetType("System.Int32"))
Dim cCustName As DataColumn = New DataColumn("CustName")
tCust.Columns.Add(cCustID)
tCust.Columns.Add(cCustName)
' Create three columns, and add them to the second table.
Dim cID As DataColumn = _
New DataColumn("CustID", System.Type.GetType("System.Int32"))
Dim cOrderDate As DataColumn = _
New DataColumn("orderDate", System.Type.GetType("System.DateTime"))
Dim cOrderAmount As DataColumn = _
New DataColumn("OrderAmount", System.Type.GetType("System.Decimal"))
tOrders.Columns.Add(cOrderAmount)
tOrders.Columns.Add(cID)
tOrders.Columns.Add(cOrderDate)
' Add the tables to the DataSet.
ds.Tables.Add(tCust)
ds.Tables.Add(tOrders)
' Create a DataRelation, and add it to the DataSet.
Dim dr As DataRelation = New _
DataRelation("custToOrders", cCustID, cID)
ds.Relations.Add(dr)
' Populate the tables. For each customer and orders,
' create two DataRow variables.
Dim newRow1 As DataRow
Dim newRow2 As DataRow
' Create three customers in the Customers Table.
Dim i As Integer
For i = 1 to 3
newRow1 = tCust.NewRow
newRow1("custID") = i
' Adds the row to the Customers table.
tCust.Rows.Add(newRow1)
Next
' Give each customer a distinct name.
tCust.Rows(0)("custName") = "Alpha"
tCust.Rows(1)("custName") = "Beta"
tCust.Rows(2)("custName") = "Omega"
' For each customer, create five rows in the Orders table.
Dim j As Integer
For i = 1 to 3
For j = 1 to 5
newRow2 = tOrders.NewRow
newRow2("CustID") = i
newRow2("orderDate") = New DateTime(2001, i, j * 2)
newRow2("OrderAmount") = i * 10 + j * .1
' Add the row to the Orders table.
tOrders.Rows.Add(newRow2)
Next
Next
End Sub
End Class
Keterangan
Binding Gunakan kelas untuk membuat dan mempertahankan pengikatan sederhana antara properti kontrol dan properti objek, atau properti objek saat ini dalam daftar objek.
Sebagai contoh kasus pertama, Anda dapat mengikat Text properti TextBox kontrol ke FirstName
properti Customer
objek. Sebagai contoh kasus kedua, Anda dapat mengikat Text properti TextBox kontrol ke FirstName
properti yang DataTable berisi pelanggan.
Kelas ini Binding juga memungkinkan Anda memformat nilai untuk ditampilkan melalui Format peristiwa dan mengambil nilai yang diformat melalui Parse peristiwa.
Saat membuat Binding instans dengan Binding konstruktor, Anda harus menentukan tiga item:
Nama properti kontrol yang akan diikat.
Sumber data.
Jalur navigasi yang diselesaikan ke daftar atau properti di sumber data. Jalur navigasi juga digunakan untuk membuat properti objek BindingMemberInfo .
Pertama, Anda harus menentukan nama properti kontrol yang ingin Anda ikat datanya. Misalnya, untuk menampilkan data dalam TextBox kontrol, tentukan Text properti .
Kedua, Anda dapat menentukan instans salah satu kelas dalam tabel berikut sebagai sumber data.
Deskripsi | C# contoh |
---|---|
Kelas apa pun yang mengimplementasikan IBindingList atau ITypedList. Ini termasuk yang berikut: DataSet, , DataViewDataTable, atau DataViewManager. | DataSet ds = new DataSet("myDataSet"); |
Kelas apa pun yang mengimplementasikan IList untuk membuat koleksi objek yang diindeks. Koleksi harus dibuat dan diisi sebelum membuat Binding. Semua objek dalam daftar harus memiliki jenis yang sama; jika tidak, pengecualian akan dilemparkan. | ArrayList ar1 = new ArrayList; Customer1 cust1 = new Customer("Louis"); ar1.Add(cust1); |
Jenis yang sangat IList kuat dari objek yang sangat di ketik | Customer [] custList = new Customer[3]; |
Ketiga, Anda harus menentukan jalur navigasi, yang dapat berupa string kosong (""), satu nama properti, atau hierarki nama yang dibatasi titik. Jika Anda mengatur jalur navigasi ke string kosong, ToString metode akan dipanggil pada objek sumber data yang mendasar.
Jika sumber data adalah DataTable, yang dapat berisi beberapa DataColumn objek, jalur navigasi harus digunakan untuk mengatasi kolom tertentu.
Catatan
Ketika sumber data adalah DataSet, , DataViewManageratau DataTable, Anda benar-benar mengikat ke DataView. Akibatnya, baris terikat sebenarnya DataRowView adalah objek.
Jalur navigasi yang dibatasi periode diperlukan saat sumber data diatur ke objek yang berisi beberapa DataTable objek (seperti DataSet atau DataViewManager). Anda juga dapat menggunakan jalur navigasi yang dibatasi periode saat Anda mengikat objek yang propertinya mengembalikan referensi ke objek lain (seperti kelas dengan properti yang mengembalikan objek kelas lainnya). Misalnya, jalur navigasi berikut ini menjelaskan semua bidang data yang valid:
"Size.Height"
"Suppliers.CompanyName"
"Regions.regionsToCustomers.CustomerFirstName"
"Regions.regionsToCustomers.customersToOrders.ordersToDetails.Quantity"
Setiap anggota jalur dapat mengembalikan properti yang diselesaikan ke satu nilai (seperti bilangan bulat), atau daftar nilai (seperti array string). Meskipun setiap anggota di jalur dapat menjadi daftar atau properti, anggota akhir harus menyelesaikan ke properti . Setiap anggota dibangun pada anggota sebelumnya: "Size.Height" menyelesaikan ke Height properti untuk saat ini Size; "Regions.regionsToCustomers.CustomerFirstName" menetapkan nama depan untuk pelanggan saat ini, di mana pelanggan adalah salah satu pelanggan untuk wilayah saat ini.
DataRelation mengembalikan daftar nilai dengan menautkan satu DataTable ke detik DataTable dalam .DataSet DataSet Jika berisi DataRelation objek, Anda dapat menentukan anggota data sebagai TableName diikuti oleh RelationName, lalu ColumnName. Misalnya, jika DataTable "Pemasok" bernama berisi DataRelation "suppliers2products", anggota data dapat menjadi "Suppliers.suppliers2products.ProductName".
Sumber data dapat terdiri dari sekumpulan kelas terkait. Misalnya, bayangkan sekumpulan kelas yang membuat katalog sistem surya. Kelas bernama System
berisi properti bernama Stars
yang mengembalikan kumpulan Star
objek. Setiap Star
objek memiliki Name
properti dan Mass
, serta Planets
properti yang mengembalikan kumpulan Planet
objek. Dalam sistem ini, setiap planet juga memiliki Mass
properti dan Name
. Setiap Planet
objek selanjutnya memiliki Moons
properti yang mengembalikan kumpulan Moon
objek, yang masing-masing juga memiliki Name
properti dan Mass
. Jika Anda menentukan System
objek sebagai sumber data, Anda bisa menentukan salah satu hal berikut ini sebagai anggota data:
"Stars.Name"
"Stars.Mass"
"Stars.Planets.Name"
"Stars.Planets.Mass"
"Stars.Planets.Moons.Name"
"Stars.Planets.Moons.Mass"
Kontrol yang dapat terikat sederhana menampilkan kumpulan Binding objek dalam ControlBindingsCollection, yang dapat Anda akses melalui properti kontrol DataBindings . Anda menambahkan Binding ke koleksi dengan memanggil Add metode , sehingga mengikat properti kontrol ke properti objek (atau ke properti objek saat ini dalam daftar).
Anda dapat mengikat dengan sederhana ke objek apa pun yang berasal dari System.Windows.Forms.Control kelas, misalnya, kontrol Windows berikut:
Catatan
SelectedValue Hanya properti kontrol ComboBox, CheckedListBox, dan ListBox yang terikat sederhana.
Kelas BindingManagerBase adalah kelas abstrak yang mengelola semua Binding objek untuk sumber data dan anggota data tertentu. Kelas yang berasal dari BindingManagerBase adalah CurrencyManager kelas dan PropertyManager . Binding Bagaimana dikelola tergantung pada apakah Binding itu pengikatan daftar atau pengikatan properti. Misalnya, jika itu adalah pengikatan daftar, Anda dapat menggunakan BindingManagerBase untuk menentukan Position dalam daftar; Position, oleh karena itu, menentukan item mana (dari semua item dalam daftar) benar-benar terikat ke kontrol. Untuk mengembalikan yang sesuai BindingManagerBase, gunakan BindingContext.
Untuk menambahkan baris baru ke sekumpulan kontrol yang terikat ke yang sama DataSource, gunakan AddNew metode BindingManagerBase kelas . Item[] Gunakan properti BindingContext kelas untuk mengembalikan yang sesuaiCurrencyManager. Untuk menghindari penambahan baris baru, gunakan CancelCurrentEdit metode .
Konstruktor
Binding(String, Object, String) |
Menginisialisasi instans Binding baru kelas yang mengikat properti kontrol yang ditunjukkan dengan anggota data sumber data yang ditentukan. |
Binding(String, Object, String, Boolean) |
Menginisialisasi instans Binding baru kelas yang mengikat properti kontrol yang ditunjukkan ke anggota data sumber data yang ditentukan, dan secara opsional memungkinkan pemformatan diterapkan. |
Binding(String, Object, String, Boolean, DataSourceUpdateMode) |
Menginisialisasi instans Binding baru kelas yang mengikat properti kontrol yang ditentukan ke anggota data yang ditentukan dari sumber data yang ditentukan. Secara opsional memungkinkan pemformatan dan menyebarkan nilai ke sumber data berdasarkan pengaturan pembaruan yang ditentukan. |
Binding(String, Object, String, Boolean, DataSourceUpdateMode, Object) |
Menginisialisasi instans Binding baru kelas yang mengikat properti kontrol yang ditunjukkan ke anggota data yang ditentukan dari sumber data yang ditentukan. Secara opsional mengaktifkan pemformatan, menyebarkan nilai ke sumber data berdasarkan pengaturan pembaruan yang ditentukan, dan mengatur properti ke nilai yang ditentukan saat DBNull dikembalikan dari sumber data. |
Binding(String, Object, String, Boolean, DataSourceUpdateMode, Object, String) |
Menginisialisasi instans Binding baru kelas yang mengikat properti kontrol yang ditentukan ke anggota data yang ditentukan dari sumber data yang ditentukan. Secara opsional mengaktifkan pemformatan dengan string format yang ditentukan; menyebarkan nilai ke sumber data berdasarkan pengaturan pembaruan yang ditentukan; dan mengatur properti ke nilai yang ditentukan saat DBNull dikembalikan dari sumber data. |
Binding(String, Object, String, Boolean, DataSourceUpdateMode, Object, String, IFormatProvider) |
Menginisialisasi instans Binding baru kelas dengan properti kontrol yang ditentukan ke anggota data yang ditentukan dari sumber data yang ditentukan. Secara opsional mengaktifkan pemformatan dengan string format yang ditentukan; menyebarkan nilai ke sumber data berdasarkan pengaturan pembaruan yang ditentukan; mengaktifkan pemformatan dengan string format yang ditentukan; mengatur properti ke nilai yang ditentukan saat DBNull dikembalikan dari sumber data; dan mengatur penyedia format yang ditentukan. |
Properti
BindableComponent |
Mendapatkan kontrol yang Binding terkait dengan. |
BindingManagerBase |
BindingManagerBase Mendapatkan untuk iniBinding. |
BindingMemberInfo |
Mendapatkan objek yang berisi informasi tentang pengikatan ini berdasarkan |
Control |
Mendapatkan kontrol yang dimiliki pengikatan. |
ControlUpdateMode |
Mendapatkan atau mengatur ketika perubahan pada sumber data disebarkan ke properti kontrol terikat. |
DataSource |
Mendapatkan sumber data untuk pengikatan ini. |
DataSourceNullValue |
Mendapatkan atau mengatur nilai yang akan disimpan di sumber data jika nilai kontrol atau |
DataSourceUpdateMode |
Mendapatkan atau menetapkan nilai yang menunjukkan kapan perubahan pada properti kontrol terikat disebarluaskan ke sumber data. |
FormatInfo |
Mendapatkan atau mengatur IFormatProvider yang menyediakan perilaku pemformatan kustom. |
FormatString |
Mendapatkan atau mengatur karakter penentu format yang menunjukkan bagaimana nilai akan ditampilkan. |
FormattingEnabled |
Mendapatkan atau mengatur nilai yang menunjukkan apakah konversi jenis dan pemformatan diterapkan ke data properti kontrol. |
IsBinding |
Mendapatkan nilai yang menunjukkan apakah pengikatan aktif. |
NullValue |
Mendapatkan atau mengatur Object untuk diatur sebagai properti kontrol saat sumber data berisi DBNull nilai. |
PropertyName |
Mendapatkan nama properti terikat data kontrol. |
Metode
Equals(Object) |
Menentukan apakah objek yang ditentukan sama dengan objek saat ini. (Diperoleh dari Object) |
GetHashCode() |
Berfungsi sebagai fungsi hash default. (Diperoleh dari Object) |
GetType() |
Mendapatkan dari instans Type saat ini. (Diperoleh dari Object) |
MemberwiseClone() |
Membuat salinan dangkal dari saat ini Object. (Diperoleh dari Object) |
OnBindingComplete(BindingCompleteEventArgs) |
Memunculkan kejadian BindingComplete. |
OnFormat(ConvertEventArgs) |
Memunculkan kejadian Format. |
OnParse(ConvertEventArgs) |
Memunculkan kejadian Parse. |
ReadValue() |
Mengatur properti kontrol ke nilai yang dibaca dari sumber data. |
ToString() |
Mengembalikan string yang mewakili objek saat ini. (Diperoleh dari Object) |
WriteValue() |
Membaca nilai saat ini dari properti kontrol dan menulisnya ke sumber data. |
Acara
BindingComplete |
Terjadi ketika FormattingEnabled properti diatur ke |
Format |
Terjadi ketika properti kontrol terikat ke nilai data. |
Parse |
Terjadi ketika nilai kontrol terikat data berubah. |