The title pretty much says it all.

I have a form with a datagridview. When it loads, the datagridview is populated from a SQL database table.

I created all of this (dataset, tableadapter, datagridview, etc.) via drag and drop (please don't lecture me on why I should have hand-coded it - wasn't my choice...).

Now what I need to do is before the datagridview is actually populated I want to run an Update query on the SQL table so the user sees the table with the results of the Update query.

I added an update query to the dataset designer (the .xsd file), but I can't figure out how to get that to run before the grid is populated. I tried putting the line Me.emailWithAttachmentsTableAdapter.UpdateBookingNumQuery() in the form load event, but that didn't work.

Any ideas, anyone?