c# - 从子窗体更新数据库后刷新 datagridview win 窗体

Question

如何在从另一个表单对数据库进行更改后刷新 datagridview，关闭子表单后，我尝试使用点击事件刷新 datagridview，但它不起作用，我必须使用数据集吗？

            //create an OleDbDataAdapter to execute the query
            dAdapter = new OleDbDataAdapter(gQuery, connString);

            //create a command builder
            cBuilder = new OleDbCommandBuilder(dAdapter);

            //create a DataTable to hold the query results
            dTable = new DataTable();

            //fill the DataTable
            dAdapter.Fill(dTable);


            //BindingSource to sync DataTable and DataGridView
            bSource = new BindingSource();

            //set the BindingSource DataSource
            bSource.DataSource = dTable;


            //set the DataGridView DataSource
            dataGridView1.DataSource = bSource;

    private void button_Refresh_Click(object sender, EventArgs e)
    {

        dataGridView1.DataSource = bSource;
        dataGridView1.Refresh();


    }

帮帮我，谢谢

Answer 1

添加

dataGridView1.Update();

它将解决您的问题。