Editing Stored Procedure and Updating table Adapter

Question

I just updated the stored procedure by adding one more column then i went to table adapters and recreate the table adapter but the updated column wont appear in data columns.. How can i fix this issue? Please Help...

I have faced sometimes the above. In order not to loose time i delete the adapter and add it again. This is not the best practice, of course but when time is pressing is a solution. — kostas ch., Jun 27 '13 at 06:19
please add more details (your stored procedure , code) in order to help you — Mohammad abumazen, Jun 27 '13 at 06:21
i strongly suggest you add your code and some more details, but i think that if you just pass in step by step to create the adapter, you will find your mistake — No Idea For Name, Jun 27 '13 at 06:49

score 1 · Accepted Answer · answered Jun 27 '13 at 08:48

1

It would be good if you can paste some code here so we can provide better assistance.

For a start just make sure you committed changes to your stored procedure, that you added procedure to the correct database and such.

If that’s working fine try deleting and creating adapter again from scratch. If that still doesn’t work you can always add column manually and bind it to appropriate output column.

answered Jun 27 '13 at 08:48

Orland Mendes

516
4
5

thanks restarting VS and recreating the adapter solved the problem – TAB Jun 27 '13 at 10:30

Editing Stored Procedure and Updating table Adapter

1 Answers1