Would anyone be so generous as to provide a bit of guidance on populating a gantt chart from data in a LINQDataSource?I've read the following thread, as well as the samples discussed within the thread, but nothing on LINQ.http://forums.infragistics.com/forums/p/28607/121060.aspx#121060
I think that what I am trying to achieve, to begin with, should be fairly simple. I have an entity within my datacontext called "Projects". That entity(table) has project titles, start dates, and end dates. I would like to display this info in a simple gantt.
If anyone reading this post has already wired up a gantt using a LINQDataSource, pointers or sample code would be greatly appreciated.
I figured out how to connect to the LINQDataSource.... simple as specifying column numbers, but I am still at a loss as to accessing the entities made available via the LINQDataSource from a Linq DataContext model/class. All I seem to be able to access is the integer values in the immediate table, not the entity values themselves. (unable to leverage the power of DynamicData, .Net 3.5 SP1+ )
i'm not sure i understand the problem. what is the difference between the integer values and the entity values?
is the chart plotting the data as if it were taken from the original table, and ignoring the data objects you've created using LINQ?
okay, I understand the problem now, it sounds like we need to update the chart (and other controls) to support certain features of LINQDataSource. thank you for providing details on this. I have made the ASP.NET product manager aware of this, and am awaiting his response. this could be treated as a feature request or bug report, but before i say which, i'd like to consult with the ASP.NET platform experts here.
you can also enter a feature request here: http://devcenter.infragistics.com/protected/requestfeature.aspx
p.s. I'm not picking on just the UltraChart control. I was exponentially more disappointed to find out that I am going to be unable to use the powerful IG DataGrids because they cannot access DynamicData... so for data grids as well(with the exception of "view only" senarios), I am stuck with the basic .Net framework gridviews, because they have <asp:DynamicField />.
Link to forum discussion on DataGrid: http://forums.infragistics.com/forums/t/41401.aspx
Forgive me if I misuse a term, but...
Looking within a LINQ to SQL model, at the defenition for a table that has foreign keys, not only can I see the list of column defenitions("private System......."), but I can also see entities("private EntityRef....."). I don't want to insult anyone, so I'm going to presume anyone reading this understands the purpose for having an integer column in a table with a foreign key to a seperate table that holds the referenced string or other data type values.controls that are what I call "DynamicData enabled" can leverage not only the integer column in the source table, but the EntityRef values as well, through the LINQDataSource, without any additional programming. This is FW3.5 FP1 functionality. Even the free chart control from Microsoft can leverage these values.http://www.microsoft.com/downloads/details.aspx?FamilyID=130f7986-bf49-4fe5-9ca8-910ae6ea442c&displaylang=enIn the project that brought this to light with the IG control, the values for owner, description, etc are reference by foreign key. So.. my gantt chart shows start date and end date properly, but for owner, label, etc... I see integer values(24, 3, 137, etc...)
My database would grow substantially larger if I repeated these referenced string values hundreds of times in the table(instead of listing them once), just to accomodate a display control.