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

HI,

Thanks for attached sample. Maybe you could used these events:

private void ultraGanttView1_TaskAdded(object sender, Infragistics.Win.UltraWinGanttView.TaskAddedEventArgs e)
{
    dbTasksTableAdapter1.Update(testDataSet);
}
 
private void ultraGanttView1_TaskDeleted(object sender, Infragistics.Win.UltraWinGanttView.TaskDeletedEventArgs e)
{
    dbTasksTableAdapter1.Update(testDataSet);
}
 

Let me know if you have any questions

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.

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

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?

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