Friday, May 17, 2024
 Popular · Latest · Hot · Upcoming
143
rated 0 times [  149] [ 6]  / answers: 1 / hits: 92197  / 13 Years ago, mon, february 13, 2012, 12:00:00

I am struggling converting image to byte array using client side script. I have to convert image to byte array, and pass this array to web service , so that the web services can save the image in sql server. Any one please help me.


More From » sql-server

 Answers
132

i have found one solution. :)



in html javascript file, first convert the uploaded image to base64 image format using following code.



var p;
var canvas = document.createElement(canvas);
var img1=document.createElement(img);

function getBase64Image(){
p=document.getElementById(fileUpload).value;
img1.setAttribute('src', p);
canvas.width = img1.width;
canvas.height = img1.height;
var ctx = canvas.getContext(2d);
ctx.drawImage(img1, 0, 0);
var dataURL = canvas.toDataURL(image/png);
alert(from getbase64 function+dataURL );
return dataURL;
}


so we got base64 code of uploaded image in dataURL.



NOW SEND THIS BASE64 CODE (dataURL) to web service and convert the base64 string to byte array using following code and save to sql server too



c# code--for converting base64 to byte arry and to store on sql



private void Form1_Load(object sender, EventArgs e) {
int userid = 5;
string base64=;// load base 64 code to this variable from js
Byte[] bitmapData = new Byte[base64.Length];
bitmapData = Convert.FromBase64String(FixBase64ForImage(base64));
string connstr = @user id=sa; password=*****;
database=ImageTest;
server=192.168.1.104;
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
string query;
query = insert into imagetable(userid,image) values( + userid + , + @pic);
SqlParameter picparameter = new SqlParameter();
picparameter.SqlDbType = SqlDbType.Image;
picparameter.ParameterName = pic;
picparameter.Value = bitmapData;
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.Add(picparameter);
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
conn.Dispose();
}
public static string FixBase64ForImage(string image) {
StringBuilder sbText = new StringBuilder(image, image.Length);
sbText.Replace(rn, String.Empty);
sbText.Replace( , String.Empty);
return sbText.ToString();
}


hope u understand :) ......


[#87503] Sunday, February 12, 2012, 13 Years  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
dantel

Total Points: 7
Total Questions: 102
Total Answers: 97

Location: Saint Lucia
Member since Sat, Jun 6, 2020
4 Years ago
;