By default the component will suppress the time element of a date/time field. If you require the time portion of the value to be displayed then depending on the database you are using then you can apply a database function to the column value.
For SQL Server you can use the Convert function to control the way a date/time field is returned from the database. e.g.
document.all.dbnetgrid1.selectPart = [ 'visit_date', 'convert(varchar(5),visit_date, 108)' ]
For Access you would use the Format function e.g.
document.all.dbnetgrid1.selectPart = [ 'visit_date', 'format(visit_date,'short time')' ]
Hide Answer
Yes, as long as the stored procedure returns a record set. Simply use the procedure property to specify the name of the stored procedure. If the procedure requires parameters then you can use the procedureParameters property to specify these e.g.
document.all.dbnetgrid1.procedure = 'salesbycategory'
document.all.dbnetgrid1.procedureParameters['categoryname'] = 'Beverages'
document.all.dbnetgrid1.procedureParameters['ordyear'] = 1996
Note: The search and sorting functions are automatically turned off when the procedure property is used, as these are not supported by stored procedures.
Hide Answer