Sir,
I have used following code,but I have occurred an error like "source code not available" & also "-- C:\Users\Stephen\Documents\Repos\Superexpert\AjaxControlToolkit\Server\AjaxControlToolkit\ExtenderBase\ExtenderControlBase.cs " this error.
The code as follow.
Page source code..
</p>
<asp:Image ID="Image1" runat="server" Height="107px" Width="133px" />
<asp:ScriptManager ID="ScriptManager" runat="server">
</asp:ScriptManager>
<asp:Image ID="Image2" runat="server" Height="122px" Width="127px" />
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
<br />
<asp:Button runat="Server" ID="prevButton" Text="Prev" Font-Size="Medium" />
<asp:Button runat="Server" ID="playButton" Text="Play" Font-Size="Medium" />
<asp:Button runat="Server" ID="nextButton" Text="Next" Font-Size="Medium" />
<asp:SlideShowExtender ID="Slideshowextender" runat="server" PreviousButtonID="Button1"
NextButtonID="Button3" PlayButtonID="Button2" TargetControlID="Image1"
SlideShowServiceMethod="GetImage " PlayInterval="5000" PlayButtonText="Play"
StopButtonText="Stop" UseContextKey="True"></asp:SlideShowExtender>
<br />
</p>
*** .cs code****
private static DataTable tblData = new DataTable();
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=Nildemo;User ID=sa;Password=2008");
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT ID,ImageName,Image FROM Pic", conn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
tblData = new DataTable();
adapter.Fill(tblData);
Slideshowextender.SlideShowServiceMethod = "Handler.ashx?ID =" + Request.QueryString["ID"];
if (tblData.Rows.Count > 0)
{
Image1.ImageUrl = tblData.Rows[0]["Image"].ToString();
}
}
[System.Web.Services.WebMethod]
[System.Web.Script.Services.ScriptMethod]
public static AjaxControlToolkit.Slide[] GetImage()
{
AjaxControlToolkit.Slide[] slides = new AjaxControlToolkit.Slide[tblData.Rows.Count];
for (int i = 0; i < tblData.Rows.Count; i++)
{
DataRow dr = tblData.Rows[i];
slides[i] = new AjaxControlToolkit.Slide();
}
return slides;
}
**** use handalar *****
<%@ WebHandler Language="C#" Class="Handler" %>
using System;
using System.Web;
using System.Data.SqlClient;
using System.Data;
using System.IO;
using System.Collections.Specialized;
public class Handler : IHttpHandler {
public void ProcessRequest(HttpContext context)
{
string id = context.Request.QueryString["ID"];
if (id != null)
{
MemoryStream memoryStream = new MemoryStream();
SqlConnection conn = new SqlConnection("Data Source=KSCPL-PC;Initial Catalog=Nildemo;User ID=sa;Password=2008");
string sql = "SELECT * FROM Pic WHERE ID = @ID";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@ID", id);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
byte[] file = (byte[])reader["Image"];
reader.Close();
conn.Close();
memoryStream.Write(file, 0, file.Length);
context.Response.Buffer = true;
context.Response.BinaryWrite(file);
memoryStream.Dispose();
}
}
public bool IsReusable
{
get
{
return false;
}
}
}