DOTNET POINT: JQuery lightbox image slideshow gallery in asp.net

Introduction:

In this article I will explain how to create lightbox image slideshow in asp.net using JQuery.

Description:

In previous post I explained about Ajax SlideshowExtender sample to display images slideshow. Now in this article I will explain how to create lightbox image slideshow in asp.net using JQuery. In many websites generally we will see different types of slideshows like whenever we click on image that is automatically open with lightbox effect and we have a chance to see all the remaining images by press next or previous options in slideshow. All these Slideshows are implemented by using JQuery plugins. After seen those slideshows I decided to write post to use JQuery plugins to implement beautiful slideshown in asp.net.

To implement this one I am using previous post insert and display images from folder based on imagepath in database because in that post I explained clearly how to insert images into our project folder and insert images path into database and display images in gridview from images folder based on Images path in database.

To implement slideshow concept first design table in your database as shown below

Column Name	Data Type	Allow Nulls
ID	int(set identity property=true)	No
ImageName	varchar(50)	Yes
Description	nvarchar(max)	Yes

After completion of table creation Open Visual Studio and create new website after that right click on your website and add new folder and give name as SlideImages because here I used same name for my sample if you want to change folder name then you need to change the Slideimages folder name in your code behind also after that write the following code in your aspx page

<title>Display Images Slideshow in asp.net using JQuery</title>

</head>

<body>

<div>

<tr>

</tr>

<tr>

<td>

Upload Image:

</td>

<td>

<asp:FileUpload ID="fileuploadimages" runat="server" />

</td>

</tr>

<tr>

<td>

Enter Image Desc:

</td>

<td>

<asp:TextBox ID="txtDesc" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td>

</td>

<td>

<asp:Button ID="btnSubmit" runat="server" Text="Submit" onclick="btnSubmit_Click" />

</td>

</tr>

<tr>

<asp:DataList ID="dlImages" runat="server" RepeatColumns="3" CellPadding="5">

<a id="imageLink" href='<%# Eval("ImageName","~/SlideImages/{0}") %>' title='<%#Eval("Description")%>' rel="lightbox[Brussels]" runat="server" >

<asp:Image ID="Image1" ImageUrl='<%# Bind("ImageName", "~/SlideImages/{0}") %>' runat="server"Width="112" Height="84" />

</a>

</ItemTemplate>

<ItemStyle BorderColor="Brown" BorderStyle="dotted" BorderWidth="3px" HorizontalAlign="Center"

VerticalAlign="Bottom" />

</asp:DataList>

</td>

</tr>

</table>

<br />

</div>

</form>

</body>

</html>

If you observe above code in header section I added some of script files and css file by using those files we will get lightbox effect slideshow. To get those files download attached sample code and use it in your application.

Another thing here we need to know is href link

<a href='<%# Eval("ImageName","~/SlideImages/{0}") %>' id="imageLink" title='<%#Eval("Description")%>' rel="lightbox[Brussels]" runat="server" >

In above tag I added rel="lightbox" this tag is used to active lightbox title this attribute is used to display image caption. If we have set of related images to group we need to include group name in between square brackets in rel attribute like rel="lightbox[Brussels]"

After completion of aspx page design add following namespaces in code behind

C# Code

using System;

using System.Data;

using System.Data.SqlClient;

using System.IO;

After add namespace write the following code

SqlConnection con = new SqlConnection("Data Source=SureshDasari;Initial Catalog=MySampleDB;Integrated Security=true");

protected void Page_Load(object sender, EventArgs e)

{

if(!IsPostBack)

{

BindDataList();

}

protected void BindDataList()

{

con.Open();

//Query to get ImagesName and Description from database

SqlCommand command = new SqlCommand("SELECT ImageName,Description from SlideShowTable", con);

SqlDataAdapter da = new SqlDataAdapter(command);

DataTable dt = new DataTable();

da.Fill(dt);

dlImages.DataSource = dt;

dlImages.DataBind();

con.Close();

}

protected void btnSubmit_Click(object sender, EventArgs e)

{

//Get Filename from fileupload control

string filename = Path.GetFileName(fileuploadimages.PostedFile.FileName);

//Save images into SlideImages folder

fileuploadimages.SaveAs(Server.MapPath("SlideImages/" + filename));

//Open the database connection

con.Open();

//Query to insert images name and Description into database

SqlCommand cmd = new SqlCommand("Insert into SlideShowTable(ImageName,Description) values(@ImageName,@Description)", con);

//Passing parameters to query

cmd.Parameters.AddWithValue("@ImageName", filename);

cmd.Parameters.AddWithValue("@Description", txtDesc.Text);

cmd.ExecuteNonQuery();

//Close dbconnection

con.Close();

txtDesc.Text = string.Empty;

BindDataList();

}

VB.NET Code

Imports System.Data

Imports System.Data.SqlClient

Imports System.IO

Partial Class _Default

Inherits System.Web.UI.Page

Private con As New SqlConnection("Data Source=SureshDasari;Initial Catalog=MySampleDB;Integrated Security=true")

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load

If Not IsPostBack Then

BindDataList()

End If

End Sub

Protected Sub BindDataList()

con.Open()

'Query to get ImagesName and Description from database

Dim command As New SqlCommand("SELECT ImageName,Description from SlideShowTable", con)

Dim da As New SqlDataAdapter(command)

Dim dt As New DataTable()

da.Fill(dt)

dlImages.DataSource = dt

dlImages.DataBind()

con.Close()

End Sub

Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As EventArgs)

'Get Filename from fileupload control

Dim filename As String = Path.GetFileName(fileuploadimages.PostedFile.FileName)

'Save images into SlideImages folder

fileuploadimages.SaveAs(Server.MapPath("SlideImages/" & filename))

'Open the database connection

con.Open()

'Query to insert images name and Description into database

Dim cmd As New SqlCommand("Insert into SlideShowTable(ImageName,Description) values(@ImageName,@Description)", con)

'Passing parameters to query

cmd.Parameters.AddWithValue("@ImageName", filename)

cmd.Parameters.AddWithValue("@Description", txtDesc.Text)

cmd.ExecuteNonQuery()

'Close dbconnection

con.Close()

txtDesc.Text = String.Empty

BindDataList()

End Sub

End Class

Now run your application and enter images description and upload some of the images using upload control after that your page should be like this

Now click on any image slideshow will begin with lightbox effect. Check the below demo

If you observe above image in this lightbox slideshow we are having different features like auto playing,navigate images using ‘prev’ and ‘next’ links, show image description and stop slideshow options and many more.

In slideshow we can navigate by using keyboard shortcuts

f- first image

l- last image

x and c to close

left arrow and p for previous image

right arrow and n for next image

Download sample code attached

DOTNET POINT

Wednesday, 28 December 2011

JQuery lightbox image slideshow gallery in asp.net

No comments:

Post a Comment