excel to binaryvalue

Posted by Oswaldlily under ASP.NET on 4/27/2013 | Points: 10 | Views : 972 | Status : [Member] | Replies : 2
how to convert excel file into binaryvalue in asp.net application.
Need to store ths value in database.
I m using Openfiledialog to select excel file..
BY selecting that need to gets converted to binary value...
To convert excel file into binary value,is it correct in getting filename & convert or Pathname & convert???




Responses

Posted by: Jitendrasoft09 on: 4/27/2013 [Member] [MVP] Starter | Points: 25

Up
0
Down
Dear,
First you have to store data from Excel to DataTable and and store into byte datatype variable using c# code loop and store into bynary datatype of sql server.
Please refer below code that would be helpful for you.
http://forums.asp.net/t/1604365.aspx

Jitendra Kumar
If my post helps you, plz mark as an answer.

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Oswaldlily on: 4/29/2013 [Member] Starter | Points: 25

Up
0
Down
@
Jitendrasoft09

By using Openfiledialog,i ll select any excel file which have to get convert to
binaryvalue..
So how will store into datatable??



Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response