displaying image from sql database

Question

how can we display image from sql database to new web page using sqldatareader & binarywrite?? its urgent plz help thanks

ds ps · Answer

my code is as below i could not trace the error.. i just want to display the selected image in new web page. protected void Page_Load( object sender EventArgs e) { int PictureID = 1; //Connect to the database and bring back the image contents & MIME type for the specified picture string ConStr = System.Configuration. ConfigurationSettings .AppSettings.Get( SQLCON ).ToString(); SqlConnection cn = new SqlConnection (ConStr); string SQLQRY = SELECT [MIMEType] [ImageData] FROM ContractImages WHERE [ImageId] = @PictureID ; SqlCommand cmd = new SqlCommand (SQLQRY cn); cmd.Parameters.AddWithValue( @PictureID  PictureID); //PictureTitle.Text.Trim()); cn.Open(); SqlDataReader imagereader = cmd.ExecuteReader( CommandBehavior .CloseConnection); while (imagereader.Read()) { Response.ContentType = imagereader[ MIMEType ].ToString (); Response.BinaryWrite(imagereader[ ImageData ]); } imagereader.Close(); cn.Close(); }

shyamala · Answer

C sharp SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings[SqlConnectionString]); conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = select * from tablename; SqlDataReader dr = cmd.ExecuteReader(); DataList1.DataSource = dt; DataList1.DataBind(); dr.Close(); conn.Close(); Asp.net asp : DataList ID =DataList1 runat =server> ItemTemplate > img src =  style =height:75px; width:75px; alt = /> ItemTemplate > asp : DataList >