Problem in Randomly access data from database

Ajay Kadian

I have ms access database and i have a table named Test(ID(primary key),Type,Question,Option1,Option2,Option3,Option4,Answer) and i getting error in it..

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted 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 < paths.Length; 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 Kadian12y ago
yeah it work fine thanks...
Vulpes12y ago
Sorry, just tried it myself and noticed there's a typo:

pictureBox1.Image = images[imageIndex];

Other than that it's working fine.
Ajay Kadian12y ago
yes i have 5 array of images...
Vulpes12y ago
Are you sure you've got 5 different images in the array?
Ajay Kadian12y ago
It doesn't work when i run the form it only display one which still...
And in this line
pictureBox1.Image = images[imageindex];
}
Ajay Kadian12y ago
No not like that I want that 4-5 images move like one comes and goes then second comes and so on ...
Vulpes12y ago
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 Kadian12y ago
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..
Vulpes12y ago
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 Kadian12y ago
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 ..
Vulpes12y ago
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().