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

Rajanikant Hawaldar · Answer

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

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);

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); } } }