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.

 

[Guest]

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 DataSetSurrogate 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

 

[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?