Please Help

[naglayas]

Hello Im a beginner one in programming. My first problem is, How can i view a image file from the database(sql 2005) as "image" to visual basic 2005. for example: a text viewed in the textbox from database. the code is. textbox1.text=rs.fields("text").value My problem is how can i view the image from database if the image DATA TYPE IS "image". Please help me. Thank you very much and God bless.

[Colin Angus Mackay]

naglayas wrote:

rs.fields("text").value

What is rs? I don't recognise any class that has a fields method on it.

naglayas wrote:

My problem is how can i view the image from database if the image DATA TYPE IS "image".

The value in an image column will arrive as a byte array. What you do with that byte array really depends on what it actually represents.

---

Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos

[Paul Conrad]

Colin Angus Mackay wrote:

What is rs?

:confused:

[Colin Angus Mackay]

Paul Conrad wrote:

Colin Angus Mackay wrote: What is rs? :confused:

Well, yes, those were exactly my thoughts. The OP has some code with an object called rs and he expects us to know what it is. I've no idea what it is, so it makes it very difficult to help.

---

Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos

[gnadeem]

hi, i suppose this will be helpfull. http://www.codeproject.com/aspnet/CPImageGallery.asp[^] Regards.

[Paul Conrad]

Colin Angus Mackay wrote:

object called rs and he expects us to know what it is. I've no idea what it is

My ultra wild guess is some kind of record set...

[Colin Angus Mackay]

Paul Conrad wrote:

My ultra wild guess is some kind of record set...

But there are no RecordSets in Visual Basic 2005 - so it still leaves me confused.

---

Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos

[Paul Conrad]

Colin Angus Mackay wrote:

RecordSets in Visual Basic 2005

True. I am thinking of the old days with MS Access + VBA and rs was commonly RecordSet. Maybe the OP has the two mixed up. I noticed the OP refers to SQL 2005 so I am really confused about the whole thread :laugh:

[Paul Conrad]

gnadeem wrote:

i suppose this will be helpfull.

It looks like it could. I found it very interesting :)