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)).
The SQL works fine for my string based queries. for example:
if anyone can help me, it would be much appreciated
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)).
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!pc.Open("select Qpic from test1 where Qno =" & q, CN)
The SQL works fine for my string based queries. for example:
The above works perfectly... but I just cant figure out how to load the image for the same question number (q)rs.Open("select QText from test1 where Qno =" & q, CN)
Qtion = rs.GetString
rs.Close()
QuestionDisp.Text = Qtion
if anyone can help me, it would be much appreciated