Display images in GridView using Path stored in Excel File in ASP.Net

Kindly Check an Below example For your referance.

I have Created one .xls file name as Test.xls in Local drive

In This xls file there are two columns as Name & Photo

In name column store Name of Picture and in photo column we store the location of images.

On Page load of  WebPage Its shows the details in gridview

<form id="form1" runat="server">
    <div>
        <asp:GridView ID="gvImageDisplay" runat="server" AutoGenerateColumns="false" Visible="true">
            <Columns>
                <asp:BoundField DataField="Name" HeaderText="Name" />
                <asp:ImageField DataAlternateTextField="Photo"  
                 ControlStyle-Height="100px" ControlStyle-Width="100px" DataImageUrlField="Photo" HeaderText="Photo">
                </asp:ImageField>
            </Columns>
        </asp:GridView>
    </div>
    </form>

    protected void Page_Load(object sender, EventArgs e)
    {
       string strExcelConnection = "Provider=Microsoft.Jet.OLEDB.4.0;"
        + "Data Source=D:\\Test\\Test.xls;"
        +"Extended Properties='Excel 8.0;HDR=Yes'";
      

        OleDbConnection connExcel=new OleDbConnection(strExcelConnection);
        OleDbCommand cmdExcl=new OleDbCommand();
        cmdExcl.Connection=connExcel;

        connExcel.Open();
        DataTable dtExcelSchema;
        dtExcelSchema= connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,null);
        connExcel.Close();

        DataSet ds=new DataSet();
        string Sheetname = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
        cmdExcl.CommandText="Select Name,Photo From["+Sheetname+"]";
        OleDbDataAdapter da=new OleDbDataAdapter();
        da.SelectCommand=cmdExcl;
        da.Fill(ds);

        this.gvImageDisplay.DataSource=ds;
        this.gvImageDisplay.DataBind();
    }