hi, iam using asp.net with c#, with sql server 2000
in my gridview iam displaying data from view at page load event
the 1st column is checkbox in template field,2nd is categorynamee,3rd is itemkey, 4th is itemkeyname
5th is currentqty, 6th is salesprice,7th is quantity, 8th is total
i have to insert into two tables
1st table orders
orderno int primary key autoincrement,
username nvarchar(50) ,
shopname nvarchar(50),
email nvarchar(100)
2nd table is Orderdetails
serialno int primarykey autoincrement,
orderno int foreignkey,
categorynamee nvarchar(50),
itemkey nvarchar(50),
itemkeyname nvarchar(50),
currentqty decimal,
salesprice decimal,
quantity int,
total decimal
when user selects any no of the checkboxes that rows should be added in both tables, iam getting errors
can you give examples which helps me
Loading
VasanthPosted Apr 20, 2010, 10:35 AM
CREATE PROCEDURE dbo.InsertTwoTables
@username nvarchar(500),
@shopname nvarchar(50),
@email nvarchar(100) ,
@categorynamee nvarchar(50),
@itemkey nvarchar(50),
@itemkeyname nvarchar(50),
@currentqty decimal,
@salesprice decimal,
@quantity int,
@total decimal
AS
BEGIN TRY
BEGIN TRANSACTION -- Start the transaction
Set Nocount On
DECLARE @OrderID int
INSERT INTO orders(username, shopname, email) VALUES (@username, @shopname, @email)
SELECT @OrderID=@@IDENTITY
INSERT INTO Orderdetails (orderno, categorynamee , itemkey ,itemkeyname, currentqty, salesprice, quantity, total)
VALUES (@OrderID, @categorynamee , @itemkey , @itemkeyname, @currentqty, @salesprice, @quantity, @total)
-- If we reach here, success!
COMMIT
END TRY
BEGIN CATCH
-- Error
IF @@TRANCOUNT > 0
ROLLBACK
-- Raise an error
DECLARE @ErrMsg nvarchar(4000), @ErrSeverity int
SELECT @ErrMsg = ERROR_MESSAGE(),
@ErrSeverity = ERROR_SEVERITY()
RAISERROR(@ErrMsg, @ErrSeverity, 1)
END CATCH
Hope it helps out , please mark as answer.