Hi,
How to bind (SL-DV) xamDataChart to Microsoft SQL Server Data Source(RDBMS)?
This is really urgent requirement. If anyone has any sample/link please do reply.
Thanks & Regards,
Sandip
Thanks Dimi,
I have gone through Graham's sugessions & looks like I need to do more R&D there.
You guyes don't have any simple with same. My client needs results ASAP. If I need to do more R&D I don't know it's going to proper results or not. It's too late.. ... for me now.
Possibly we are going to loose client here.
If you have any readymade sample for same please do send me I'll check with client once again. Will try to hold him.
Hi Sandip,
I just wanted to know if you were able to solve your issue based on Graham's suggestions or you still need help? Just let me know.Thank you.
Sincerely,DimiDeveloper Support EngineerInfragistics, Inc.
In Silverlight you will likely want to talk to a web service to get the data to populate into the xamDataChart. The xamDataChart doesn't really care where the data came from, only that the collection of data supports the IEnumerable interface. You then specify how the data maps into the chart by specifying various member paths (ValueMemberPath, etc).
To get the data to populate the chart you should look into WCF, Linq to SQL, Entity Framework, and RIA Services, and see which technology best fits your scenario.
In WPF you could directly connect to the database using the SQL native client if you desired, or if you wanted to make a full-trust Silverlight application, I'm sure you could probably talk to the native client over COM in some way. Again, the chart really doesn't care how you obtained the data, only that it is IEnumerable when you provide it to the chart.
Do the machines that are running the application even have direct access to the SQL server? More often then not your application server should act as a security gateway to protect the inaccessible database.
-Graham