|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
xml stored procedureback end i have a table 'temp'. with identity field
in front end i am using datagrid some updation/insertion in my datagrid my get dataset ds.getChange() update records with identity fiedl and insert records with 'o' value i wannt to send dataset to xml and then using xml stored procedure i want to update sotred procedure how? You will have to elaborate your problem so that others can understand your
requirements better. For details see: www.aspfaq.com/5006 In general, you can pass a OPENXML resultset directly to an INSERT statement like: EXEC sp_xml_preparedocument @i OUTPUT, @doc INSERT temp SELECT .... FROM OPENXML ( ... ) WITH (.. ) EXEC sp_xml_removedocument @i -- Anith |
|||||||||||||||||||||||