The parameter format should be an XML format.
Store procedure:
Create Procedure XMlinsert
@XmlText Text
AS
Declare @intdoc int
Exec sp_xml_preparedocument @intdoc output, @xmltext
INSERT TEST1 ([Name], SEX)
Select [name], [SEX]
From OpenXML (@intdoc, '/ newdataset / table1')
With ([Name] varchar (100) 'name',
[SEX] VARCHAR (4) 'SEX')
EXEC SP_XML_REMOVEDOCUMENT @intdoc
Go
EXAMPLE:
C #:
DataSet DS = Your data source;
Call stored procedure (XMLInsert)
Add parameters (DS.GETXML ())
Ok! ~~