国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 編程 > C# > 正文

C#應用BindingSource實現數據同步的方法

2020-01-24 02:28:50
字體:
來源:轉載
供稿:網友

本文以實例形式講述了C#應用BindingSource實現數據同步的方法,對C#數據庫程序開發來說具有一定的參考借鑒價值。具體實現方法如下:

下面的代碼示例演示如何使用 BindingSource 組件,將三個控件(兩個文本框控件和一個 DataGridView 控件)綁定到 DataSet 中的同一列。

該示例演示如何處理 BindingComplete 事件,并確保當一個文本框的文本值更改時,會用正確的值更新其他文本框和 DataGridView 控件。

具體代碼如下:

// Declare the controls to be used.private BindingSource bindingSource1;private TextBox textBox1;private TextBox textBox2;private DataGridView dataGridView1;private void InitializeControlsAndDataSource(){  // Initialize the controls and set location, size and   // other basic properties.  this.dataGridView1 = new DataGridView();  this.bindingSource1 = new BindingSource();  this.textBox1 = new TextBox();  this.textBox2 = new TextBox();  this.dataGridView1.ColumnHeadersHeightSizeMode =    DataGridViewColumnHeadersHeightSizeMode.AutoSize;  this.dataGridView1.Dock = DockStyle.Top;  this.dataGridView1.Location = new Point(0, 0);  this.dataGridView1.Size = new Size(292, 150);  this.textBox1.Location = new Point(132, 156);  this.textBox1.Size = new Size(100, 20);  this.textBox2.Location = new Point(12, 156);  this.textBox2.Size = new Size(100, 20);  this.ClientSize = new Size(292, 266);  this.Controls.Add(this.textBox2);  this.Controls.Add(this.textBox1);  this.Controls.Add(this.dataGridView1);  // Declare the DataSet and add a table and column.  DataSet set1 = new DataSet();  set1.Tables.Add("Menu");  set1.Tables[0].Columns.Add("Beverages");  // Add some rows to the table.  set1.Tables[0].Rows.Add("coffee");  set1.Tables[0].Rows.Add("tea");  set1.Tables[0].Rows.Add("hot chocolate");  set1.Tables[0].Rows.Add("milk");  set1.Tables[0].Rows.Add("orange juice");  // Set the data source to the DataSet.  bindingSource1.DataSource = set1;  //Set the DataMember to the Menu table.  bindingSource1.DataMember = "Menu";  // Add the control data bindings.  dataGridView1.DataSource = bindingSource1;  textBox1.DataBindings.Add("Text", bindingSource1,     "Beverages", true, DataSourceUpdateMode.OnPropertyChanged);  textBox2.DataBindings.Add("Text", bindingSource1,     "Beverages", true, DataSourceUpdateMode.OnPropertyChanged);  bindingSource1.BindingComplete +=     new BindingCompleteEventHandler(bindingSource1_BindingComplete);}private void bindingSource1_BindingComplete(object sender, BindingCompleteEventArgs e){  // Check if the data source has been updated, and that no error has occured.  if (e.BindingCompleteContext ==     BindingCompleteContext.DataSourceUpdate && e.Exception == null)    // If not, end the current edit.    e.Binding.BindingManagerBase.EndCurrentEdit();}

下面的代碼演示如何使用 BindingSource 組件跨窗體共享綁定數據,具體代碼如下:

