Hello, I am not using the Visual Studio Wizard to create my stored procedures to select/update/insert. I created my own SP and associated them with my table adapter.
In my Update and Insert stored procedures, I have a select statement returning the row that has been inserted/updated. Now is there a way to enable the "refresh data table" option, so that after I insert/update, my datatable is updated with the newly inserted/ updated value as well? If not can it be extended i.e. can I hardcode it somewhere? Please help, this is driving me crazy! Thank you!
