I have loaded data from the database to the dataset named myDS. myDS contains several tables. Then I bound one of those tables (named Inventory) into the datagridview named dataGridViewInventory and everything worked fine. However, when I tried to search in the Inventory table and the result bound to the datagridview dataGridViewInventory but it appeared empty.
Here is the code of searching and binding:
 DataRow[] filteredRows =
                        myDS.Tables["Inventory"].Select(string.Format("Make LIKE '%{0}%'", txtMake.Text.Trim()));
            DataSet tempTaskDS = new DataSet("tempCars");
            //tempTaskDS.Tables.Add("TempInv");
            DataTable DataTable2 = new DataTable("TempInv");
            // This makes the new DataTable have the same columns as the existing DataTable.
            DataTable2 = myDS.Tables["Inventory开发者_开发技巧"].Clone(); 
            foreach (DataRow r in filteredRows)
            {
                DataTable2.ImportRow(r);
            }
            tempTaskDS.Tables.Add(DataTable2);
            dataGridViewInventory.DataSource = tempTaskDS.Tables["TempInv"];
Can anyone tell me what I have gone wrong, please?
Found solution: DO not need to use a temporary dataset, just use the BindingSource and bind the datatable to it, then bind the BindingSource to the datagridview. The code is below:
DataRow[] filteredRows =
                        myDS.Tables["Inventory"].Select(string.Format("Make LIKE '%{0}%'", txtMake.Text.Trim()));
            DataTable DataTable2 = new DataTable("TempInv");
            // This makes the new DataTable have the same columns as the existing DataTable.
            DataTable2 = myDS.Tables["Inventory"].Clone(); 
            foreach (DataRow r in filteredRows)
            {
                DataTable2.ImportRow(r);
            }
            BindingSource bSource = new BindingSource();
            bSource.DataSource = DataTable2;
            dataGridViewInventory.DataSource = bSource;
 
         
                                         
                                         
                                         
                                        ![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif) 
                                         
                                         
                                         
                                         加载中,请稍侯......
 加载中,请稍侯......
      
精彩评论