using System;using System.Drawing;using System.Windows.Forms;using System.Data;namespace BindingSourceMultipleForms{  public class MainForm : Form  {    public MainForm()    {      this.Load += new EventHandler(MainForm_Load);    }    private BindingSource bindingSource1;    private Button button1;    private void MainForm_Load(object sender, EventArgs e)    {      InitializeData();    }    private void InitializeData()    {      bindingSource1 = new System.Windows.Forms.BindingSource();      // Handle the BindingComplete event to ensure the two forms      // remain synchronized.      bindingSource1.BindingComplete +=         new BindingCompleteEventHandler(bindingSource1_BindingComplete);      ClientSize = new System.Drawing.Size(292, 266);      DataSet dataset1 = new DataSet();      // Some xml data to populate the DataSet with.      string musicXml =        "<?xml version='1.0' encoding='UTF-8'?>" +        "<music>" +         "<recording><artist>Dave Matthews</artist>" +         "<cd>Under the Table and Dreaming</cd>" +          "<releaseDate>1994</releaseDate><rating>3.5</rating></recording>" +         "<recording><artist>Coldplay</artist><cd>X&Y</cd>" +          "<releaseDate>2005</releaseDate><rating>4</rating></recording>" +         "<recording><artist>Dave Matthews</artist>" +          "<cd>Live at Red Rocks</cd>" +          "<releaseDate>1997</releaseDate><rating>4</rating></recording>" +         "<recording><artist>U2</artist>" +          "<cd>Joshua Tree</cd><releaseDate>1987</releaseDate>" +          "<rating>5</rating></recording>" +         "<recording><artist>U2</artist>" +         "<cd>How to Dismantle an Atomic Bomb</cd>" +          "<releaseDate>2004</releaseDate><rating>4.5</rating></recording>" +         "<recording><artist>Natalie Merchant</artist>" +         "<cd>Tigerlily</cd><releaseDate>1995</releaseDate>" +         "<rating>3.5</rating></recording>" +         "</music>";      // Read the xml.      System.IO.StringReader reader = new System.IO.StringReader(musicXml);      dataset1.ReadXml(reader);       // Get a DataView of the table contained in the dataset.      DataTableCollection tables = dataset1.Tables;      DataView view1 = new DataView(tables[0]);      // Create a DataGridView control and add it to the form.      DataGridView datagridview1 = new DataGridView();      datagridview1.ReadOnly = true;      datagridview1.AutoGenerateColumns = true;      datagridview1.Width = 300;      this.Controls.Add(datagridview1);      bindingSource1.DataSource = view1;      datagridview1.DataSource = bindingSource1;      datagridview1.Columns.Remove("artist");      datagridview1.Columns.Remove("releaseDate");      // Create and add a button to the form.       button1 = new Button();      button1.AutoSize = true;      button1.Text = "Show/Edit Details";      this.Controls.Add(button1);      button1.Location = new Point(50, 200);      button1.Click += new EventHandler(button1_Click);    }    // Handle the BindingComplete event to ensure the two forms    // remain synchronized.    private void bindingSource1_BindingComplete(object sender, BindingCompleteEventArgs e)    {      if (e.BindingCompleteContext == BindingCompleteContext.DataSourceUpdate        && e.Exception == null)        e.Binding.BindingManagerBase.EndCurrentEdit();    }    // The detailed form will be shown when the button is clicked.    private void button1_Click(object sender, EventArgs e)    {      DetailForm detailForm = new DetailForm(bindingSource1);      detailForm.Show();    }    [STAThread]    static void Main()    {      Application.EnableVisualStyles();      Application.Run(new MainForm());    }  }  // The detail form class.   public class DetailForm : Form  {    private BindingSource formDataSource;    // The constructor takes a BindingSource object.    public DetailForm(BindingSource dataSource)    {      formDataSource = dataSource;      this.ClientSize = new Size(240, 200);      TextBox textBox1 = new TextBox();      this.Text = "Selection Details";      textBox1.Width = 220;      TextBox textBox2 = new TextBox();      TextBox textBox3 = new TextBox();      TextBox textBox4 = new TextBox();      textBox4.Width = 30;      textBox3.Width = 50;      // Associate each text box with a column from the data source.      textBox1.DataBindings.Add("Text", formDataSource, "cd", true, DataSourceUpdateMode.OnPropertyChanged);      textBox2.DataBindings.Add("Text", formDataSource, "artist", true);      textBox3.DataBindings.Add("Text", formDataSource, "releaseDate", true);      textBox4.DataBindings.Add("Text", formDataSource, "rating", true);      textBox1.Location = new Point(10, 10);      textBox2.Location = new Point(10, 40);      textBox3.Location = new Point(10, 80);      textBox4.Location = new Point(10, 120);      this.Controls.AddRange(new Control[] { textBox1, textBox2, textBox3, textBox4 });    }  }}

希望本文所述對大家的C#程序設計有所幫助。

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 琼结县| 三原县| 台江县| 吴堡县| 望江县| 陈巴尔虎旗| 深水埗区| 南皮县| 兴宁市| 都江堰市| 武强县| 区。| 上饶市| 石林| 福贡县| 姜堰市| 青河县| 子洲县| 额尔古纳市| 琼结县| 原平市| 边坝县| 霍州市| 沛县| 通海县| 浙江省| 吉林省| 万全县| 阜城县| 旅游| 古浪县| 扎赉特旗| 百色市| 东平县| 沂水县| 墨竹工卡县| 上杭县| 大邑县| 饶河县| 桐柏县| 开鲁县|