最新国产好看的视频,伊人天堂AV在线,国产Aaaaaa视频,蜜臀视频在线观看一区,人妻av色图,密臀久久久精品影片,青青视频免费观看毛片,久草在线观看视,国产三级精品色情在线

C#應(yīng)用BindingSource實(shí)現(xiàn)數(shù)據(jù)同步的方法

 更新時(shí)間:2014年08月26日 14:33:56   投稿:shichen2014  
這篇文章主要介紹了C#應(yīng)用BindingSource實(shí)現(xiàn)數(shù)據(jù)同步的方法,需要的朋友可以參考下

本文以實(shí)例形式講述了C#應(yīng)用BindingSource實(shí)現(xiàn)數(shù)據(jù)同步的方法,對(duì)C#數(shù)據(jù)庫(kù)程序開(kāi)發(fā)來(lái)說(shuō)具有一定的參考借鑒價(jià)值。具體實(shí)現(xiàn)方法如下:

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

該示例演示如何處理 BindingComplete 事件,并確保當(dāng)一個(gè)文本框的文本值更改時(shí),會(huì)用正確的值更新其他文本框和 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 組件跨窗體共享綁定數(shù)據(jù),具體代碼如下:

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&amp;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 });
    }
  }
}

希望本文所述對(duì)大家的C#程序設(shè)計(jì)有所幫助。

相關(guān)文章

最新評(píng)論

阿巴嘎旗| 大洼县| 化州市| 潮安县| 临泉县| 章丘市| 英山县| 杂多县| 林西县| 巴彦县| 方正县| 桃园市| 保山市| 库尔勒市| 永修县| 开封市| 延津县| 阳新县| 来安县| 清水河县| 宁国市| 昔阳县| 乡城县| 南乐县| 景宁| 日喀则市| 阜平县| 桂东县| 乾安县| 施甸县| 秦皇岛市| 六枝特区| 巨野县| 石景山区| 汝阳县| 彝良县| 漳州市| 蒙自县| 开封县| 中牟县| 定南县|