Comments by PeterScaletti (Top 5 by date)

Thank you

Hi Josh, thank you for your reply. My mistake, the datagridview has 7 columns. I have updated my question

Hi Sergey, thank you for your reply.

This is what I have found,(where objConn is the sql connection string):

Dim daCients As New SqlDataAdapter("Select * From Clients", objConn)
Dim dsClients As New DataSet("Clients")
daClients.FillSchema(dsClients, SchemaType.Source, "Clients")

From this I have been able to create a new dataset and new tableadapter with the updated sql database schematics. What I require, and I am unable to do, is to update an existing dataset and tableadapter.

Thank you, Peter Scaletti

Hi Sergey, thank you for your comment. I am unable to get a table within an existing dataset and an existing tableadapter query, to update, to include a new column that has been added into a sql database.