asp.net GridView Data manipulation

Question

I have GridView which displays data like this

Name      Type     Description

abc       1         test
xyz       2         test
mno       1         another test

This Data is retreived from sqldatasource.

Question: I want to display type Name instead of ID Eg( if type =1 then it should display "Truck" and if Type = 2 it should display "Driver") I have only 2 types(Truck and Driver)

Can anyone please help me in this?

Thanks, S

scartag · Accepted Answer · 2013-02-04 00:02:00Z

1

You can replace the current BoundField you have for the "Type" column to a TemplateField.

I'm assuming you are not setting the GridView AutoGenerateColumns to true.

        <asp:TemplateField>
            <HeaderTemplate>Type</HeaderTemplate>
            <ItemTemplate>
                <%# Convert.ToInt32(Eval("Type").ToString()) == 1 ? "Truck" : "Driver" %>
            </ItemTemplate>
        </asp:TemplateField>

answered Feb 4, 2013 at 0:02

scartag

17.7k3 gold badges52 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sat Over a year ago

Thank you very much. And would that be possible, If I want to call a method, which will be returning the result value?

Collectives™ on Stack Overflow

asp.net GridView Data manipulation

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related