Datagridview Sorting with manually added columns

See more:

VS2008

VB

Visual-Studio

MySQL

, +

I have a datagridview control bound to a MySQL database column.

While loading the table to datagridview, i am adding one Column and 8 rows to the datagridview. Values to these manually added coluns and rows are also programitically added. All is working fine except the sorting. When i click on any of column header, datagridview sorts according to the binded table and the manually added column gets blank.

I want a method to sort the datagridview even if it has a manually added column into it.

Please help....