将客户端图片保存到数据库

1.将客户端图片保存到数据库

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

protected void Button4_Click(object sender, EventArgs e)        {            HttpPostedFile upPhoto = f_1.PostedFile;            int upPhotoLength = upPhoto.ContentLength;            byte[] PhotoArray = new Byte[upPhotoLength];            Stream PhotoStream = upPhoto.InputStream;            PhotoStream.Read(PhotoArray, 0, upPhotoLength);/////////////              string constr = "Data Source=192.168.10.58; Initial Catalog=saveImagesDB; user ID=sa; password=123; pooling=true;";            string strSQL = "insert into T_image(id,imageobj)values(@id,@imageobj)";            SqlConnection con = new SqlConnection(constr);            SqlCommand com3 = new SqlCommand(strSQL, con);            Random ro = new Random();            string id = ro.Next(1000).ToString();            com3.Parameters.Add("@id", SqlDbType.VarChar).Value = id;            com3.Parameters.Add("@imageobj", SqlDbType.Image).Value = PhotoArray;            com3.Connection.Open();            com3.ExecuteNonQuery();        }