Use XML Data For Save in Database
CREATE PROCEDURE [dbo].[SaveData] @MH INT, @TxTest INT, @ID INT, @CreatedBy INT, @strXML VARCHAR(MAX) AS BEGIN SET NOCOUNT ON; DECLARE @XMLDocHandle INT; DECLARE @InvestorID INT SET @ID=(SELECT Id FROM tbl_Test WHERE ID=@ID) IF(@strXML IS NOT NULL AND @strXML<>'') BEGIN EXEC sp_xml_preparedocument @XMLDocHandle OUTPUT, @strXML CREATE TABLE #temp(ID INT,ClientID INT,InvID INT,Name VARCHAR(100),MaxAmount NVARCHAR(20),BankName NVARCHAR(500), AN VARCHAR(30),Status VARCHAR(20),CreatedDate DATETIME,CreatedBy VARCHAR(10),StartDate DATETIME) INSERT INTO #temp SELECT ID,ClientID,@InvestorID,MName,MA,BName,AN,Status,GETDATE(),@CreatedBy,GETDATE() FROM OPENXML (@XMLDocHandle, 'NewDataSet/Table1',2) WITH( ID VARCHAR(10) 'ID', ClientID VARCHAR(10) 'ClientID', MN VARCHAR(100) 'MN', MA NVARCHAR(20) 'MA', BN NVARCHAR(500) 'BN', ANumber VAR...