Hi,

Do you use the schema shown in the Access database that comes with Planner.NET, or have you created your own schema?

I think that at this time Planner.NET requires all resource types to be bound to a data source, even if you won't use them. Have you left any properties from the Binding category empty?

Stoyan

Unfortunately that's not possible. We will change this in the next release, but until then you can load a single table only by iterating the dataset items and programmatically creating Planner.NET Appointment objects from them.

Databinding is being redesigned so that it would allow loading item data from a single table. It will be no longer obligatory to supply all possible data tables.

Meppy

Hi,

I need to know if the code block above as per tutorial is workable or not?

My employer expects me to design the application to use a shared database on a server.

Simply getting a error stating object not set and nothing else is leaving me puzzled as what else am I supposed to set?

I see nothing different in the tutorial?

Thnx

PS also the change to how the tables are required or not required do you have a timescale for this?

Here is a preliminary build of the new Planner.NET version:

https://mindfusion.org/_planner/_Planner.NET_422pre_trial_20.zip

You no longer have to specify every possible table when loading and saving data from the database. Instead, pass null references in the call to Calendar.SaveToDataSource for the tables you are not interestes in when saving, or omit the calls to the corresponding table adapters' Fill methods when loading.

Meppy

HI, i've updated the dll and the referencies, created a new project, and it's ok: I can bound and load just the table I need.
Now I've another problem: in single month view clicking on load button (loadfromdatasource handled), i see the items on calendar. When I set the calendar in resource view grouping by resource and bounding the resource in dataset, clickind on load the calendar is empty. when I click load button the datagrid I've put inside the form, are correctly filled, but still to see nothing incalendar. The code in load buttun click event is:

Calendar1.Schedule.Clear()
	  PlannerDataSet1.Clear()

	  ItemTableAdapter1.Fill(PlannerDataSet1.Item)
	  ResourceTableAdapter1.Fill(PlannerDataSet1.Resource)
	  ItemResourcesTableAdapter1.Fill(PlannerDataSet1.ItemResources)

	  Calendar1.LoadFromDataSource()
 

Thanks for help.
Fabio

Right!

I started a new project.

Followed Tutorial 1
Followed Tutorial 9 up to part 4.

I ran the project and it worked, no calls to databases yet so no problem.

I have the dataset, bindingsource and tableadapter on my form.

I have the properties set for the items member only.

Here is the forms load code

Public Class Form1

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
	  Calendar1.BeginInit()
	  Calendar1.TimetableSettings.Dates.Clear()

	  Dim i As Integer
	  For i = 0 To 5

		Calendar1.TimetableSettings.Dates.Add( _
		    DateTime.Today.Add(New TimeSpan(i, 0, 0, 0)))

	  Next i

	  Calendar1.TimetableSettings.VisibleColumns = 3

	  Calendar1.EndInit()

	  Calendar1.Schedule.Clear()

	  PlannerDataSet.Clear()

	  ItemTableAdapter1.Fill(PlannerDataSet.Item)

	  Calendar1.LoadFromDataSource()

    End Sub
End Class
 

And once again I get the same error!

Please can anyone please help me with this?

System.NullReferenceException was unhandled
  Message="Object reference not set to an instance of an object."
  Source="Calendar"
  StackTrace:
      at MindFusion.DataBinding.DataSourceTracker.xdf653366cdb56b9d(Object x337e217cb3ba0627, Object xaeebf6cdac58d859)
      at MindFusion.DataBinding.DataSourceTracker.x9641f931b2968145(Object x1563b91fcacc4108)
      at MindFusion.DataBinding.DataSourceTracker.ReadSourceItems()
      at MindFusion.DataBinding.DataBinder.LoadSourceData()
      at MindFusion.Scheduling.WinForms.Calendar.LoadFromDataSource()
      at WindowsApplication2.Form1.Form1_Load(Object sender, EventArgs e) in C:\Documents and Settings\pjh8\My Documents\Visual Studio 2005\Projects\WindowsApplication2\WindowsApplication2\Form1.vb:line 25
      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 WindowsApplication2.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()