Concatenate multiple datafields to one Gridview Column

Suppose my data source has columns Last Name and First Name but I wish to display the full name (<FirstName><space><LastName>) in a GridView column.

Solution:

• Define TemplateFields
• In the TemplateField you can define your own ItemTemplate
  e.g. <ItemTemplate><asp:Literal ID="FullName" runat="server" Text='<%# Eval("FirstName") + " " + Eval("LastName") %>' /></ItemTemplate>

Other Tips:

Formatting of date display using Eval("Date","{0:d}") to display Short Date String and Eval("Date", "{0:t}") to display Short Time String.
Full list of date formats and examples can be found here.