I have a DataGrid control in my form, and I'm trying to make it show date and time. It is bind(ed?) to a dataset which contains a date/time column (which is filled with data from SQL database, by the way). But, my DataGrid only shows date in that column and not the time(I've tried changing width but that's not the problem). I tried editing DataGridColumnStyle class for that column but couldn't figure it out. I would also like that only hours and minutes are shown, not seconds.
And I guess this question goes in this forum, too. It's basically a question about SQL syntax. How do I update a field in a column which has a multiple word name. E.g, column's name is "Number of elements":
I tried putting it in qoutes but it didn't work. I know that the obvious solution is to simply change column's name, but I don't want to that, and, anyway, it works in Access, so why shouldn't it work with string commands?Code:UPDATE Table1 SET Number of elements=64 WHERE ID=13