Want to use image in datagrid to show active and inactive user?

Question

i have a database of country table. sql 2005 like,

country_id  country_name   region       area    population   gdp        status
   84        indi         asia      3432     3423           343         Active
   85        U.k          Europe   43432     3243          2343         Inactive

I want to user image of active and inactive instead of text in my datagrid .. not in database.. in database there is text only..

so.. i am using .net 2005 .. i want to bind image with status.. and whenever i changed active to inactive or inactive to active.. image will be change . according that..

i am using C# as code behind language..

Answer 1

Simplest way is to add an image column like that :

<asp:ImageField 
    DataImageUrlField="status" 
    DataImageUrlFormatString="~/images/{0}.jpg">
</asp:ImageField>

And you should have two images like active.jpg and inactive.jpg in your images folder.

By the way if you have null values in your status column don't forget to set NullImageUrl property for them.

EDIT : Actually I see you're looking for DataGrid, I missed it, here is the datagrid way with template column :

<asp:TemplateColumn>
    <img src='<%# DataBinder.Eval(Container.DataItem, "status", "~/images/{0}.jpg") %>' />
</asp:TemplateColumn>

And this one with the asp:image server control :

<asp:TemplateColumn>
    <asp:Image runat="server" ID="imgStatus" 
        ImageUrl='<%# DataBinder.Eval(Container.DataItem, "status", "~/images/{0}.jpg") %>' />
</asp:TemplateColumn>

Answer 2

ImageField was introduced in ASP.Net 2.0 for GridView. Here's a good article explaining it (with screenshots).

To display an image in a column in a DataGrid in ASP.NET 1.x you have to use a TemplateColumn with an Image Web control inside the TemplateColumn.