Hello
Kindly provide me a sample code to populate the tasks grid in the ultraganttview from the database. This has to work on selecting a project from a dropdownlist.
Also need to add and modify the tasks and then save back to the table in the database.
Regards
jeni
Hello Jeni,
There are different approaches to solve this task. I`m not sure what is your scenario (Are you using TableAdapters, or EntityDataModel, or SQLCommands and so on...) I made small sample for you where I`m using TableAdapters and local database. Please take a look at the attached sample and video file for more details and let me know if you have any questions. Also you could find additional information in our online documentation: http://help.infragistics.com/Help/NetAdvantage/WinForms/2012.1/CLR2.0/html/WinGanttView.html
Here is the sample
Hello Georgi
1. I tried using Nvarchar(50) datatype for the TaskDuration. Still I get the same error on update when duration bigger than 24 hours, say 2 days or 3 days
2. Secondly `Resource Names` are not being saved to the AllProperties field, How do I save the Resource Names in the database?
Thanks in advance
Could you please send us your sample with database. I`ll be glad to research this issue for you.
Let me know if you have any questions.
I have included a small sample and the script.
My issues are described below.
Insert task, Update task etc with a duration more than 24 hours is not workingNot able to save resource namesOn click of Add Notes button I want the task information of the selected task to be opened, with the Notes tab as the selected tab.
Please find the sample here.
I`m glad to see that you are using my sample and my suggestion with TableAdapters. I research your sample and you should make few changes to be able to Insert, Delete, Update your Tasks. I made a video file for you with the changes that I made into your sample. The video file is huge and I`m not able to upload it in this forum thread, that`s why I create a private case for you with Ref. Number CAS-101542-H7H8Q1. You could find your case at: https://ko.infragistics.com/my-account/support-activity/ with attached video file
Please take a look at the video file and let me know if you have any questions.
Please note that I made changes in:
1. Update Command
2. Delete Command
3. TaskDuration column in the database
4. About Resource Name, please note that you should have Owners in your UltraCalendarInfo. You could load this Owner from DataBase or direct in the UltraCalendarInfo
The sample of the script is attached here.
Thanks for your reply with video samples.
A sample for the issue is attached here along with the db script. Kindly have a look on to it.
I find issues in populating the ganttview on selecting the project from ultracomboeditor. I have a comboeditor on selecting a particular startdate and enddate combo is populated on the valuechanged of the combo I need to populate the tasks of that particular project. insert new task, subtask, delete and update functionality. I tried with paraamterised fill method of table adapter, I works perfect for update, delete, select but insert new task and subtask is not working for the selected project. Please suggest a way to work out this. Is there any way to insert the task by passing the projectid as the parameter on update?
Looking forward for your feedback.