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

Question

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

Suthish Nair · Answer

You are mapping wrong column in ItemTemplate (check for column: pic_id in .aspx)

Faisal Ansari · Answer

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 ------------- 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 Ansari · Answer

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 ------------- 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 Bantheswaran · Answer

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.