3 Replies - 9689 Views - Last Post: 29 May 2010 - 01:12 AM Rate Topic: -----

#1 huma samrin  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 14
  • Joined: 05-April 08

SAVE EXCEL SHEET in Database Using C#

Posted 26 May 2010 - 11:38 AM

Hello Dear All,


i ve a query, can we save .xls files in database directly ??
i want the whole file with extension .xls as a field in table
i am not sure is it possible or not, i googled abt this topic but couldnt find any solution


Thanks in advance :helpsmilie:
Is This A Good Question/Topic? 0
  • +

Replies To: SAVE EXCEL SHEET in Database Using C#

#2 FlashM  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 382
  • View blog
  • Posts: 1,195
  • Joined: 03-December 09

Re: SAVE EXCEL SHEET in Database Using C#

Posted 26 May 2010 - 12:04 PM

What you could do is to store your excel file as binary data directly into your database, but it's prefered not to do that. You should always store your files (images, excel files, etc...) to your hard drive. Keep only file paths in your database. Why would you even want to store your excel files in database?
Was This Post Helpful? 0
  • +
  • -

#3 huma samrin  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 14
  • Joined: 05-April 08

Re: SAVE EXCEL SHEET in Database Using C#

Posted 28 May 2010 - 11:06 PM

thanks Flash,

Is this Possible that i Open Excel file from one PC(let say server) and Save it in other PC(Client)

I used Socket Programming as


Socket m_socListener = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
IPAddress IPAdd = IPAddress.Parse("192.168.0.4");
IPEndPoint remoteEP = new IPEndPoint(IPAdd, 808);

Socket m_socClient = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
m_socClient.Connect(remoteEP);

But Its giving error
Remote server is refused to accees

Is this can be done by Socket programing, or there is some other way to do this ???
Was This Post Helpful? 0
  • +
  • -

#4 FlashM  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 382
  • View blog
  • Posts: 1,195
  • Joined: 03-December 09

Re: SAVE EXCEL SHEET in Database Using C#

Posted 29 May 2010 - 01:12 AM

Don't know much about networking, but it should be possible since there is a way of sending files across network and sharing them with different clients.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1