Problem in Randomly access data from database

Question

I have ms access database and i have a table named Test(ID(primary key)TypeQuestionOption1Option2Option3Option4Answer) and i getting error in it..

Vulpes · Answer

Ah you mean like a slideshow? private Image[] images; private int imageIndex; private void Form1_Load(object sender EventArgs e) { string[] paths = {path1 path2 path3 path4 path5}; images = new Image[paths.Length]; for(int i = 0; i { images[i] = Image.FromFile(paths[i]); } pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage; pictureBox1.Image = images[0]; imageIndex = 0; timer1.Interval = 3000; timer1.Start(); } private void timer1_Tick(object sender EventArgs e) { imageIndex++; if (imageIndex == images.Length) imageIndex = 0; pictureBox1.Image = images[imageindex]; }

Ajay Kadian · Answer

yeah it work fine thanks...

Vulpes · Answer

Sorry just tried it myself and noticed there's a typo: pictureBox1.Image = images[ imageIndex ]; Other than that it's working fine.

Ajay Kadian · Answer

yes i have 5 array of images...

Vulpes · Answer

Are you sure you've got 5 different images in the array?

Ajay Kadian · Answer

It doesn't work when i run the form it only display one which still... And in this line pictureBox1.Image = images[imageindex]; }

Ajay Kadian · Answer

No not like that I want that 4-5 images move like one comes and goes then second comes and so on ...

Vulpes · Answer

Yes we can though I'll just show code for rotating one image 90 degrees every 3 seconds: private void Form1_Load(object sender EventArgs e) { pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage; pictureBox1.Image = Image.FromFile(filePath); timer1.Interval =3000; timer1.Start(); } private void timer1_Tick(object sender EventArgs e) { Image img = pictureBox1.Image; img.RotateFlip(RotateFlipType.Rotate90FlipNone); pictureBox1.Image = img; }

Ajay Kadian · Answer

Yes it works ( select * from QUESTION order by rnd(ID) where[Type]='someValue' )... I have one more question can we rotate set of 4-5 images clockwise in picture box on form load on timer_tick event..

Vulpes · Answer

Did comboBox1.SelectedItem.ToString() work? If it didn't then try hard-coding a value for the 'type' column: select * from QUESTION order by rnd(ID) where[Type]='someValue'

Ajay Kadian · Answer

I right this code it works fines without selecting item from comboBox select *rnd(ID) from Test order by rnd(ID) But there is a problem when i run after closing app the sequence of question are same ..

Vulpes · Answer

This could be a few things. One thing I notice is that you're using comboBox1.Text to set the parameter which could be empty. Instead of that I'd try comboBox1.SelectedItem.ToString().