ios - Save image taken from iPad/iPhone to sql server database base64 -


I'm having trouble saving SQL Server data from my iPad app, I think it's mostly with data types To start with the database, I have a SQL Server data type as my image field: The image I searched for .NET in an equivalent data type and I found this link: that the best option is a byte array: Byte []

In unit / class I am in .NET I'm doing yoga. Following: Public Classroom MyClass {public byte [image] {get; Set; }} And the parameter used to pass this data looks like this: 

  SqlParameter param_image = cmd.Parameters.Add ("IMAGE", SqlDbType.Image, item.Image. Length;) Param_image.Value = System.Convert.FromBase64String (item.Image); Param_image.Directing = Parameter Direction.Input;   
 However, I'm getting an error from the parameter about trying to convert from string to a byte array. Has anyone done this?   
 
 
 two comments:  
     
  •  
     Item.Image byte [], And not expecting the string as Base64String (maybe this is your error?). Try:  
     param_image.Value = item.Image   
  •  
     You should use varbinary (max) instead of IMAG datatype: IMAGE Data Type Dislikes ( Supported) but will be removed in the future)

Comments

Post a Comment

Popular posts from this blog

python - Assemble mpeg file unable to play in mediaplayer -

I am currently working on a school project and I think that is to gather some problems with the MPEG file I The scope of my project is: 1) Split the MPEG file into pieces of many fixed sizes. 2) Collecting some of them and leaving some part. Problem 1: When I run the file in the media player, it will play the video until it reaches that segment which I left Give it Example: Chunk = ["yui_1", "yui_2", "yui_3", "yui_5", "yui_6"] Duration of each segment: 1 second * If you think I have left the "yui_4" section. * If I went to collect all the parts except "yui_4", then the video will play the first 2 seconds before being hanged throughout the period. Problem 2: When I gather the first part off the part, it is unable to run the full MPEG file is. Duration of each piece: 1 second Example: wheel = ["yui_2", "yui_3", "yui_4", "yui_5", "yui_6"...
Read more

c# - crystal report failed -

I have created a crystal report with parameters, but this does not load the value. It only shows the title, I mean column name only. Please check your code and correct me. And I tried to load that report in PDF format, which shows an error like "Load report failed" Please correct me. Protected Zero Button 2_Click (Object Sender, EventArgs E) {Report Document Reports Document = New Report Document (); Reportdocument.Load (Server.MapPath ("CrystalReport.rpt")); Reportdocument.SetDatabaseLogon ("", "", "Arvind", "My ScamDDB"); Report document. Setpermator val ("mrno", textbox 1. text); CrystalReportViewer1.ReportSource = Report Document; } Secure Zero LinkButton1_Click (Object Sender, EventArgs E) {Exportport (); Private Zero Exports () {MemoriStream Ostream; Response.Clear (); reaction. Buffer = true; Report Document Report Document = New Report Document (); Reportdocument.Load (Server.MapPath ("CrystalReor...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more