How can i diplay my Images inside my GridView from folders?

Question

This is my Gridview

<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" Height="191px"
        Width="333px">
        <Columns>
            <asp:ImageField HeaderText="Image">
            </asp:ImageField>
            <asp:BoundField DataField="ID" HeaderText="ID" SortExpression="ID" />
            <asp:BoundField DataField="Rate_Type" HeaderText="Rate_Type" SortExpression="Rate_Type" />
        </Columns>
    </asp:GridView>

This is in my Code Behind inside my Page Load.............

        SqlConnection myConnection;
        DataSet dataSet = new DataSet();
        SqlDataAdapter adapter;

        //making my connection
        myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);

        adapter = new SqlDataAdapter("Select ID, Rate_Type from Rate_Record", myConnection);

        adapter.Fill(dataSet, "MyData");

        GridView2.DataSource = dataSet;
        GridView2.DataBind();

Now as you will see i have a ImageField inside my gridview. When the ID = 1 then i want to show the image located here ~/pics/ID1/MyImage.jpg and so on and so on. I also want to show a Thumbnail of the Image so the User dont have to download the WHOLE image.

Any help will be great!

Etienne

Answer 1

<asp:ImageField HeaderText="Image" DataImageUrlField="ID"
  DataImageUrlFormatString="~/pics/ID{0}/MyImage.jpg"
    AlternateText="Image Description" ReadOnly="true" />

Ideally you should have thumbnail images in this folder. Another way is to have thumbnail images prefixed with an identifier such as "thumb_" (thumb_MyImage.jpg).