Hello Experts
I am Using VB.Net 2005 And Sql 2005
I Want to Insertion of Image in to DataBase And its Retrievel And Also Passing of Images to Crystal Reports
I am searching For This
B coz I Have Table Company In that Company Name Addres Phno And Logo of Company,
In All Reports I Pass this Name & Address as PArameter in Crystal Report
also I Wantthe Logo in All report, then Hw to PAss This
If any one Use Like this Plz give The Code of Insertion, Retrieval And Passing of Images to report
Thanx in Advance
Faisal
Depending on what type of database you are using will change the procedure a little but I will give you an example for SQL Server:
Firstly, the field you need to store the data in your database needs to be binary.
Secondly read your image file as a byte array:
- 'Writing file to database
-
Dim oFile As New FileInfo("C:\MyFile.jpg")
-
Dim oCmd As New SqlCommand("Insert into Images(ImageName, ImageData) Values(@FileName, @FileData)", oCon)
-
oCmd.Parameters.AddWithValue("FileName", oFile.Name)
-
oCmd.Parameters.AddWithValue("FileData", System.IO.File.ReadAllBytes(oFile.FullName))
-
oCmd.ExecuteNonReader()
-
-
'Reading from database
-
Dim oCmd As New SqlCommand("Select ImageName, ImageData From Images", oCon)
-
Dim oRdr As SqlDataReader = oCmd.ExecuteReader()
-
System.IO.File.WriteAllBytes("C:\Images\" & oRdr("ImageName"), oRdr("ImageData"))
For a crystal report, you'd need to pass the byte array into a stream before loading an image object instead of writing the image to disk.
- Dim oDataBytes() As Byte = oRdr("ImageName")
-
Dim oDataStrm As New System.IO.MemoryStream(oDataBytes)
-
Dim oImage As Image = Image.FromStream(oDataStrm)
You would then put the image object onto your crystal report... which I haven't done for years, so I'm afraid you're on your own for that part.
142
