Cannot find column [name]

Question

private   void  textBox_Search_TextChanged( object  sender, EventArgs e)            {                    DataTable dbdataset =  new  DataTable();                      try                     {                            DataView DV =  new  DataView(dbdataset);                            DV.RowFilter =  string .Format( "nama LIKE '%{0}%'" ,textBox_Search.Text);                            metroGrid_SearchCS.DataSource = DV;                    }                     catch  (Exception ex)                    {                            MessageBox.Show(ex.Message);                    }            }   This is my project, i didn't search customer name with textbox. And i got Cannot find column [name] Anyone can help me. Thank you

Sachin Singh · Answer

in your dataset , from wherever you have retrived data , I think from databse, your column name is different than what you are using here, check what is exactly your column name in database perhaps it will be Name instead of nama in database.

so change like below

DV.RowFilter = string.Format("name LIKE '%{0}%'",textBox_Search.Text);

Rajanikant Hawaldar · Answer

https://www.c-sharpcorner.com/UploadFile/1a81c5/filter-datagridview-with-the-text-entered-in-textbox-in-winf/

Amit Gupta · Answer

Recheck your column name, if you had used alias name then consider that. Clean and rebuild your project

Rajanikant Hawaldar · Answer

Your creating new data table object and trying to filter data table object which has no data this is wrong. You have to initialize one data table object as class level global data table object which you need to use for initial data binding to grid control and use the same object while filter on textbox search

Mageshwaran R · Answer

Hi Aldio, please refer this link,   https://stackoverflow.com/questions/42821518/search-in-datagrid-by-textbox-wpf/42821776    Find Column Name:  private   void  PrintColumnNames(DataSet dataSet)   {        // For each DataTable, print the ColumnName.         foreach (DataTable table  in  dataSet.Tables)       {            foreach (DataColumn column  in  table.Columns)           {               Console.WriteLine(column.ColumnName);           }       }   }