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

Paresh Patel

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

12 Replies

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

Rajeesh Menoth11y ago
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 Patel11y ago
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 Menoth11y ago
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 Ansari11y ago
Use paging system By this you can display as much as data you want... specify page limit in Pagination
Paresh Patel11y ago
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 Patel11y ago
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 Shahi11y ago
Use lazy loading or paging to show only 6 image at a time.
Rajeesh Menoth11y ago
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 Patel11y ago

DESIGN VIEW aspx

Name:
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 Id,fname,image from registration", con);

DataTable dt = new DataTable();

adpt.Fill(dt);

DataList1.DataSource = dt;

DataList1.DataBind();

}

Sandeep Chaurasia11y ago
paste your source code here
Paresh Patel11y ago
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 Chaurasia11y ago
Hi use this command SELECT TOP 6 * FROM TBLNAME;