I would like to concatenate two dataset fields (String and Date) to appear in a DropDownList, but I don't know how to convert the date to a string, and/or how to format it as "month dd, yyyy".
I've set my DropDownList DataTextField="ddlName"
This is my AccessDataSource SelectCommand (which doesn't work):
SelectCommand='SELECT [Project_Name] + " (" + [Project_Date] +")" AS ddlName FROM [ProjectsTable]'
[Project_Name] = "Project Name"
[Project_Date] = 6/10/2008 12:00:00 AM
I would like my DropDownList text to look like this: "Project Name (Month DD, YYYY)"
I've set my DropDownList DataTextField="ddlName"
This is my AccessDataSource SelectCommand (which doesn't work):
SelectCommand='SELECT [Project_Name] + " (" + [Project_Date] +")" AS ddlName FROM [ProjectsTable]'
[Project_Name] = "Project Name"
[Project_Date] = 6/10/2008 12:00:00 AM
I would like my DropDownList text to look like this: "Project Name (Month DD, YYYY)"
Last edited: