DataGridView绑定製作主從表

野性酷女 2022-08-27 08:58 177阅读 0赞

DataGridView绑定製作主從表

1.确保绑定到同一数据源的多个控件保持同步  
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();  
\}

2.使Binding後的TextBox可失去焦點  
masterBindingSource.BindingComplete += new BindingCompleteEventHandler(bindingSource1\_BindingComplete);

private void bindingSource1\_BindingComplete(object sender, BindingCompleteEventArgs e)  
\{  
if (e.Exception != null)  
\{  
e.Cancel = false;//這一句將使textbox中的值與table\[head\]中相應欄位的值不一致.  
return;  
\}

if (e.BindingCompleteContext == BindingCompleteContext.DataSourceUpdate && e.Exception == null)  
e.Binding.BindingManagerBase.EndCurrentEdit();  
\}

3.CurrencyManager的使用,TextBox中數據可自動與DataGridView同步  
private BindingSource masterBindingSource;  
private DataSet ds = new DataSet();  
private CurrencyManager currency;

private void BindingFrom\_Load(object sender, EventArgs e)  
\{  
using (SqlConnection conn = new SqlConnection("server=(local);database=testdb;uid=sa;pwd=123456"))  
\{  
SqlCommand cmd = new SqlCommand("select d1,d2,d3 from head where 1=2");  
cmd.Connection = conn;  
SqlDataAdapter da = new SqlDataAdapter(cmd);  
da.Fill(ds, "head");  
\}  
masterBindingSource = new BindingSource(this.ds, "head");  
dataGridView1.DataSource = masterBindingSource;  
this.currency = (CurrencyManager)this.dataGridView1.BindingContext\[this.ds, "head"\];  
masterBindingSource.BindingComplete += new BindingCompleteEventHandler(bindingSource1\_BindingComplete);  
//  
this.dataGridView1.Columns\["d1"\].HeaderText = "d1Col";  
this.dataGridView1.Columns\["d2"\].HeaderText = "d2Col";  
//  
textBox1.DataBindings.Add("Text", masterBindingSource, "d1", true, DataSourceUpdateMode.OnPropertyChanged);  
textBox2.DataBindings.Add("Text", masterBindingSource, "d2", true, DataSourceUpdateMode.OnPropertyChanged);  
textBox3.DataBindings.Add("Text", masterBindingSource, "d3", true, DataSourceUpdateMode.OnPropertyChanged);  
//  
\}

4.從表隨主表變動  
private BindingSource detailBindingSource;  
private DataSet ds = new DataSet();

this.dataGridView1.CurrentCellChanged += new EventHandler(dataGridView1\_CurrentCellChanged);

void dataGridView1\_CurrentCellChanged(object sender, EventArgs e)  
\{  
if (this.dataGridView1.CurrentCell != null)  
\{  
InitDetail(this.dataGridView1.Rows\[this.dataGridView1.CurrentCell.RowIndex\].Cells\["d1"\].Value.ToString());  
\}  
else  
\{  
InitDetail((string)null);  
\}  
\}

private void InitDetail(string keyValue)  
\{  
if (this.detailBindingSource != null)  
\{  
this.ds.Tables\["body"\].Clear();  
\}  
if (keyValue == (string)null)  
\{  
return;  
\}  
using (SqlConnection conn = new SqlConnection("server=(local);database=testdb;uid=sa;pwd=123456"))  
\{  
SqlCommand cmdDetail = new SqlCommand("select d2,d3 from body where d1=&apos;"+keyValue+"&apos;");  
cmdDetail.Connection = conn;  
SqlDataAdapter daDetail = new SqlDataAdapter(cmdDetail);  
daDetail.Fill(ds, "body");  
\}  
detailBindingSource = new BindingSource(this.ds, "body");  
dataGridView2.DataSource = detailBindingSource;  
\}

5.主表變動  
private BindingSource masterBindingSource;  
private DataSet ds = new DataSet();

private void InitMaster(string field1, string field2)  
\{  
this.ds.Tables\["head"\].Rows.Clear();  
using (SqlConnection conn = new SqlConnection("server=(local);database=testdb;uid=sa;pwd=19821026"))  
\{  
SqlCommand cmd = new SqlCommand("select d1,d2,d3 from head where d1 like &apos;%" + field1 + "%&apos; and d2 like &apos;%"+field2+"%&apos;");  
cmd.Connection = conn;  
SqlDataAdapter da = new SqlDataAdapter(cmd);  
da.Fill(ds, "head");  
\}

masterBindingSource = new BindingSource(this.ds, "head");  
dataGridView1.DataSource = masterBindingSource;

this.currency = (CurrencyManager)this.dataGridView1.BindingContext\[this.ds, "head"\];  
//使數據實時同步改變  
masterBindingSource.BindingComplete += new BindingCompleteEventHandler(bindingSource1\_BindingComplete);

ClearBinding();  
BindingHead();

\}  
private void ClearBinding()  
\{  
this.textBox1.DataBindings.Clear();  
this.textBox2.DataBindings.Clear();  
this.textBox3.DataBindings.Clear();  
\}  
private void BindingHead()  
\{  
//bind TextBox  
textBox1.DataBindings.Add("Text", masterBindingSource, "d1", true, DataSourceUpdateMode.OnPropertyChanged);  
textBox2.DataBindings.Add("Text", masterBindingSource, "d2", true, DataSourceUpdateMode.OnPropertyChanged);  
textBox3.DataBindings.Add("Text", masterBindingSource, "d3", true, DataSourceUpdateMode.OnPropertyChanged);  
//

6.綜合實例

暂时略