Monday, August 11, 2008

Reading and writing file in Table using binary

Just follow up my steps,so that you will get clear idea.

step 1:

Create table with the folowing column, The columns are content type, filename and filedata. if you want also create some additional columns.

for "filedata" column choose datatype called "image" in the datatype list.

Note:if you choose binary datatype instead of image. unable to insert large data in to the table.

writing file in to the table

step 2:

just convert your data file to binary format, After that do insert in to table.

step 3: