how to INSERT records to an OLEDB target ??

microsoft.public.dotnet.framework.adonet

29 Mar 2006 4:58 PM

pamelafluente

Hi

I have a datatable with several field and, particularly, a binary field
(byte[]) (taken from some database) using the OleDB connection.

Now I want to INSERT all the record of this table into a newly CREATEd
table of another database (say mysql or access or sybase or whatever:
just assume it be an arbitrary OleDb connection). I am connected via
the OleDb connection.

My question.
What is the best way to insert these records (I would like to be able
to do the insert whatever be the target (always OleDb)). Any snippet
would be much appreciated. I have already seen several posting on how
to use PARAMETERS, @field, BUT my greatest concern is the binary field.

If you could elaborate a little on the best way to upload the BINARY
stuff, I would be grateful. I have no idea how to deal with it. Is it
sufficient that I assign the byte array to the Value property of a
parameter? Or would this not make any sense?

-Pam