System.ArgumentException was unhandled
Message="Object of type 'System.Int16' cannot be converted to type 'System.Boolean'."
Source="System"
StackTrace:
at System.ComponentModel.ReflectPropertyDescriptor.SetValue(Object component, Object value)
at MindFusion.Scheduling.DataBinding.x8db18c2080b4ae64.xdf653366cdb56b9d(Object x337e217cb3ba0627, Object xaeebf6cdac58d859)
at MindFusion.Scheduling.DataBinding.x8db18c2080b4ae64.x9641f931b2968145(Object x1563b91fcacc4108)
at MindFusion.Scheduling.DataBinding.x8db18c2080b4ae64.x0d510b9a14a54e2f()
at MindFusion.Scheduling.DataBinding.xa7e178e5abda1bf4.xc278b192d73221db()
at MindFusion.Scheduling.WinForms.Calendar.LoadFromDataSource()
at Calendar1.Form1.Form1_Load(Object sender, EventArgs e) in C:\Documents and Settings\lahai\My Documents\Visual Studio 2005\Projects\calendar\Calendar1\Calendar1\Form1.vb:line 21
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)
at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(ApplicationContext context)
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicat
ionModel()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String
[] commandLine)
at Calendar1.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

well thanks. Is there any info you can provide about how and where to do that?

A new, preliminary build of the control can be downloaded from here:

https://mindfusion.eu/_pln_trial/MindFusion.Scheduling5.0f.zip

The Calendar.LoadFromDataSource method now exposes additional overload, which accepts an object of type IValueConverter as an argument. You can use this overload to specify explicit conversion for various data types during databinding. The following example illustrates how you can implement and use an IValueConverter:

public class ByteToBoolConverter : IValueConverter
{
      public object Convert(object value, object destination, string destinationMember, Type destinationType)
      {
            if (value is byte && destinationType == typeof(bool))
                  return (byte)value != 0;

            return value;
      }

      public bool Supports(object value, object destination, string destinationMember, Type destinationType)
      {
            return value is byte && destinationType == typeof(bool);
      }
}

...

// Perform data loading using the converter
calendar1.LoadFromDataSource(new ByteToBoolConverter()); 

The implemented converter performs an unconditional conversion from byte to boolean. You might have to perform additional checks to see if this conversion is applicable for all values.

Let me know if this helps.

Regards,
Meppy

Harpoon wrote on Nov 11^th, 2009 at 10:40pm:


I have tried this and it works successfully. I am now able to save and load the database data to the calendar.

I will post my code in VB for anyone that is interested.

Create a class as follows:

Public Class Converter
Implements MindFusion.Scheduling.DataBinding.IValueConverter
Public Function Convert(ByVal value As Object, ByVal destination As Object, ByVal destinationMember As String, ByVal destinationType As System.Type) As Object Implements MindFusion.Scheduling.DataBinding.IValueConverter.Convert
If (TypeOf value Is SByte OrElse TypeOf value Is Byte) AndAlso destinationType Is GetType(Boolean) Then
Return CBool(value <> 0)
End If
Return value
End Function

Public Function Supports(ByVal value As Object, ByVal destination As Object, ByVal destinationMember As String, ByVal destinationType As System.Type) As Boolean Implements MindFusion.Scheduling.DataBinding.IValueConverter.Supports
If (TypeOf value Is SByte OrElse TypeOf value Is Byte) AndAlso destinationType Is GetType(Boolean) Then Return True
End Function
End Class

-------------

Use the overloaded method
_schedule.LoadFromDataSource(New Converter)

to load the data.

Thanks for your help on this issue.

I have made some modifications to the control which should fix this problem. The workaround is rather "ugly" at this point and we may think of a more intuitive API for the future.

First, you need to define a function which should attach an event handler to the RowUpdated event of the MySqlDataAdapter objects:

Private Sub AttachRowUpdated(ByVal adapter As DataAdapter)

      AddHandler (CType(adapter, MySqlDataAdapter)).RowUpdated, AddressOf OnRowUpdated

End Sub 

The event handler should look similar to the following:

Sub OnRowUpdated(ByVal sender As Object, ByVal e As MySqlRowUpdatedEventArgs)

      If (e.StatementType <> StatementType.Insert) Then
            Exit Sub
      End If

      Dim command As New MySqlCommand( _
            "SELECT LAST_INSERT_ID()", e.Command.Connection)
      Calendar1.UpdateRow(CType(sender, DataAdapter), e.Row, command)

End Sub 

Then you need to assign the AttachRowUpdated method to a new field defined in the Calendar class. Do this before calling SaveToDataSource:

Calendar1.AttachRowUpdated = AddressOf AttachRowUpdated
' Save here 

Try this solution and let me know if it works.

Regards,
Meppy