ashkan.890
سه شنبه 19 آذر 1392, 07:01 صبح
اول از منوی Add item یک generic handler ادد کن تو برنامت
بعد از کدزیر استفاده کن
public class ImageSlider : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
context.Response.Clear();
if (!String.IsNullOrEmpty(context.Request.QueryString["id"]))
{
int id = Int32.Parse(context.Request.QueryString["id"]);
Image image = GetImage(id);
context.Response.ContentType = "image/jpeg";
image.Save(context.Response.OutputStream, ImageFormat.Jpeg);
}
else
{
context.Response.ContentType = "text/html";
context.Response.Write("<p>Need a valid id</p>");
}
}
public bool IsReusable
{
get
{
return false;
}
}
private Image GetImage(int id)
{
MemoryStream memoryStream = new MemoryStream();
//Retrieve image from Database to a memeory stream.
// If you are using a different method, use it and assign
// the data to the 'memoryStream' variable.
string connectionString = "Data Source=(local);Initial Catalog=DB1;Integrated Security=True";
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
using (SqlCommand sqlCommand = new SqlCommand("SELECT Img FROM Slider WHERE ID = " + id.ToString(), sqlConnection))
{
sqlConnection.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
if (sqlDataReader.HasRows)
{
sqlDataReader.Read();
byte[] btImage = (byte[])sqlDataReader["Img"];
memoryStream = new MemoryStream(btImage, false);
}
}
sqlConnection.Close();
}
return Image.FromStream(memoryStream);
}
}
حالا به src تگ img اینطوری ادرس بده
src="handlerName.ashx?id=your image id"