0

I am working on a Silverlight application.

Is there any way to pass binary data from an application to a stored procedure?

My stored procedure only accepts one XML parameter

I have a file-browse control through which I select a file

I want to save that file in database Image dataype column.

Also I have to pass other parameter in xml like Name,Password,address etc...

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Chirag
  • 375
  • 4
  • 30
  • You're not saying what database you're using - but if you're using SQL Server 2005 or newer, you should no longer use the `Image` datatype - it's deprecated and will be removed sooner or later. Use `VARBINARY(MAX)` instead. – marc_s May 12 '12 at 09:31
  • i am use SqlServer2008 and no issue if i use Varbinary(max) but still my question is how to pass it using XML – Chirag May 12 '12 at 14:03

0 Answers0