MySQL VB.NET Tutorial 15 :Change column title of datagridview when connecting Mysql

Dear Sir, I have changed the header text of the column in design time through datagridview tasks> edit column after changing the data source to the required sql db. it has helped me change the title but the problem now is that i cant update or delete any record from gridview as it says "Column name is not found" Please note that i have only changed the column header text and the DataPropertyName is same as in actual db table. i wounder why its throwing error. any help regarding this will be highly appreciated. Thanks

Be careful here, depending on how the search routines are set up, the names may also have to be changed there also, because the search is actually looking at the titles in the DataGridView not in the database.

Thanks Man

To use the search text box for column names that have spaces enclose the column name in square brackets. This works for me - DV.RowFilter = String.Format("[First Name] Like '%{0}%'", txtSearch.Text).