Pic from database as label.image - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Programming
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 08-22-2004, 07:49 PM   #1 (permalink)
Ultra Techie
 
Join Date: Feb 2004
Posts: 833
Default Pic from database as label.image

i have created a multiple choice test as part of a project I am doing at the moment in VB.net ... i have got randomised questions working and am dead happy... apart from one thing! many of my questions (which are loading from a database) have a picture stored in a cell in a column I have called Qpic.

I am really unsure how to reference this picture when getting the question and possible answers!

To get the picture I have tried an SQL query (like the ones i used to get the question for the random question number generated (q)).
Quote:
pc.Open("select Qpic from test1 where Qno =" & q, CN)
I have then tried to get the picture to be the image of a label (PicBox) on my form... it doesnt like what I have tried!

The SQL works fine for my string based queries. for example:
Quote:
rs.Open("select QText from test1 where Qno =" & q, CN)
Qtion = rs.GetString
rs.Close()
QuestionDisp.Text = Qtion
The above works perfectly... but I just cant figure out how to load the image for the same question number (q)

if anyone can help me, it would be much appreciated
__________________
hygor is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 12:32 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.