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

Thanks

But how we do update operation mainly for AllProperties column which save binary data.

One thing more, In Gantt View can't we show some details of project like project name etc.

Thanks,

I have problem with adapter update operation,Cell deactivating and TaskElementDragComplete event doesn't work properly. One case is

When I delete all the task database not reflecting it,because in task grid we have to click on some other row than these event raised otherwise not,but there is no other row to click.

Hi,

Did you try to used these method below:

this.ultraCalendarInfo1.DataBindingsForTasks.RefreshData();

ultraGanttView1.Refresh()

Let me know if you have any questions.

Regards

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.