DataTable

[Guest]

How do I copy the binary data (possibly longer than 8000 bytes) to a
DataTable? What is the syntax to add a column and add data to it like below?

DataTable.Columns.Add("MyBinaryField", ???); (What is the syntax for the 2nd
parameter)

DataRow dr = DataTable.NewRow();
dr["MyBianryField"] = data; (Is this correct if longer than 8000 bytes?)

 

[vj]

You can use string type. I use that to store file streams... I have had no
problems so far...

VJ

 

[Mike]

You can use string type. I use that to store file streams... I have had no
problems so far...

Or I think you can just use an NTEXT on the SQL side, and then a byte[] on
the c# side.

m

VJ

How do I copy the binary data (possibly longer than 8000 bytes) to a
DataTable? What is the syntax to add a column and add data to it like
below?

DataTable.Columns.Add("MyBinaryField", ???); (What is the syntax for the
2nd
parameter)

DataRow dr = DataTable.NewRow();
dr["MyBianryField"] = data; (Is this correct if longer than 8000 bytes?)

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

How do I copy the binary data (possibly longer than 8000 bytes) to a
DataTable? What is the syntax to add a column and add data to it like
below?

DataTable.Columns.Add("MyBinaryField", ???); (What is the syntax for the
2nd
parameter)

DataRow dr = DataTable.NewRow();
dr["MyBianryField"] = data; (Is this correct if longer than 8000 bytes?)

you can use simply object


maybe more details could further refine the answer.