From: Leo <l3...@br...> - 2007-09-28 18:35:08
|
Hey, I have a web-service that accepts a string that contains a xml and a string that contain some table name. My XML file is like: <root> <row> <name>my name</name> <age>99</age> </row> <row> <name>another name</name> <age>65</age> </row> </root> and the table has the fields "NAME" and "AGE". I need to insert all the data on that xml on the table. I was thinking in read the xml nodes, create the insert commands dynamically and use a FBScript object to execute all inserts in a batch operation. I have never programmed in .NET so I may be in the wrong way... can someone please tell me if is this the right (and fastest) method of doing what i need? Important to note that I have multiple xml files with different structures (and multiple tables), thats why I need it to be dynamic. ps.: sorry for the bad english :( |