private ImageList FetchAllImages()
{
ImageList imglist = new ImageList();
string qry = "Select * from tbl_ScreenImages";
SqlCommand cmd = new SqlCommand(qry, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach(DataRow dr in dt.Rows)
{
byte[] arr = (byte[])dr["imgNps"];
MemoryStream ms = new MemoryStream(arr);
imglist.Images.Add(Image.FromStream(ms));
}
return imglist;
}
timer_click
int i = 0;
private void timer1_Tick(object sender, EventArgs e)
{
i++;
imageList1 = FetchAllImages();
int imgCount = imageList1.Images.Count;
if (i % 2 != 0)
{
if (i < imgCount)
{
pictureBox1.Image = imageList1.Images[i];
}
else
{
i = 0;
}
Thread.Sleep(500);
}
else
{
if (i < imgCount)
{
pictureBox1.Image = imageList1.Images[i];
}
else
{
i = 0;
}
Thread.Sleep(500);
}
}
Form1_load()
timer1.start();