Click here to Skip to main content
16,009,391 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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();
}
}
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900