Extra column to a DatagridView with binding source

Question

Hi!

I have a datagridview with a datasource from a MySQL query. Works fine. However, I want to add an extra column and generate some data into the cells. This works fine too and shows up as intended. However, I cannot sort on that extra column and the contents of the cells in the column are cleared out if I sort on the other colums. I realize this is all because of the original datasource, but Im hoping there is a way to "connect" the extra column in somehow?

Grid_SearcherResults.DataSource = dbconnection.bSource
Grid_SearcherResults.Columns.Add("Location", "Location")

'Then some code to set the value of the cells in the new column.. etc

Thanks!

Answer 1

Fixed! 

Dim source As DataTable = dbconnection.bSource.DataSource
source.Columns.Add("Location")
Grid_SearcherResults.DataSource = source

Answer 2

Hi Untouchab1e,

Thanks for your post.

I’m glad to hear that you found a solution. Thanks for sharing the solution here and it will help the members who have similar issue.

Have a nice day!

---

Mark Liu-lxf [MSFT]
MSDN Community Support | Feedback to us