<asp:datagrid id="GridView1" CellPadding="3" Width="304" Runat="server"
BackColor="#FFFFFF" forecolor="#000000"
ShowHeader="True" AutoGenerateColumns="False"
BorderColor="black" HeaderStyle-Font-Bold="true"
HeaderStyle-BackColor="#dcdcdc"
HeaderStyle-ForeColor="#00015E" Font-Size="8pt" Font-Name="arial"
BorderStyle="None" GridLines="None">
<Columns>
<asp:BoundColumn HeaderText="ID" DataField="img_pk" />
<asp:TemplateColumn>
<ItemTemplate>
<asp:Image ID="Image1" Width="100" Height="100" runat="server" ImageUrl='<%#FormatURL(DataBinder.Eval(Container.DataItem, "img_pk")) %>'></asp:Image>
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn HeaderText="Name" DataField="img_name"></asp:BoundColumn>
<asp:BoundColumn  HeaderText="ContentType" DataField ="img_contenttype"/>
</Columns>
</asp:datagrid>

protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection cn = new SqlConnection("server=192.168.1.16\\SQLEXPRESS;uid=sa;pwd=Mobile123;database=employs");
        SqlDataAdapter da = new SqlDataAdapter("select * from image",cn);
        DataSet ds = new DataSet();
        da.Fill(ds);      
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }

 public string FormatURL(object strArgument)
    {
        return ("Image.aspx?id="+strArgument);
     
    }   

  protected void Page_Load(object sender, EventArgs e)
    {
        string strImageID= Request.QueryString[0];
        SqlConnection cn = new SqlConnection("server=192.168.1.16\\SQLEXPRESS;uid=sa;pwd=Mobile123;database=employs");
        SqlCommand cmd = new SqlCommand("select img_contenttype,img_data from image where img_pk='" + strImageID + "' ", cn);
        try
        {
            cn.Open();
            SqlDataReader dr;
            dr = cmd.ExecuteReader();
            if (dr.Read()) //yup we found our image
            {
                //retrving the image content type
                Response.ContentType = dr["img_contenttype"].ToString();
                //displaying the image
                Response.BinaryWrite((byte[])dr["img_data"]);
            }
            cn.Close();
        }
        catch
        { 

        }
    }