I presume your databinding to your grid
I believe a datacolumn can have a format property set against it. Try seting that to dd/mm/yyyy hh:mm:ss (note those an't the actual codes - you can look them up I cba :) )
Im not so sure about this now. Been a while since I've used datagirds and...
Are you using Visual Studio ?
Are you using a SQL data adapter ?
If so I would suggest that you try previewing the data returned by your data adapter (right click your data adapter and click preview)
This way you can determine if the problem is your query or not !
[Resolved] Excel Automation – Excel Attaches itself to my Excel Object!
xlApp.IgnoreRemoteRequests = True
I am using Office Automation in one of my applications in order to read/write to an excel spreadsheet...