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

ejaz mirza

8y1.9k.NET

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

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

ejaz mirza8y ago
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 Pansuriya8y ago
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 mirza8y ago
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 Pansuriya8y ago
Hi, Try this :
columns.Bound(x => x.slottimefrom).ClientTemplate("#= kendo.toString(slottimefrom, \"hh:mm:ss tt\") #");
ejaz mirza8y ago
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
Piyush Pansuriya8y ago
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 mirza8y ago
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");
})
Piyush Pansuriya8y ago
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"
}]