How to make automatic browsing to images from database ?

Posted by Ahmedsa under ASP.NET MVC on 4/28/2017 | Points: 10 | Views : 350 | Status : [Member] | Replies : 3
I work in MVC 5 c# in visual studio 2015 web applications

I have table pictures in SQL server 2012 have two fields

ID

Image

ID have number of image inserted like 1,2,3,4,5

Image field store picture added

what i need actually browsing images found in table pictures in database from last image inserted to first in page

and browsing between every image and another 1 second automatically without using button or scroll

suppose i have 4 images in database in table pictures

after page open picture 4 display after 1 second picture 3 display after 1 second picture 2 display after 1 second picture 1 display .

How i do that please ?




Responses

Posted by: Vuyiswamb on: 5/2/2017 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
hi

The database varbinary field is not a field you want to query every now and then , this will lead to performance issues on your application. i suggest you bring the image in a list and store them in a static object that will keep on the catche so that you dont make many calls to the server.

There are Controls already built to do that , you need a control like the Add Rotator
https://msdn.microsoft.com/en-us/library/d5kd8aka.aspx

like any other control you can bind data to it

Thank you for posting at Dotnetfunda
[Administrator]

Ahmedsa, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ahmedsa on: 5/2/2017 [Member] Starter | Points: 25

Up
0
Down
Thank you for reply
you talking above in web form aspx i read it
what about using asp.net mvc how to automate images in it for best performance
mvc not have ad rotator control
so that what i do to solve problem
can you help me in that

Ahmedsa, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 5/2/2017 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
Look at this https://help.syncfusion.com/aspnetmvc/rotator/getting-started

Thank you for posting at Dotnetfunda
[Administrator]

Ahmedsa, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response