I am doing a project in VB.Net. I have attached datatable in a datagridview with couple of datacolumns.
Now I want to insert a row just below datagridview header row in which each cell needs to be a combobox. Those combobox need to be filled up by column names of a SQL server table.
The user will select different values from those comboboxes.
Finally I want the entire datagridview table value with selected combobox values, in a datatable as datagridview.datasource.
How to do that? Please advise.