我试图在已绑定数据的经过过滤的datagridview中添加新的ROW。

这就是我填充数据的方式

 private void populatetable()
    {
        string getData = "Select ID,Name_OF_Peoples_Organization AS 'Name of Peoples Organization',Representative_Name as 'Representative Name',Sex as 'Gender',Category,Barangay,Municipality,Year,Office,Taget_Has AS 'Target (has.)'," +
            "accomplishment_Has as 'accomplishment (has.)',Target_Seedlings as 'Target (Seedling)'," +
            "accomplishment_Seedlings AS 'accomplishment (Seedling)',Commodity_Species_Planted as 'Commodity Species Planted'," +
            "Year_1 as 'Year 1',Year_2 as 'Year 2',Year_3 as 'Year 3',grand_total as 'Grand Total',Remarks_Status as 'Remarks/Status' from ngp";
        try
        {
            conn = new MySqlConnection(connectString);
            conn.Open();
            adapter = new MySqlDataAdapter(getData,conn);
            NGPdataset = new DataSet();

            adapter.Fill(NGPdataset);
            advancedDataGridView1.DataSource = NGPdataset.Tables[0];

            ngpclass.NGPTotals(NGPdataset,advancedDataGridView1);

            conn.Close();
            totalss();

        }
        catch (Exception ee)
        {
            MessageBox.Show(ee.Message);
        }
    }

第二个是使用advanceDataGridview过滤器进行过滤

 private void AdvancedDataGridView1_FilterStringChanged(object sender,EventArgs e)
    {
        BindingSource bind = new BindingSource();
        bind.DataSource = advancedDataGridView1.DataSource;
        bind.Filter = this.advancedDataGridView1.FilterString;
    }

现在数据已被过滤，我想在datagridview中添加一个新行，并在单击按钮时使用它

DataTable dt = (DataTable)advancedDataGridView1.DataSource;
             DataRow toInsert = dt.NewRow();
             toInsert[1] = "New Row";
             dt.Rows.Add(toInsert);
             advancedDataGridView1.Refresh();

运行上述代码后，没有结果或任何错误，也没有添加任何新行