'Refresh DataTable' not an option for me in DataSet designer

458 Views Asked by At

I need to get my PK back to me after doing an update on my DataTableAdapter but the DataSet Designer does not give me the option, I attached a screenshot.

How do I get around this?

enter image description here

1

There are 1 best solutions below

0
On BEST ANSWER

As Henk pointed out above in the comments to my question, the issue is with my database version.

I was trying to use this tool against SQL Server 2000, which it works great for except the 'Refresh the Data table' option which is not support.

So instead I wrote my own stored procedure that returns my scope_identity like I needed.