Visual Basic

22-Oct-07 1:15

hi ,

I am having an HTML file Control and if i click add image button to save the image in DataBase, it is getting Save in Database in Format <Binary> Format.
when i am trying to retrive the Image from Database the Image getting Read but no images are displaying i do no Where the Issue is can any one help me to solve this problem

<code>

Private Sub btnSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSave.Click
intImageSize = fileUploadCTRL.PostedFile.ContentLength
strImagetype = fileUploadCTRL.PostedFile.ContentType
ImageStream = fileUploadCTRL.PostedFile.InputStream
Dim ImageContent(intImageSize) As Byte
intsize = ImageStream.Read(ImageContent, 0, intsize)
Dim sqlconn As New SqlConnection(ConfigurationSettings.AppSettings("BILL_CONSTR"))
Dim sqlcommand As New SqlCommand("sp_Image", sqlconn)
sqlcommand.CommandType = CommandType.StoredProcedure

Dim sqlParams As New SqlParameter("@PersonImage", SqlDbType.Image)
sqlParams.Value = ImageContent
sqlcommand.Parameters.Add(sqlParams)

Dim prmPersonImageType As New SqlParameter("@PersonImageType", SqlDbType.VarChar, 255)
prmPersonImageType.Value = strImagetype
sqlcommand.Parameters.Add(prmPersonImageType)

Try
sqlconn.Open()
sqlcommand.ExecuteNonQuery()
sqlconn.Close()
Response.Write("New Image Added Successfully")
Catch SQLex As SqlException
Response.Write("Insert Failed. Error Details are: " & SQLex.ToString())
End Try
End Sub

</code>

uSing Above I am Saving an Image to the Database and getting saved but
Below is the Coding to retrive . but no Images are getting Displayed.

<code>

Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("BILL_CONSTR"))

Dim myCommand As New SqlCommand("Select * from Person", myConnection)

Try

myConnection.Open()

Dim myDataReader As SqlDataReader

myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)

Do While (myDataReader.Read())
Response.BinaryWrite(myDataReader.Item("PersonImage"))
Loop

myConnection.Close()

Response.Write("Person info successfully retrieved!")

Catch SQLexc As SqlException

Response.Write("Read Failed : " & SQLexc.ToString())

End Try
End Sub

</code>

I am getting only the message retrived successfully but not image

sathimailin

Christian Graus22-Oct-07 1:30

Christian Graus

22-Oct-07 1:30

To write an image out of your DB, you need to write the correct MIME type also, and you need to not write anything else. To show images in your website, and show them with other stuff on the same page, they need to be on the file system, that's why it makes more sense to store file paths in your SQL Server DB.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Satish_S22-Oct-07 18:21

22-Oct-07 18:21

s it is an ASP.NET and Thanks TDDragon and christian for taking up this issue .
But is there any possiblity or not to store the image in DB and to retrive?

sathimailin

Tom Deketelaere22-Oct-07 1:31

22-Oct-07 1:31

from what I can see there is nothing in you're code that would show the image. you have a response.binarywrite in there (I'm not too familier with this) wich I think will only show you lots of 1's and 0's.
If you have a form (wich I presume you have) put a imagebox on it then in code create a variable of the type image and fill it with the data that you receive. After that you can simply set the image property of the imagebox to the variable image.

on a side note:

sathimailin1 wrote:
Dim myCommand As New SqlCommand("Select * from Person", myConnection)

I would recommend never to use * in sql statements. Instead put the names of the columns in there that you need and only those names (its better perfomance wise)

hope this helps

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistakes.

Christian Graus22-Oct-07 1:44

Christian Graus

22-Oct-07 1:44

