Page Index Toggle Pages: [1] 2  Send TopicPrint
Hot Topic (More than 10 Replies) Not as easy as it sounds... (Read 14483 times)
lahai
YaBB Newbies
*
Offline


I love YaBB 1G - SP1!

Posts: 17
Joined: May 13th, 2009
Not as easy as it sounds...
May 15th, 2009 at 8:21pm
Print Post  
Hello,
So my company purchased this software based on the assumption that it will work with a current windows app database among other things. it doesnt seem to be working to well and i cant even get the databinding tutorial to save and load to the access database.  I really need help getting this up and running in some form and fashion.
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: Not as easy as it sounds...
Reply #1 - May 16th, 2009 at 7:35am
Print Post  
Does it throw some kind of exception when you run the sample or simply nothing happens? Can you also make sure that you have the MS Access drivers installed on the target computer?

Meppy
  
Back to top
 
IP Logged
 
lahai
YaBB Newbies
*
Offline


I love YaBB 1G - SP1!

Posts: 17
Joined: May 13th, 2009
Re: Not as easy as it sounds...
Reply #2 - May 18th, 2009 at 1:28pm
Print Post  
Nothing happens in the sense of saving it to the database.  I can add, save and load but it just stays within that instance of the app running and does  not save to the database
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: Not as easy as it sounds...
Reply #3 - May 18th, 2009 at 1:51pm
Print Post  
Are you calling the Update method on the TableAdapter objects after saving the schedule through Calendar.SaveToDataSource?

Meppy
  
Back to top
 
IP Logged
 
lahai
YaBB Newbies
*
Offline


I love YaBB 1G - SP1!

Posts: 17
Joined: May 13th, 2009
Re: Not as easy as it sounds...
Reply #4 - May 19th, 2009 at 1:39am
Print Post  
Here is the code i have. Obviously I'm doing something wrong

_calendar.SaveToDataSource( _
           ReminderTableAdapter, _
           StyleTableAdapter, _
           CustomBrushesTableAdapter, _
           ContactTableAdapter, _
           LocationTableAdapter, _
           ResourceTableAdapter, _
           TaskTableAdapter, _
           ItemTableAdapter, _
           ItemContactsTableAdapter, _
           ItemResourcesTableAdapter, _
           RecurrenceTableAdapter, _
           RecurrenceExceptionTableAdapter, _
           RecurrenceExceptionsTableAdapter)

       _calendar.Update()
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: Not as easy as it sounds...
Reply #5 - May 19th, 2009 at 6:05am
Print Post  
Try the following code right after SaveToDataSource and let me know how it works:

Code
Select All
ReminderTableAdapter.Update(PlannerSet.Reminder)
StyleTableAdapter.Update(PlannerSet.Style)
CustomBrushesTableAdapter.Update(PlannerSet.CustomBrushes)
ContactTableAdapter.Update(PlannerSet.Contact)
LocationTableAdapter.Update(PlannerSet.Location)
ResourceTableAdapter.Update(PlannerSet.Resource)
TaskTableAdapter.Update(PlannerSet.Task)
ItemTableAdapter.Update(PlannerSet.Item)
ItemContactsTabeAdapter.Update(PlannerSet.ItemContacts)
ItemResourcesTableAdapter.Update(PlannerSet.ItemResources)
RecurrenceTableAdapter.Update(PlannerSet.Recurrence)
RecurrenceExceptionTableAdapter.Update(PlannerSet.RecurrenceException)
RecurrenceExceptionsTableAdapter.Update(PlannerSet.RecurrenceExceptions) 


Where PlannerSet is a reference to your data set.

Meppy
  
Back to top
 
IP Logged
 
lahai
YaBB Newbies
*
Offline


I love YaBB 1G - SP1!

Posts: 17
Joined: May 13th, 2009
Re: Not as easy as it sounds...
Reply #6 - May 19th, 2009 at 8:41pm
Print Post  
Still not saving to the DB. No error or anything. I am using the databinding sample also i have followed the tutorial. Obviously, I am missing something.
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: Not as easy as it sounds...
Reply #7 - May 20th, 2009 at 6:05am
Print Post  
Can you e-mail me your application including the database to support@mindfusion.eu?

Meppy
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: Not as easy as it sounds...
Reply #8 - May 20th, 2009 at 1:28pm
Print Post  
Hi,

I received your sample application, tested it and it works fine. Are you inspecting the mdb file in the bin\Debug folder or the one in the main project folder. Because the application operates on file in bin/Debug. Also, every time you start the application from the IDE, the file in the project folder is copied in the bin/Debug folder overwriting the file already located there.

Regards,
Meppy
  
Back to top
 
IP Logged
 
lahai
YaBB Newbies
*
Offline


I love YaBB 1G - SP1!

Posts: 17
Joined: May 13th, 2009
Re: Not as easy as it sounds...
Reply #9 - May 20th, 2009 at 2:16pm
Print Post  
Ok. Thanks that helps alot. However when i click on the Load it will not load and i get an error:
Object reference not set to an instance of an object

What i need is for it to load past data/entries from the database.
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: Not as easy as it sounds...
Reply #10 - May 21st, 2009 at 6:05am
Print Post  
For some reason there is an invalid record in the Item table. Delete this record in the original database (the one found in the project folder) and try saving and loading again.

Meppy
  
Back to top
 
IP Logged
 
lahai
YaBB Newbies
*
Offline


I love YaBB 1G - SP1!

Posts: 17
Joined: May 13th, 2009
Re: Not as easy as it sounds...
Reply #11 - May 27th, 2009 at 4:02pm
Print Post  
Thanks Meppy for your help!!
I have another issue question. I have a table that stores multiple locations as a string. I want to use this same information  in the calendar. However the the location fields in the item db stores the id; one value. Can I use an array  or another option in in order to store multiple locations for one item.
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: Not as easy as it sounds...
Reply #12 - May 28th, 2009 at 5:44am
Print Post  
Unfortunately items can be associated with a single location only (through their Location property). It might be possible to reference more than one location from an item if you use the more general Resources collection.

Meppy
  
Back to top
 
IP Logged
 
lahai
YaBB Newbies
*
Offline


I love YaBB 1G - SP1!

Posts: 17
Joined: May 13th, 2009
Re: Not as easy as it sounds...
Reply #13 - Jul 24th, 2009 at 2:19am
Print Post  
Hello,
I am getting this error when trying to load schedule items with a mysql db.

Object of type 'System.Int16' cannot be converted to type 'System.Boolean'.

All the yes/no fields are set to boolean which is really a tinyInt. Does the calendar not read tinyInts?
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: Not as easy as it sounds...
Reply #14 - Jul 24th, 2009 at 5:57am
Print Post  
Can you also post a stack trace of the exception?

Meppy
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: [1] 2 
Send TopicPrint