affiliate marketing Dot Net Posts: image slide show in asp.net using ajax slideextender

Friday, 24 June 2011

image slide show in asp.net using ajax slideextender


suppose your image folder name is "TempImages"

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using FidesTech;

public partial class SlideShowTest : System.Web.UI.Page
{
private static DataTable tblData = new DataTable();

protected void Page_Load(object sender, EventArgs e)
{
if (this.IsPostBack)
return;

DBConnection db = new DBConnection();
string strSQL = "SELECT tbl_advertisment.ImagePath FROM tbl_advertisment";
MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(ConfigurationManager.AppSettings["connectionString"]);
conn.Open();

MySql.Data.MySqlClient.MySqlCommand comm = new MySql.Data.MySqlClient.MySqlCommand(strSQL, conn);
MySql.Data.MySqlClient.MySqlDataAdapter da = new MySql.Data.MySqlClient.MySqlDataAdapter(comm);
tblData = new DataTable();
da.Fill(tblData);
conn.Close();

// set the initial image
if (tblData.Rows.Count > 0)
{

// string seperated by '/'
// I am spliting path because in my database image path is saved like this format
//~/TempImages/image.jpg
//If you store your images with folder name then you also split the image path
//other wise if you just store the image name like image1.jpg then you dont need
//split the image path
//

string info = tblData.Rows[0]["ImagePath"].ToString();

string[] arInfo = new string[2];

// define which character is seperating fields
char[] splitter = { '/' };

arInfo = info.Split(splitter);

imgShowImage.ImageUrl = "TempImages/" + arInfo[2];
}
}

[System.Web.Services.WebMethod]
[System.Web.Script.Services.ScriptMethod]
public static AjaxControlToolkit.Slide[] GetSlides()
{
AjaxControlToolkit.Slide[] slides = new AjaxControlToolkit.Slide[tblData.Rows.Count];
string imagepath = "";
for (int i = 0; i < tblData.Rows.Count; i++)
{
DataRow dr = tblData.Rows[i];
string info = dr["ImagePath"].ToString();
string[] arInfo = new string[2];
// define which character is seperating fields
char[] splitter = { '/' };
arInfo = info.Split(splitter);
imagepath = arInfo[2];
slides[i] = new AjaxControlToolkit.Slide("TempImages/" + imagepath,"Image name","Image Description");
}
return slides;
}

}

No comments:

Post a Comment