Printable View
Hi, Could anyone help me on how to format a datagrid column which is a datetime to display only time format like 'HH:mm". I try with 'formatdatetime(Mydataset.Item(1), Dateformat.ShortTime)' but it does not work, it still display date not time. I could not format it at the tablestyle because it does not support format. I search msdn but the method is incomplete I couldn't implement it. So if any body could help. Thanks
Hi,
the old vb format statement still works
format(mydataset.item(1),"HH:mm")
Pete
Thanks Pete. The data column in the datagrid is datetime and if I change it to a string data type it works but I save data from the datagrid to sqlce. So when I change the column datatype to string I get error message about the datatype since the datatype in the database is datetime. This where I am stuck. So any help?Quote:
Originally Posted by petevick
So if you are writing it back, what about the date portion?
You can convert it back by doing similar to
if isdata(mystring) then
z = ctype(mystring, date)
end if
Thanks Pete. But I another datagrid which has a datasource of a dataset. How can I format the datagrid column since the dataset is filled by a dataadaptor. Like (DataAdaptor.fill(DataSet)) and (Datagrid.Datasource = Dataset) How could I format a Time column of the datagrid in this case.Quote:
Originally Posted by petevick
Hi,
can you not format it using a 'convert' statement in you sql statement of your datasource?
Pete
Ok Thanks pete, I have use the convert statement but it return something like this ( 20:30:00) and how do I do away with the last two zeros and the semicolome. ThanksQuote:
Originally Posted by petevick
Hi,
select convert(varchar(5),getdate(),108) gives you what you want
Pete