Cannot find column [name]

Sign in to answer this question.

• 

  Rajanikant Hawaldar5y agoPosted Oct 24, 2020, 12:02 AM

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

  Sachin Singh5y agoPosted Oct 23, 2020, 11:39 PM

  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

   

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

  Rajanikant Hawaldar5y agoPosted Oct 23, 2020, 9:38 PM

  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
• 

  Amit Gupta5y agoPosted Oct 23, 2020, 9:28 PM

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

  Mageshwaran R5y agoPosted Oct 23, 2020, 8:38 PM

  Hi Aldio,

  please refer this link,

   

  https://stackoverflow.com/questions/42821518/search-in-datagrid-by-textbox-wpf/42821776 

   

  Find Column Name: 

  1. private void PrintColumnNames(DataSet dataSet)  
  2. {  
  3.     // For each DataTable, print the ColumnName.  
  4.     foreach(DataTable table in dataSet.Tables)  
  5.     {  
  6.         foreach(DataColumn column in table.Columns)  
  7.         {  
  8.             Console.WriteLine(column.ColumnName);  
  9.         }  
  10.     }  
  11. }