i using time datatype in sql i want to bind it to kendo grid

Question

i am using time datatype in my sql server i want bind the column in kendo grid but its not displaying the time column instead of it [object] [object] displaying i want to use only time datatype not date time through date time am gettting my requirement is time data type i have to build the grid in mvc using kendo grid

Piyush Pansuriya · Answer

Hello, you can use format for time like : columns: [ { field: "OrderID", title: "Order ID" }, { field: "Time", title: "Time", format: "{0: hh:mm:ss tt}" }, { field: "OrderDescription", title: "Order Description" }]

Piyush Pansuriya · Answer

So, you can try this if possible .Columns(columns => { columns.Bound(p => p.DoctorName).Title("Doctor Name"); columns.Bound(p => p.Department).Title("Department"); columns.Bound(p => p.smonth).Format("{0:MM/dd/yyyy}").Title("selected Month"); columns.Bound(p => p.days).Title("Selected Days"); columns.Bound(p => p.slottimefrom).Format("{0:hh:mm:ss tt}").Title("Slot Time From"); columns.Bound(p => p.slottimeto).Format("{0:hh:mm:ss tt}").Title("Slot Time To"); })

ejaz mirza · Answer

no its not a naming problem my kendogrid code here @(Html.Kendo().Grid(Model) .Name("Grid") .Columns(columns => { columns.Bound(p => p.Doctorname).Title("Doctor Name"); columns.Bound(p => p.Department).Title("Department"); columns.Bound(p => p.appointmentdate).Format("{0:MM/dd/yyyy}").Title("selected date"); columns.Bound(p => p.patientname).Title("Patient Name"); // columns.Bound(p => p.appointmenttime).Format("0:hh:mm:ss tt").Title("Slot Time To"); columns.Bound(x => x.appointmenttime).ClientTemplate("#= kendo.toString(appointmenttime, \"0:hh:mm:ss tt\")#"); }) .HtmlAttributes(new { style = "height: 550px;" }) .Pageable(pageable => pageable .Input(true) .Numeric(false) ) .Sortable() .Scrollable(scr => scr.Height(430)) .Filterable() .DataSource(dataSource => dataSource .Ajax() .PageSize(20) .ServerOperation(false) ) ) page source is here

Piyush Pansuriya · Answer

So, I think its a Naming problem you are assign to element. Please see in console or viewsource which name you are getting and assigning.

ejaz mirza · Answer

bro no use its showing [object object] but this syntax much work its shows the time just for fraction of seconds when it reloads after that showing [object object] its bringing but not displaying when i reload page shoing the tym then turned into objects in fractions of seconds

Piyush Pansuriya · Answer

Hi, Try this : columns.Bound(x => x.slottimefrom).ClientTemplate( "#= kendo.toString(slottimefrom, \"hh:mm:ss tt\") #" );

ejaz mirza · Answer

no use i have tried this types of syntax it its work for whose datatype is date time mine is only time so didn't work

ejaz mirza · Answer

i want to use this syntax model .Columns(columns => { columns.Bound(p => p.DoctorName).Title("Doctor Name"); columns.Bound(p => p.Department).Title("Department"); columns.Bound(p => p.smonth).Format("{0:MM/dd/yyyy}").Title("selected Month"); columns.Bound(p => p.days).Title("Selected Days"); columns.Bound(p => p.slottimefrom).Title("Slot Time From"); columns.Bound(p => p.slottimeto).Title("Slot Time To"); })