you can solve it by creating a stored procedure with your queries. sample one looks like below one.
CREATE PROCEDURE [sp_UpdateGRN]
(
@parameter1 nvarchar,
@parameter2 nvarchar,
.
.
.
@parametern nvarchar,
)
AS
BEGIN
BEGIN TRANSACTION
BEGIN TRY
INSERT INTO [tblTransaction]
(Field1,Field2,......Fieldn)
VALUES
(@parameter1,@parameter2,......@parametern)
INSERT INTO [tblStock]
(Field1,Field2,......Fieldn)
VALUES
(@parameter1,@parameter2,......@parametern)
COMMIT TRANSACTION
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
SELECT ERROR_NUMBER() AS ErrorNumber,ERROR_MESSAGE() AS ErrorMessage
END CATCH
END
please do make/changes based on your needs.