Hi,
From your description, you want to create Insert, Update, Delete and Select method with TableAdapter using existed in the database.
In your case, there is only Get method on TableAdapter. I guess you configure it incorrectly. For example, I want to create an UpDate method:
-
Right Click TableAdapter.
-
Select "Add Query.." fron context item.
-
Check "Using existing stored procedure", and then click Next button.
-
Select the stroed procedure that is used to update, and then click Next button.
-
You can choose what type the procedure will return. I choose "No value" for update. Then click Next button.
-
Type a name you want, Click Finish button.
Finish these steps, you will see the Update method in the TableAdapter.
If you want to create your own method instead of created by TableAdapter automatically, you can uncheck it.
I look forward to receiving your test results.
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.