Good day,
I have a ganttview bound to a database, from the table where I saved the data, there are columns for taskname, duration, taskstarttime, etc. and the binary column for all fields. Now I have a process wherein I need to increase the taskduration directly from the database, I was able to increase it since the format of the data stored in database is 1.00:00:00, so what I did, I strip the 1 from the left and increment it by whatever number the user wants to, but my problem is, during reloading in the ganttview, the old value prevails, even if the taskduration is already 4.00:00:00, in ganttview it is still 1.
How to do it properly without using the ganttview to increase the taskduration?
Thanks
Hi,
When I run and debug the application that reads the binary column, there is a non-public member that has CustomProperties that contains the custom columns and their values, but my question, how to access those fields when they are not public members.
I have converted it properly using Task.ReadFromBytes, now my problem is how am I going to access the custom column from the task class?
Thank you.
I tried reading the AllProperties Column in SQL Server, and all I got when converted back to character, I used the following C# Code to convert it back to string as follows:
byte[] bt = (byte[])row["AllProperties"]; string s = System.Text.UTF8Encoding.ASCII.GetString(bt);
And the result is as follows:
"\0\0\0\0????\0\0\0\0\0\0\0\f\0\0\0sInfragistics4.Win.UltraWinSchedule.v12.2, Version=12.2.20122.1006, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb\0\0\0&Infragistics.Win.UltraWinSchedule.Task\b\0\0\0Id\nConstraintConstraintDateTime\bDurationDurationFormatName\rStartDateTime\fParentTaskId\0\0\0\0\0\vSystem.Guid\b\r\f\b\r\vSystem.Guid\0\0\0????\vSystem.Guid\v\0\0\0_a_b_c_d_e_f_g_h_i_j_k\0\0\0\0\0\0\0\0\0\0\0\b\a\a6?H?GsH??? {??\0\0\0\0??k????\0?i*?\0\0\0\0\0\0\0\0\0New sub-task 2\0??k????????????k???_?O?2??F?@\v"
Can you please give me some idea on how to it properly?
Thanks in advance.
So, in this case you could try to read and write data from/in your binary column in database. More details you could find in MSDN http://msdn.microsoft.com/en-us/library/29kt2zfk
Let me know if you have any questions.
Removing the AllProperties column is not an option in my case, since I have a lot of custom columns and the only place they can be saved in the database is through AllProperties.