Insert Image into a Remote SQL

[yefryjunior]

Hi guys..

I used this tutorial

http://www.b4x.com/forum/basic4android-getting-started-
tutorials/13166-connect-android-ms-sql-server-tutorial.html

I'm a beginner, sorry if this question is basic but now, I need to insert an image in a remote SQL. I'm using HttpUtils2, I can insert strings, but I don't know how insert the image.

In ASPNET code Need I to add more code?

Please your help because I'm on time, this is my final project from the university.

http://www.b4x.com/forum/images/smilies/sign0085.gif

Yefry

Regards from Peru

 

[grant1842]

Have you looked at using HttpJob.PostFile ?

 

[yefryjunior]

well, i need to insert image and string in a command

INSERT INTO Tabla1 VALUES ('Value01','Value02',IMAGE)

Please, your help

 

[wl]

You can't just insert a BLOB (binary large object) in MS SQL using the simple insert into syntax.

Please have a look at:
SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach - Joseph Sack - Google Books

 

[yefryjunior]

Please,

Help me, any way or idea to insert a image and text into a remote SQL,

I'm using httputils2 and .aspx

I can't use HttpJob.PostFile because i need to insert text too

Yefry

Thanks a lot

 

[Erel]

The ASP script in that tutorial only accepts strings. You will need to modify it and add a new call that accepts raw bytes. You can send the string parameters as part of the url (GET parameters).

 

[sktanmoy]

A possible way to convert the image into base64 string. You can find some discussions on it.