I've one transaction on sql 2008,
ALTER PROCEDURE SP_CAR_Purchase
@IdBrand nchar (10),
@purchasecode nchar (15),
@Date date,
@IdPartner nchar (10),
@NBPKB nchar (30),
@Price Money,
@Discount Money,
@IdType nchar (10),
@Npolisi nchar(10),
@Nchases nchar (30),
@NMesin nchar (30),
@Warna varchar (20),
@Tahun int,
@HBeli Money
AS
BEGIN TRANSACTION
Insert into tbPurchase(Purchase_No,Pur_Date,Id_Partner,NBPKB)Values
(@purchasecode, @Date, @IdPartner, @NBPKB)
Insert into tbRep_Purchase(Purchase_No,Total)Values(@purchasecode, @Price)
Insert into tbSKKB (Type_No, NBPKB, NPolisi, Nchases, NMesin,
Color,Year,Pur_Price)
Values (@IdType, @NBPKB, @Npolisi,@Nchases, @Nmesin,@Warna, @Tahun,@Price)
if @@Error <> 0
Begin
Rollback Transaction
End
Else
Begin
Commit Transaction
End
how to execute these transactions,
if I use vb.net programming language?
please help