Reg:Image Data retrival Form SQL SERVER 2000 - Visual Basic Discussion Boards

Dave Kreskowiak wrote:
VB6 6 years ago.

Took me a second to realise that wasn't a typo...

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 )

Hi all,
I m tryin to write data from Visual Basic (VB) to Excel sheet.

I m writing data into three different excel files with one at a time. The logic works fine for writing the data but the problem is displaying the files.

First excel is displayed perfectly. But when I write in second excel file & try to open it while the first is opened, the second automatically becomes hidden.

This file can only be seen from Excel menu: Windows -> Unhide.

Wht must be the problem of file becoming automatically hidden? I hv even written the command of Xlsheet.visible = true but still it doesnt work.

Can u pls guide me to identify the problem ???

Thank you.

You could set the Workbook visible property to false for the workbook you don't want to see

objApp.Workbooks.Add()
Dim firstname As String = objApp.ActiveWorkbook.Name
objApp.Workbooks.Add()
Dim secondName As String = objApp.ActiveWorkbook.Name

objApp.Windows(secondName).Visible = False

Thanx for the reply.
Ya I hv done tht but see hiding the worksheet is not my problem. My prb is unhiding the hidden worksheet.

Is there any command in VB by which I can unhide the hidden excel worksheet ?

' To set the visible property to True on ALL sheets in workbook
Sub Un_Hide_All()
Dim sh As Worksheet
For Each sh In Worksheets
sh.Visible = True
Next
End Sub

Hi, i m building a html editor, all i want is how to insert a background image.
I have done it by replacing the tag with

but i wana somthing more professional... plz help me...

King

You also seemed to have posted this query in C# forum!

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

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 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.

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.

Jonathan Wilkes
Darka[Xanya.net]

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. Big Grin | :-D

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips