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 comment