winform程序,在一窗体更新数据在另一窗体中用DataGrid控件显示更新数据的问题,急急急
第一个窗体中用DataGrid控件显示数据库的内容,在此窗体中通过菜单打开第二个窗体,并在其中修改数据库里的内容,并且更新数据库(此时直接进入数据库中可看到数据库确实已经更新),而第一个窗体中仍然显示数据库中原来的数据,(上边所说的数据库指同一数据库),请问如何绑定才能使DataGrid控件里的数据同步更新?如果检查数所行state状态该如何检查?谢谢谢谢.我急着等用啊.
[解决办法]
你在A窗口(有DATAGRID)的窗口写个可以更新DATAGRID的函数,然后B窗口修改数据库之后调用这个方法不就好了
[解决办法]
如果想使用同步刷新的话 还可以用一个计时器定时刷新
[解决办法]
要用到设计模式
[解决办法]
在 第一个窗体中ENTER事件中重新给DataGrid赋值
不知道是不是这样可以符合你的要求
如果同步更新,就只有用定时器了!
[解决办法]
你必须保证你打开的窗体不是模式窗体
你在修改数据库的时候让他触发一个事件,在第一个窗体去用就可以了的撒
[解决办法]
用委托吧:
1:定义一个委托的类:
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace EIP
{
public delegate void DelegateEvent(string ttt);
}
==============
2:窗体2中代码
public event DelegateEvent refreshData;//生明一个委托的事件
// 当你在数据保存后窗体2数据刷新...
void btn_click()
{
string tt = "ttt ";
this.refreshMethod(tt);
}
3:================================在你想要刷新的窗体的动作
form2 frm = new form2();
frm.refreshMethod+=new DeletegateTestMethod(refreshMethod);
frm.ShowDialog();
........
void refreshMethod(string ttt)
{
.....
可以根据窗体2中传来的参数做一些动作...
}
[解决办法]
//在另一个窗口中修改当前选定的DataGrid的行
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
//主窗体代码
namespace Zhzuo
{
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.DataGrid dataGrid1;
private DataSet ds;
private System.Windows.Forms.Button button1;
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.Container components = null;
public Form1()
{
InitializeComponent();
ds = new DataSet( "MyDataSet ");
InitData(ds);
this.dataGrid1.DataSource = this.ds;
this.dataGrid1.DataMember = this.ds.Tables[0].TableName;
}
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.button1 = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.SuspendLayout();
//
// dataGrid1
//
this.dataGrid1.DataMember = " ";
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(16, 20);
this.dataGrid1.Name = "dataGrid1 ";
this.dataGrid1.Size = new System.Drawing.Size(340, 160);
this.dataGrid1.TabIndex = 0;
this.dataGrid1.DoubleClick += new System.EventHandler(this.dataGrid1_DoubleClick);
//
// button1
//
this.button1.Location = new System.Drawing.Point(264, 196);
this.button1.Name = "button1 ";
this.button1.TabIndex = 1;
this.button1.Text = "修改 ";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(372, 229);
this.Controls.Add(this.button1);
this.Controls.Add(this.dataGrid1);
this.Name = "Form1 ";
this.Text = "Form1 ";
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);
}
#endregion
private void InitData(DataSet ds)
{
DataTable dt = new DataTable( "TabeHost ");
DataColumn dc = new DataColumn( "IpAddress ",typeof(string));
dt.Columns.Add(dc);
dc = new DataColumn( "UserName ",typeof(string));
dt.Columns.Add(dc);
dc = new DataColumn( "Password ",typeof(string));
dt.Columns.Add(dc);
ds.Tables.Add(dt);
DataRow dr = dt.NewRow();
dr[ "IpAddress "] = "192.192.132.229 ";
dr[ "UserName "] = "zhzuo ";
dr[ "Password "] = "zhengzuo ";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[ "IpAddress "] = "192.192.132.230 ";
dr[ "UserName "] = "11 ";
dr[ "Password "] = "12 ";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[ "IpAddress "] = "192.192.132.231 ";
dr[ "UserName "] = "123 ";
dr[ "Password "] = "12 ";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[ "IpAddress "] = "192.192.132.232 ";
dr[ "UserName "] = "22 ";
dr[ "Password "] = "788 ";
dt.Rows.Add(dr);
}
private void button1_Click(object sender, System.EventArgs e)
{
DataRowView drv = (DataRowView)this.BindingContext[this.ds,this.ds.Tables[0].TableName].Current;
Form2 form2 = new Form2(drv);
form2.ShowDialog();
}
private void dataGrid1_DoubleClick(object sender, System.EventArgs e)
{
button1_Click(button1,EventArgs.Empty);
}
}
}
//子窗体代码
=======================
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace Zhzuo
{
/// <summary>
/// Form2 的摘要说明。
/// </summary>
public class Form2 : System.Windows.Forms.Form
{
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Button button2;
private DataRowView drv;
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.Container components = null;
public Form2(DataRowView dr)
{
InitializeComponent();
this.drv = dr;
this.textBox1.Text = (string)drv[ "IpAddress "];
this.textBox2.Text = (string)drv[ "UserName "];
this.textBox3.Text = (string)drv[ "Password "];
}
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.textBox1 = new System.Windows.Forms.TextBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.textBox3 = new System.Windows.Forms.TextBox();
this.button1 = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
this.SuspendLayout();
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(28, 16);
this.textBox1.Name = "textBox1 ";
this.textBox1.TabIndex = 3;
this.textBox1.Text = "textBox1 ";
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(28, 56);
this.textBox2.Name = "textBox2 ";
this.textBox2.TabIndex = 4;
this.textBox2.Text = "textBox2 ";
//
// textBox3
//
this.textBox3.Location = new System.Drawing.Point(28, 92);
this.textBox3.Name = "textBox3 ";
this.textBox3.TabIndex = 5;
this.textBox3.Text = "textBox3 ";
//
// button1
//
this.button1.Location = new System.Drawing.Point(152, 152);
this.button1.Name = "button1 ";
this.button1.TabIndex = 6;
this.button1.Text = "保存 ";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// button2
//
this.button2.Location = new System.Drawing.Point(236, 152);
this.button2.Name = "button2 ";
this.button2.TabIndex = 7;
this.button2.Text = "退出 ";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// Form2
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(324, 201);
this.Controls.Add(this.button2);
this.Controls.Add(this.button1);
this.Controls.Add(this.textBox3);
this.Controls.Add(this.textBox2);
this.Controls.Add(this.textBox1);
this.Name = "Form2 ";
this.Text = "Form2 ";
this.ResumeLayout(false);
}
#endregion
private void button1_Click(object sender, System.EventArgs e)
{
drv[ "IpAddress "] = this.textBox1.Text;
drv[ "UserName "] = this.textBox2.Text;
drv[ "Password "] = this.textBox3.Text;
}
private void button2_Click(object sender, System.EventArgs e)
{
this.Close();
}
}
}