TDDragon wrote:
you have a response.binarywrite in there (I'm not too familier with this) wich I think will only show you lots of 1's and 0's.

You're very wrong. The worst it could do is show a lot of text. A 1 or a 0 is in fact only going to be shown if the ASCII code for 1 or 0 is present in a text string.

A binary write is the right way to feed binary data through a browser, but only if the MIME type is also set, to tell the browser what it's trying to display

TDDragon wrote:
put a imagebox on it then in code create a variable of the type image and fill it with the data that you receive.

Yes, if this is not an ASP.NET question ( which I assumed it was ), then the data can be put into a stream and a bitmap constructed from that. However, Response.Write and Response.BinaryWrite in the code, means it was an ASP.NET question. You can't put an image into a web page from a binary stream, it needs to exist on the file system.

TDDragon wrote:
(its better perfomance wise)

I don't believe that's true in any meaningful way, unless the data table turns out to have extra columns than what you'd anticipate. I'd suggest the real issue here is that SQL should not be dynamically generated from strings like this, it should exist in a data layer.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Tom Deketelaere22-Oct-07 2:02

22-Oct-07 2:02

Christian Graus wrote:
You're very wrong. The worst it could do is show a lot of text. A 1 or a 0 is in fact only going to be shown if the ASCII code for 1 or 0 is present in a text string.

A binary write is the right way to feed binary data through a browser, but only if the MIME type is also set, to tell the browser what it's trying to display

Thank you for the correction (like I said I'm not familier with this)

Christian Graus wrote:
if this is not an ASP.NET question

I hadn't noticed this.
If so you're way is indeed the way to go

Christian Graus wrote:
I don't believe that's true in any meaningful way, unless the data table turns out to have extra columns than what you'd anticipate.

I have noticed performance differences in my projects but they do only occure when my tabel has more columns then I need in that particular sql statement (like you said). But not using * in sql gives you the option to add columns to the table later without changing the performance of the programme.

Christian Graus wrote:
I'd suggest the real issue here is that SQL should not be dynamically generated from strings like this, it should exist in a data layer.

Also very true Poke tongue | ;-P

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistakes.

Satish_S22-Oct-07 3:06

22-Oct-07 3:06

s it is an ASP.NET and Thanks TDDragon and christian for taking up this issue .
But is there any possiblity or not to store the image in DB and to retrive?

sathimailin

Satish_S22-Oct-07 1:55

22-Oct-07 1:55

Dim img1 As Image
img1 = myDataReader.Item("PersonImage")

this is the variable i have used but how to Assign an Image from DB to this control i am not getting it Clear .

sathimailin

Tom Deketelaere22-Oct-07 2:05

22-Oct-07 2:05

If this is an ASP.NET project: ignore my post and look at christian's

If not: then you will have a windows form on wich you can add a imagebox (from the toolbox) wich has a property image (or somthing like this) to wich you assign a variable of the type image

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistakes.

Satish_S22-Oct-07 2:17

22-Oct-07 2:17

s it is an ASP.NET and Thanks TDDragon and christian for taking up this issue .
But is there any possiblity or not to store the image in DB and to retrive?

sathimailin

Tom Deketelaere22-Oct-07 2:26

22-Oct-07 2:26

sathimailin1 wrote:
But is there any possiblity or not to store the image in DB and to retrive?

not shure what you mean by this but if you mean you don't want to store the image in the db but still want to be able to show the image this is how you can do it:

you can make a map (lets call it images) on the place where you host you're site. then instead of saving the image in the db you just save it's name in the db (where you save the image now) and you move or copy the image to the map 'images'. That way all you have to do is retrieve the name of the image from the db and you can display it any way you want. (I'm far from a ASP specialist so for more detail on this you'll need to ask christian or someone else in the ASP.NET forum)

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistakes.

Satish_S22-Oct-07 2:31

22-Oct-07 2:31

OK Thanks let i ll Wait for Christian's answer for this
Thanks TDDragon

Tom Deketelaere22-Oct-07 2:58

22-Oct-07 2:58

You might want to repost you'r question in reply to christians post so that he get's a notification otherwise I doubt that he'll find you'r question

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistakes.

Hi All!

Nut Sophanny22-Oct-07 0:16

Nut Sophanny

22-Oct-07 0:16

Create a project named "calculator",consist a form named"calc".The project is provided with a calculator which can also be used for rough currency conversions.
1.Making a calculation
It can calculate with the following operator:
+ to add
- to substract
* to multiply
/ to provide
= to execute(equal)
2.Making a currency conversion
This option can set exchange rate for multiple currencies.
exchange from US dollars to KH Riels.]
Note:$ 1=4,000 Riels

Christian Graus22-Oct-07 0:29

Christian Graus

22-Oct-07 0:29

Yeah, I tell beginners that a calculator is an awesome first project. Good luck with it. I'm not sure why you've posted your homework question here, is it meant to be some sort of heads up so that when you ask real questions, after working on this yourself, we'll have a heads up ? Anyone here would find this project trivial, but of course, you wouldn't want us to do it for you, because you wouldn't learn anything that way, right ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Jonathan [Darka]22-Oct-07 1:12

Jonathan [Darka]

22-Oct-07 1:12

I hope you fail your course for this pathetic attempt at getting someone to do your homework for you.

This is a trivial application, you should be ashamed.

Jonathan Wilkes
Darka[Xanya.net]

Tom Deketelaere22-Oct-07 1:23

22-Oct-07 1:23

if this is his first application its a good one to get started with.
but by posting this here he tells us he is to lazy to learn and wants others to do his work for him.
To bad for him that will not work here.

also this application is given to students all over the worlk as one of there first 'real' projects so I'm pretty shure he's trying to make us do his homework.

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistakes.

Vasudevan Deepak Kumar22-Oct-07 4:24

Vasudevan Deepak Kumar

22-Oct-07 4:24

True. Calculator is an application that is given for beginners starting with VB. Big Grin | :-D

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips