Hi all,

Could someone please show me how to concat day, month and year colums in database as one single column in datagrid ASP.Net VB ? Thanks in advance

I tried the below but it keep giving error :

Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: The server tag is not well formed.

Source Error:
Line 1: <%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
Line 2: <%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicK eyToken=836f606ede05d46a,culture=neutral" %>
Line 3: <MM:DataSet
Line 4: id="dsEmplRecog"
Line 5: runat="Server"

And here's my code:
<MM:DataSet
id="dsEmplRecog"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_STRING_EmplRecog") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_DATABASETYPE_EmplRecog") %>'
CommandText='<%# "SELECT EmplRecog.EmployeeName, EmplRecog.Comment, (EmplRecog.Mon + ' ' + EmplRecog.CommentDay + ' ' + EmplRecog.YYYY) AS CommentDate , EmplRecog.CustName, EmplRecog.ID FROM EmplRecog ORDER BY YYYY DESC" %>'
Debug="true"
></MM:DataSet>

I would guess that the single quotes in the SQL statement are interfering with the attribute text of the MM:DataSet tag. Try change the data binding syntax for CommandText to a literal string. The binding isn't really doing anything there so you don't need it.

-Peter

u can add a unbound col in ur grid and make day mon and year col visbile false and then u can concat and dispaly the value in ur newly creatd col