How To Retrieve Image from Database in ListView Control in asp.net 3.5

Faisal Ansari

15y16k.NET

Hello guys how r u all ?

Q: How to Retrieve Image from Database in ListView Control in asp.net 3.5?
Actually i was trying but the error was raise that "DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'pic_id'" and i was unable to find the solution for it .. plz help me and guide me

Thanks .

Repy Soon

4 Replies

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

Suthish Nair15y ago
You are mapping wrong column in ItemTemplate (check for column: pic_id in .aspx)
Faisal Ansari15y ago
My Code Here it is ...

Default.aspx.cs
---------------

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
ShowData();
}

private void ShowData()
{
ListView1.DataSource = FetchAllData();
ListView1.DataBind();
}
public DataTable FetchAllData()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CONNECTION"].ConnectionString);
string sql = "select * from UserImageTable";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
protected void btnUpload_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CONNECTION"].ConnectionString);
if (FileUpload1.PostedFile != null && FileUpload1.PostedFile.FileName != "")
{
byte[] image = new byte[FileUpload1.PostedFile.ContentLength];
HttpPostedFile httpImage = FileUpload1.PostedFile;
httpImage.InputStream.Read(image, 0, (int)FileUpload1.PostedFile.ContentLength);

SqlCommand cmd = new SqlCommand("insert into UserImageTable(ImageName, ImageContent) values(@imgName, @imgContent)", con);
cmd.Parameters.Add("@imgName", SqlDbType.VarChar, 50).Value = txtImgName.Text;
cmd.Parameters.Add("@imgContent", SqlDbType.Image, image.Length).Value = image;

con.Open();
cmd.ExecuteNonQuery();
con.Close();
//ShowData();
Response.Write("Image Uploaded");
}
}

Handler.ashx
-------------

<%@ WebHandler Language="C#" Class="Handler" %>

using System;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public class Handler : IHttpHandler {

public void ProcessRequest (HttpContext context)
{
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["CONNECTION"].ConnectionString);
myConnection.Open();
string sqlQuery = "select ImageName, ImageContent from UserImageTable where ImageID=@imgID";
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.Parameters.Add("@imgID", SqlDbType.Int).Value = context.Request.QueryString["id"];
cmd.Prepare();

SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
context.Response.ContentType = reader["ImageName"].ToString();
context.Response.BinaryWrite((byte[])reader["ImageContent"]);
reader.Close();
myConnection.Close();
//context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
}

public bool IsReusable
{
get
{
return false;
}
}

}

Kindly Reply Soon its urgent
Faisal Ansari15y ago
My Code Here it is ...

Default.aspx.cs
---------------

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
ShowData();
}

private void ShowData()
{
ListView1.DataSource = FetchAllData();
ListView1.DataBind();
}
public DataTable FetchAllData()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CONNECTION"].ConnectionString);
string sql = "select * from UserImageTable";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
protected void btnUpload_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CONNECTION"].ConnectionString);
if (FileUpload1.PostedFile != null && FileUpload1.PostedFile.FileName != "")
{
byte[] image = new byte[FileUpload1.PostedFile.ContentLength];
HttpPostedFile httpImage = FileUpload1.PostedFile;
httpImage.InputStream.Read(image, 0, (int)FileUpload1.PostedFile.ContentLength);

SqlCommand cmd = new SqlCommand("insert into UserImageTable(ImageName, ImageContent) values(@imgName, @imgContent)", con);
cmd.Parameters.Add("@imgName", SqlDbType.VarChar, 50).Value = txtImgName.Text;
cmd.Parameters.Add("@imgContent", SqlDbType.Image, image.Length).Value = image;

con.Open();
cmd.ExecuteNonQuery();
con.Close();
//ShowData();
Response.Write("Image Uploaded");
}
}

Handler.ashx
-------------

<%@ WebHandler Language="C#" Class="Handler" %>

using System;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public class Handler : IHttpHandler {

public void ProcessRequest (HttpContext context)
{
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["CONNECTION"].ConnectionString);
myConnection.Open();
string sqlQuery = "select ImageName, ImageContent from UserImageTable where ImageID=@imgID";
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.Parameters.Add("@imgID", SqlDbType.Int).Value = context.Request.QueryString["id"];
cmd.Prepare();

SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
context.Response.ContentType = reader["ImageName"].ToString();
context.Response.BinaryWrite((byte[])reader["ImageContent"]);
reader.Close();
myConnection.Close();
//context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
}

public bool IsReusable
{
get
{
return false;
}
}

}

Kindly Reply Soon its urgent
Jaganathan Bantheswaran15y ago
Hi,

Read this you will get solution.

ListView Control in ASP.NET 3.5
Inserting & Retrieving Images from SQL Server Database without using Stored Procedures

else Post your code portion which gives error.