how to display only 6 image and page load time change image

Question

how to display only 6 image and page load time change images I bind in repeater but all images display... and select top 6 then only 6 image display and load time not change my image.. please help

Rajeesh Menoth · Answer

ok Paresh Patel  You can refer this article : 1) http://dotnetawesome.blogspot.in/2014/02/how-to-create-simple-image-gallery-using-repeater-control-jquery.html 2) http://codedisplay.com/bind-images-from-folder-to-repeater-to-create-image-album-in-asp-net-c-vb-net/ 3) http://www.c-sharpcorner.com/UploadFile/satyapriyanayak/display-records-horizontally-in-a-repeater-control/

Paresh Patel · Answer

Rajeesh sir please open this site : www.sonisamaj.co.in show featured brides. same How can I do???? this type Re load page then change image

Rajeesh Menoth · Answer

Hi Paresh Patel select top 6 command only display the top 6 values.i don't understand what u mean.can u explain more? Based on condition u can display the images properly.when u specified time for top 6 command in where clause it's will display different images depend upon the time.

Altaf Ansari · Answer

Use paging system By this you can display as much as data you want... specify page limit in Pagination

Paresh Patel · Answer

I also use repeater and top 6 Command. but when page load then my only top 6 images display. please show this website: www.sonisamaj.co.in Load time change image.. How can do?????

Paresh Patel · Answer

I also use repeater and top 6 Command. but when page load then my only top 6 images display. please show this website: www.sonisamaj.co.in Load time change image.. How can do?????

Upendra Pratap Shahi · Answer

Use lazy loading or paging to show only 6 image at a time.

Rajeesh Menoth · Answer

Hi You can use a repeater control in asp.net.then select top 6 value using sql command..it's work perfectly.. remove the data list then put repeater control.

Paresh Patel · Answer

DESIGN VIEW aspx ' Height=100px Width=100px /> Name: '> ' OnClick=Click_viewmoreinfo>View More Details... --%> aspx.cs public void fill() { SqlConnection con = new SqlConnection(@Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\JOHN\Desktop\Viral1\App_Data\Registration.mdf;Integrated Security=True); SqlDataAdapter adpt = new SqlDataAdapter(); adpt = new SqlDataAdapter(select Top 6 Idfnameimage from registration con); DataTable dt = new DataTable(); adpt.Fill(dt); DataList1.DataSource = dt; DataList1.DataBind(); }

Sandeep Chaurasia · Answer

paste your source code here

Paresh Patel · Answer

I already use this command but when page load time not change image.. My out put database in 25 images Display only 6 Image in database and page load time change my image

Sandeep Chaurasia · Answer

Hi use this command SELECT TOP 6 * FROM TBLNAME;