Time values in datagrid
-
Hello All I want to retrive the time values stored into the database then i want to display that value into a datagrid but the problem is it will display the date also along with the time but there is no dates stored into the database. plz help me in this issue with code. with regards yogesh agarwal
-
Hello All I want to retrive the time values stored into the database then i want to display that value into a datagrid but the problem is it will display the date also along with the time but there is no dates stored into the database. plz help me in this issue with code. with regards yogesh agarwal
If you are not directly binding the data to the Grid, you can get the value into DateTime type and use .ToShortTimeString() method and assign to the tinme value. If you are directly binding data to the grid, then you probably have to format the column to time format.Check if DataBound like event is available or not. If you are providing your own SQL for data retrival use TO_CHAR(DATE_COLUMN, 'HH:MM:SS') in sql to get the data in time format.