Solution
If your stored procedure i returning just a column or more than 1 columns and not returning the ID column that is the primary key, this error would occur. Just include ID or * in select statement e.g.
ALTER PROCEDURE [dbo].[sp_FillMenuItems] AS BEGIN SELECT * from t_Menu End
OR
ALTER PROCEDURE [dbo].[sp_FillMenuItems] AS BEGIN SELECT ID, Menu_Item from t_Menu END
Your issue will be resolved 🙂
Leave a Reply