Display Image using DataList Control in ASP.NET

CREATE PROCEDURE insert_photo
(      
@name varchar(50),
@pic varchar(50)
)
AS
Insert into test values (@name,@pic)



<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="ADD_Retrieve_IMAGES_datalist._Default" %>





   


   

   
       
           
           
       
      
       
           
           
       
       
           
           
       
        

Name	ControlToValidate="txt_name" ErrorMessage="Please enter the name">
Picture	ControlToValidate="FileUpload1" ErrorMessage="Please browse the image">
	Text="Insert" />

   

   
   
       
       

Photo Details

   
               
               
               
               
               
               
               
               
               
               
               

Name	Picture
<%# Eval("name") %>

               
   
   

   

using System;
using System.Collections;
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;
using System.IO;
namespace ADD_Retrieve_IMAGES_datalist
{
    public partial class _Default : System.Web.UI.Page
    {
        string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        string s1;
        string path;
        SqlConnection cnn = new SqlConnection();
        SqlCommand com = new SqlCommand();
        SqlDataAdapter sqlda;
        DataTable dt;
      

        protected void btn_insert_Click(object sender, EventArgs e)
        {
            if (FileUpload1.PostedFile.ContentLength > 0)
            {
                s1 = Path.GetFileName(FileUpload1.FileName);
                path = Server.MapPath("images") + "/" + s1;
                FileUpload1.SaveAs(path);
            }

            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            SqlCommand com = new SqlCommand("insert_photo", con);
            com.CommandType = CommandType.StoredProcedure;
            com.Connection = con;
            com.Parameters.AddWithValue("@name", txt_name.Text);
            com.Parameters.AddWithValue("@pic", s1);
            com.ExecuteNonQuery();
            com.Dispose();
            binddatalist();
            con.Close();
            clear();
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                binddatalist();
            }
        }
        private void clear()
        {
            txt_name.Text = "";
        }
        private void binddatalist()
        {
            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            sqlda = new SqlDataAdapter("SELECT * FROM test ", con);
            dt = new DataTable();
            sqlda.Fill(dt);
            sqlda.Dispose();
            DataList1.DataSource = dt;
            DataList1.DataBind();
            con.Close();
        }
    }
}

you can modify the below code

hi binees,

check this line:

cmd.Parameters.Add("@employeename",txtEmployeeName.Text)

Here the aspx code:-


   

   

I do the coding, then another error comes.

Hi,
        Modify the below code like this

public void GalleryView()
    {
        if (sqlCon.State == ConnectionState.Closed)
        {
            sqlCon.Open();
        }
        SqlCommand cmd = new SqlCommand("imageViewAll", sqlCon);
        SqlDataAdapter sqlda = new SqlDataAdapter(cmd);
        DataTable dtbl = new DataTable();

sqlda .Fill(dtbl);
        dlImages.DataSource = dtbl;
        dlImages.DataBind();
        dlImages.Attributes.Add("bordercolor", "black");
    }