DataTable (or CSV) into Binary Data

[stockblaster]

Hello all..
Is it possible to convert a DataTable (i create the DataTable from a
CSV file) into binary data and save it into an sql 2005 table (into
binary field).
After that I want to have the ability to add a row to the beginning of
the to the binary data..
And ability to remove a row..
I searched a lot on the web and it seems i can't find an answer.
if i scheme what i want:
[temp.csv] --->DataTable--> [Binary Data] ---> [SQL]
My question is:
How to save Binary Data into SQL is not a problem. I found many
articles about this.
How to move the temp.csv data to a DataTable is not a problem also..
But how to convert the DataTable file into Binary Data is the problem
and how to modify/read the data if needed.. (Usually needed only Delete

and Insert 1 row) .. Read is simply reading all the rows.
Hope someone have an idea about this issue.

[Peter Bromberg [C# MVP]]

in .NET Framework 2.0, the DataSet offers a binary Serialization option, and
you can pass it into a BinaryFormatter and get back an array of bytes.
In the 1.0 Framework, you would need to use a DataSetSurrogat e class to
"Flatten out" the dataset to binary serializable things like arraylists, as
the 1.0 DataSet can only describe itself to serializers in XML - which
results in a huge amount of data to store.

Search on "Compressed DataSet" to see some stuff on this.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"st**********@g mail.com" wrote:

Hello all..
Is it possible to convert a DataTable (i create the DataTable from a
CSV file) into binary data and save it into an sql 2005 table (into
binary field).
After that I want to have the ability to add a row to the beginning of
the to the binary data..
And ability to remove a row..
I searched a lot on the web and it seems i can't find an answer.
if i scheme what i want:
[temp.csv] --->DataTable--> [Binary Data] ---> [SQL]
My question is:
How to save Binary Data into SQL is not a problem. I found many
articles about this.
How to move the temp.csv data to a DataTable is not a problem also..
But how to convert the DataTable file into Binary Data is the problem
and how to modify/read the data if needed.. (Usually needed only Delete

and Insert 1 row) .. Read is simply reading all the rows.
Hope someone have an idea about this issue.

[stockblaster]

Hello

I am using ASP.NET 2.0... I will check Compressed DataSet on the web ,
i hope this is what i need.

Thanks for taking the time to reply me.

[stockblaster]

Hello

I have read about the Compressed DataSet. If i use this method i will
be able to compress the DataSet into an Binary format and save it on my
sql data base on a binary field.. But if i wish to Add new row to that
binary format? i will have to convert it to DataSet --> add new line
--> pass back to binary format --> save in sql database?