Obtaining the height and width of the image when saving the image in the database

Question

I save my images in my SQL Server database using ASP.NET (2.0).

(imageData → image) (imageType → varchar) (imageLength → bigint)

Thus, imageData will be “Binary Data”, and imageType will look like “image / gif”, and the image length will be “6458” .......

Is it possible to get a HEIGHT and WIDTH image from my VB.NET code inside my ASP.NET? I want to make my notepad on my web form the size of the actual image stored in my database.

Relations Etienne

Answer 1

, :

System.Drawing.Image.FromStream(yourStream).Height

, , , , , .

, . .

, , #, vb.net, , , .

IDataReader, , varbinary etc . , System.IO.Stream. MemoryStream - , , .

System.IO.MemoryStream yourStream = new System.IO.MemoryStream(dr["imgLength"] as byte[]);
System.Drawing.Image yourImage=System.Drawing.Image.FromStream(yourStream);

yourImage.Height;
yourImage.width

Answer 2

. , select , .

, .

Answer 3

, , system.drawing.image, , .

, .

Answer 4

, 2 , .

Answer 5

I firmly believe that after several hundred gigabytes of images, you will find that the file system and static file HTTP servers are better than image storage databases. It also allows you to use thousands of existing free tools for working with images, transfers, hosts, etc. Your database may be busy and not easy to copy.

Answer 6

Dim mobj_wc As New System.Net.WebClient
Dim obj_BookOriginalImage As System.Drawing.Bitmap
Dim ImageInBytes() As Byte = mobj_wc.DownloadData(mstr_BookURL & mds_BookDetails.Tables(0).Rows(0).Item("BookImage"))

'CREATE A MEMORY STREAM USING THE BYTES
Dim ImageStream As New IO.MemoryStream(ImageInBytes)
obj_BookOriginalImage = New System.Drawing.Bitmap(ImageStream)
mint_ImageWidth = obj_BookOriginalImage.Width