GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[SpConformOrder]
@UserID INT,
@TemplateID INT,
@Price MONEY,
@Address XML,
@Placeholder XML
AS
BEGIN
DECLARE @OrderID INT
INSERT INTO [tblOrder]
([UserID]
,[TemplateID]
,[Price]
,[Status])
VALUES
(@UserID
,@TemplateID
,@Price
,1)
SET @OrderID=@@IDENTITY;
INSERT INTO tblOrderAddress (OrderID,AddressID)
SELECT @OrderID,
Pers.value('(addressID)[1]', 'int') as 'AddressID'
FROM
@Address.nodes('/addresses/adderss') as Addresses(Pers)
INSERT INTO [dbo].[tblPlaceHolder](OrderID,TemplateID,PlaceHolderOrderID,Type, Value)
SELECT @OrderID,
Pers.value('(templateID)[1]', 'int') as 'TemplateID',
Pers.value('(placeholderOrderID)[1]', 'int') as 'PlaceHolderOrderID',
Pers.value('(Type)[1]', 'Varchar(10)') as 'Type',
Pers.value('(Value)[1]', 'Varchar(max)') as 'Value'
FROM
@Placeholder.nodes('/placeholders/placeholder') as Placeholders(Pers)
END
I want to insert template data in xml format.
This is my sample template :
When click on save I want to save template details like image , placeholder2 and placeholder 3 text values in my database using xml format.
Please give me a code for that.
Thanks.