|
You also seemed to have posted this query in C# forum!
|
|
|
|
|
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
|
|
|
|
|
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 )
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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 )
|
|
|
|
|
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
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
OK Thanks let i ll Wait for Christian's answer for this
Thanks TDDragon
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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 )
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
True. Calculator is an application that is given for beginners starting with VB.
|
|
|
|
|
No one here to do your project. So Try to do your self. when ever you face any problem Then put it into forum. Every one will help you, but you have to try it first.
Good luck.
And Make one habit, while post your question Do Say like
Nut Sophanny wrote: Subject:Re: Hi All!
Just put your rquirment as qustion, other wise no one will look into this
Again Good luck...
|
|
|
|
|
Salve a Tutti ho questa Form su una pagina web
Volevo chiedere se qualcuno mi dice come inviare la stringa di connessione
o meglio in che sequenza inviare i dati della Form
Hello All I have this form over a webpage
I wanted to ask if someone tells me how to send the string connection
Or rather what sequence send data Form
Grazie in anticipo
Aspetta... "input name="20fe1c1e41ca88c835526f191845aaec" value="zWvO2KSlm8any6uVmJdrxQ==" type="hidden">input name="2a62d1ddd25c3c3fa8bacd3e1b25bc09" value="zGmjp5pyMnUlq1klpZqkg==" type="hidden">"
Mrfulvio
|
|
|
|
|
Wrong Language And Wrong Forum
Go here and ask this Question
http://www.codeproject.com/script/comments/forums.asp?forumid=12076[^]
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
|
bjk88 wrote: Any ideas as to the formula that would do this?
You can probably find it in the front or back of any good diary - They usually have things like that.
Alternatively, type in "1 mile as kilometers" into google and it'll do the conversion for you - You can then see what the factor is.
By the way, a wee tip: Convert the miles, feet and inches into one single value first. It means you only have to do one simple conversion. Similarly with the kilometers, metres and centimetres.
|
|
|
|
|
Oh No, I guess you'll never find a solution for such a difficult problem!
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|