On 9/28/07, Leo <[EMAIL PROTECTED]> wrote:
> 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.
Create FbCommand class for the table and fill CommandText etc. Then
prepare the command. Then clear&fill params with values and execute it
in a loop. Everything should be in one (or few) transaction(s) to
speed-up processing too.
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
