In the following code an error arises when data is bind to Radscheduler. The error is :
"DataBinding: 'System.Data.DataRowView' does not contain a property with the name '7/4/2014 9:55:31 AM'." How can I solve this, Please help me. Ian new in RadControl.
private void LoadScheduler()
{
ConManager.DBConnection("TERMSUS");
DataTable DTLocalEmp = new DataTable();
string EmpCode = string.Empty;
DateTime strEndDate = System.DateTime.Now;
DateTime dtEnd = strEndDate.AddYears(1);
strSQL = "select mp.MPCode,mpd.MPDCode, case when mpd.Remarks ='' then 'N/A' else mpd.Remarks end as Remarks, mpd.SheduleDate, mp.MaintenceStartDate, '" + dtEnd+ "' as EndDate, md.MachinaryName, md.MDCode " +
"from tblMaintencePlanEntry mp " +
"inner join tblMaintenancePlanDate mpd on mp.MPCode=mpd.MPCode " +
"inner join tblMachinaryDetails md on mp.MDCode=md.MDCode ";
ConManager.DBConnection("TERMSMNT");
ConManager.OpenDataTableThroughAdapter(strSQL, out DTLocal, true);
//DTLocal.TableName = "Schedule";
if (!IsPostBack)
{
RadScheduler1.DataKeyField = "MPDCode";
RadScheduler1.DataStartField = "MaintenceStartDate";
//RadScheduler1.DataEndField = "ScheduleEndtTime";
RadScheduler1.DataEndField = Convert.ToDateTime(dtEnd).ToString();
RadScheduler1.DataSubjectField = "Remarks";
//RadScheduler1.DataDescriptionField = "ScheduleDescription";
//RadScheduler1.DataRecurrenceField = "RecurrenceRule";
//RadScheduler1.DataRecurrenceParentKeyField = "AppointmentID";
//RadScheduler1.DataReminderField = "Reminder";
}
RadScheduler1.DataSource = DTLocal;
RadScheduler1.DataBind();
}
}