I’ve tried your solution. The system said that there is no rows(0). It seems that this activity does not work with output para. I have to change my stored procedure in database like this
and use Table.Rows(0).Items(“IssuedItemMaterialName”) to get value from IssuedItemMaterialName
ALTER PROCEDURE [dbo].[GetIssuedItem]
– SET NOCOUNT ON added to prevent extra result sets from
– interfering with SELECT statements.
SET NOCOUNT ON;
SELECT IssuedItemMaterialId, IssuedItemMaterialName, IssuedItemLotNo
WHERE ID = @id