刷新使用TableAdapter的数据 [英] Reload data using TableAdapter

问题描述

private void UserList_Load(object sender, EventArgs e)
{
    // TODO: This line of code loads data into the 'workOrdersDataSet.users' table. You can move, or remove it, as needed.
    this.usersTableAdapter.Fill(this.workOrdersDataSet.users);
}

我怎样才能重新加载数据进行了更改，以另一种形式提出？ （最好是自动，而无需使用刷新按钮）？

How can I reload the data if changes were made in another form? (preferably automatically without using a Refresh button)?

我使用的WinForms和后端的Access 2007年。

I am using WinForms and the backend is Access 2007.

数据使用设计器到DataGrid

The data is bound using the Designer to a Datagrid

推荐答案

首先，我会移动填写<约束/ code>到一个单独的功能：

First, I would move the Fill to a separate function:

public void LoadData()
{
   this.usersTableAdapter.Fill(this.workOrdersDataSet.users);
}

然后，当你做你的加载事件，你会调用该函数：

Then when you do your Load Event, you will call the function:

private void UserList_Load(object sender, EventArgs e)
{
   LoadData();
}

如果您有对数据进行修改的另一种形式，你可以调用这个函数在另一个事件，与此类似。我使用的DialogResult 在我的代码：

If you have another form that performs changes on the data, you can call this function in another event, similar to this. I use DialogResult in my code:

private void OpenOtherForm()
{
    DialogResult openForm = new OtherForm().ShowDialog();
    if(openForm == DialogResult.OK)
        LoadData();
}

在你对其它形式后您的更新过程是完整的代码，包括行代码要告诉你的主要形式更新：

In your code for the other Form after your update process is complete, include a line of code to tell your main form to update:

private void PerformUpdate()
{
    try
    {
        // your update code goes here
        DialogResult = DialogResult.OK; // this is the line that tells your other form to refresh
    }
    catch (Exception ex)
    {
        DialogResult = DialogResult.Abort;
    }
}

使用的DialogResult 那么，告诉你的主要形式，以触发数据的刷新，只有当一个更新实际发生。

using the DialogResult then, tells your main form to trigger the Refresh of the Data only when an Update actually takes place.

这篇关于刷新使用TableAdapter的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！