Thanks for considering this post also

I take the look of the link you given me, but in that tasks are added one by one can't we assign some data source,so that grid will populate all tasks and also get viewed in Gantt view

I go through the video, but I didn't use data set before can you give me the code sample also.

Thanks!

I did like this

 TestDataSet dataSet = new TestDataSet();
            TestDataSetTableAdapters.PROJECTSTableAdapter project1 = new TestDataSetTableAdapters.PROJECTSTableAdapter();
           
            ultraCalendarInfo1.DataBindingsForProjects.DataSource = project1.GetData();            
            ultraCalendarInfo1.DataBindingsForProjects.IdMember = "Id";
            ultraCalendarInfo1.DataBindingsForProjects.KeyMember = "ProjectId";
            ultraCalendarInfo1.DataBindingsForProjects.NameMember = "ProjectName";
            ultraCalendarInfo1.DataBindingsForProjects.StartDateMember = "StartDate";
            ultraCalendarInfo1.DataBindingsForProjects.RefreshData();
       
            TestDataSetTableAdapters.TASKSTableAdapter Tasks1 = new TestDataSetTableAdapters.TASKSTableAdapter();
            ultraCalendarInfo1.DataBindingsForTasks.DataSource = Tasks1.GetData();
            ultraCalendarInfo1.DataBindingsForTasks.NameMember = "TaskName";
            ultraCalendarInfo1.DataBindingsForTasks.DurationMember = "DaysLeft";
            ultraCalendarInfo1.DataBindingsForTasks.StartDateTimeMember = "StartDate";
            ultraCalendarInfo1.DataBindingsForTasks.IdMember = "Id";
            ultraCalendarInfo1.DataBindingsForTasks.ProjectKeyMember = "ProjectId";
            ultraCalendarInfo1.DataBindingsForTasks.ParentTaskIdMember = "ParentTaskId";
            ultraCalendarInfo1.DataBindingsForTasks.PercentCompleteMember = "Progress";
            ultraCalendarInfo1.DataBindingsForTasks.RefreshData();
            int i = ultraCalendarInfo1.Tasks.Count;
            ultraGanttViewProjects.Project =ultraGanttViewProjects.CalendarInfo.Projects[1];

Gantt view didn't show any data.I found that from GetData() I get 1 row but task count value of i is zero

Is there some thing wrong?

Hi,

Could you please take a look at the attached sample for more details. Also there are SQL scrip that create a tables and some data for the test. Please let me know if you have any questions.

Regards

Thanks again

But I can't run that that code there is version conflict I am using 4.0. I check the code it seems to be alright .Is there possibility that this is because of back end?

Thanks for reply.

Hi,

I suppose that you are using ultraCalendarInfo1_AfterAppointmentAdded() event to update your database only for the fields that you bind to your UltraCalendarInfo. If you want to update your DB with data from your extra fields, just call update method of your TableAdapter (only for these fields) when you press a button from the win form that add a tasks.

mayank164 said:

In database I have start date and end date not duration column,So how I show task by calculating duration?

If you have start and end date, so you could calculate the task`s duration. You could do this in your C# code or in your database. For example:

C#
DateTime startDate = DateTime.Today;
DateTime endDate = DateTime.Today.AddDays(10);
TimeSpan diffDate = endDate.Subtract(startDate);
MessageBox.Show("Days difference = "+ diffDate.Days.ToString());  
 
SQL

DECLARE @BegDate DATETIME
DECLARE @EndDate DATETIME
SET @BegDate  = GETDATE()
SET @EndDate   = DATEADD(dd, 10, GETDATE())
PRINT DATEDIFF(dd, @BegDate,@EndDate)

 
 
Let me know if you have any questions.
Regards

Hi,

I'll explain you,I have a form to add task, in that form I have some extra field which do not allow null. I don't want that user enter value for field in gantt chart and there is no need to show in gantt chart so I didn't bind them with calendarInfo .now when user add task these fields also get initialized with some default data in datatable so I can insert task.

I think you understand.

I have one more query

In database I have start date and end date not duration column,So how I show task by calculating duration?

Hi,

I`m not sure what is your scenario, but maybe you could handle ultraCalendarInfo1_AfterAppointmentAdded() event and using e.Appointment properties you could update your data table. I`m not sure where you are bind this table, but all available data in your UltraCalendarInfo will be represent in the UltraGanttView. Of course you could hide some columns from your task grid.

Let me know if you think that I misunderstood your scenario

Thanks,

This is alright.Also give the answers of second part of question

when task is added I want to initialize some columns with some values in data table only and don't want to show in tasks grid.