When you use drag-and-drop data binding, the designer writes some code for you in the Load handler of your form that calls the Fill methods on your Table Adapters.
By default, the insert statement is generated for you and it selects the primary key field, but if you use database stored procs then you need to make sure you return the primary keys as well (in SQL-Server you can use SCOPE_IDENTITY()).
I show an example of creating stored procs in this video and mapping them to Table Adapter commands in this video.
Command Text = "UPDATE Dim Request Master Test HS SET [Running Board] = ?
Connection = my Staging Connection;//da Update = new Sql Data Adapter("Select * From Dim Request Master Test HS", my Staging Connection);//da Update. Tables["Position Updates"]);//cmd Builder = new Sql Command Builder(da);//da Update.
Update(ds , "Position Updates");da Update is Data Adapter Object Sql Command cmd = new Sql Command();cmd.