Search code examples
c#.netstored-proceduresstrongly-typed-dataset

DataSet call insert, update and delete stored procedures


Through designer I have created a typed data set and included stored procedures for insert / update / delete. The problem is now, how to call those stored procedures? How to actually change data in database this way? And how to receive answer from db (number of rows changed)?

enter image description here


Solution

  • I found out that far easiest way is through designer - create table adapter and simply set it to call stored procedure. No extra typing needed, arguments are also added to procedure call.