Introduction

When you use TableAdapters in C#, VS generates INSERT, SELECT and UPDATE etc commands for you.

Other commands can be added by going into DataSet Designer and adding commands via the Add SQL Wizard.

Sometimes, however, you need additional SQL commands that contain a complete list of all the fields in the DataSet. You would also like these lists to be automatically updated whenever a change is made to the Database.