Click image in datalist and view the clicked image with detail in another page

See more:

C#

ASP.NET

image

datalist

Hi, i'm a beginner here

I have images in datalist which i get from database. I want to be able to click on an image which would than take me to a detail page where the same image would be displayed and the information about the image would be displayed too.

how do i display the image in my detail page ?

i save the image name from my folder in my database , e.g chocolate.jpg

this is my current code not sure if its the correct way of doing it

in product.aspx

<ItemTemplate>

                    
                    <asp:HyperLink ID="hlnk" NavigateUrl='<%# string.Format("ViewProductDetail.aspx?ProductID={0}", Eval("ProductID")) %>' runat="server">
                    
             <asp:Image ID="Image1" runat="server" Height="127px" 
                    ImageUrl='<%# Bind("Picture", "~/Image/{0}") %>' Width="129px" />
                    
                    </asp:HyperLink>

                    <br />
            <asp:Label ID="ProductNameLabel" runat="server" 
                Text='<%# Eval("ProductName") %>' />
            <br />
            <asp:Label ID="PriceLabel" runat="server" 
                Text='<%# Eval("Price","{0:C}") %>' />
            <br />
            <br />
        </ItemTemplate>

in ProductDetail.aspx.cs

protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString.Count != 0)
        {

            int ProductID = Convert.ToInt32(Request.QueryString["ProductID"]);
            if (!IsPostBack)
            {
                string strConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
                SqlConnection myConnect = new SqlConnection(strConnectionString);
                SqlCommand cmd = new SqlCommand("SELECT ProductID, ProductName, Price, Description, Picture FROM Product WHERE ProductID=" + ProductID, myConnect);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds, "Product");

                myConnect.Open();
                SqlDataReader reader = cmd.ExecuteReader();

                if (reader.Read())
                {

                    txtProductName.Text = reader["ProductName"].ToString();
                    txtPrice.Text = reader["Price"].ToString();
                    txtDescription.Text = reader["Description"].ToString();
                    image????

                }
            }
        }
    }

does my ProductDetail.aspx require another datalist?