We have a scenario where we will have to execute stored procedures and display the data on xamgrid. Some of the stored procedure return upto 50K records and therefore we would like to display them using virtual collection. However, we also have a scenario where the output of the stored procedures can change at times(may return new set of columns) based on the business requirement. We would not like to change the model everytime that happens hence we return a standard type of IEnumerable<Dictionary<string, object>>. Please let me know if its still feasible to use virtual collection under the given constraints.
Hi,
sorry for the late response,
there is no problem using VirtualCollection as long as you use a Dictionary<string, object> as items.
From XamGrid point of view you will need to use XamGrid's String Indexers Support feature. This approach will work well if:
I have attached a sample solution outlining this approach(xamGrid part only).
Sincerely,
I have a similar issue in my Xamgrid. But in my case Autogenerated Columns will be false and i am also using IEnumaerable<Dictionary<String, Object>> collection. But i want to know what Type of Virtual Collection should i be creating. I am using LightWeight Silverlight DataTable as given here.
Note :- As you mentioned about "String Indexers Support" feature in XamGrid Link is broken. So could you able provide alternative to that.
Hi ,
Thanks you for providing the solution to A1. I think you didn't understand the "A2" Question.
A2:- I want to Set FontWeight to BOLD for particular cell in the XamGrid. Fox Ex. if any negative numbers in the Cell should be in Bold and Background should be in different color.
In the same sample i have added the "SummaryStyle" resource to the "FN" Column but its not becoming BOLD. For Ex. The Column [FN] Value With "Anil1" Should become Bold. Its not happening.
Please Suggest me the exact solution this is urgent.
I got what you are trying to achieve now. It looks like that this is a bug. FontWeight isn't applied when the ConditionalFormatRule is Row. I have created a support case on your behalf - its id is CAS-64389-R40TGY.
EDIT: The the development issue's id is : 73751
Concerning your third question about FilterMenu capabilities:
Since the bound type is object the default operands can not be used and you will have to create all filtering operators by yourself. I have implemented the GreaterThan operatior as an example for you in the attached solution.
Regards,
Normal 0 false false false MicrosoftInternetExplorer4
Hi Konstantin,
Thanks for your reply.
You said "FontWeight isn't applied when the ConditionalFormatRule is Row. you have created a support case on your behalf - its id is CAS-64389-R40TGY".
So I didn’t get the how to find the support case "CAS-64389-R40TGY" and sample Could you please provide If you have any sample or link were same case has been implemented.
I think you got wrong what "support case" is. Support case(aka ticket) is created when a customer have encounter and reported a bug so he/she could be notified when the bug is fixed.
So you could track the progress on the ticket I've created for you logging in infragistics.com, then go to "My IG" -> "My Support Activity"(or use this link) there you should be able to find the CAS-64389-R40TGY entry.
The issue is already fixed and will be available after next service release, which is probably going to be out during next week.
I am facing a issue in VirtualCollection Column Filtering. I have attached the sample showing the issue.Could you please help where i went wrong. and it should filter by Whole dataset not thePageData.
For Ex :- In my sample when i filter the column by FN ="Anil1". its not filtering.
Could you please help me.
You could check out this thread - as Stoimen has replied there the XamGrid does not support the filtering interfaces of the VC. The Stoimen's suggestion looks the best thing you could do to workeround this limitation.
You need to hook up to grid's filtering events to know when the filters are changed. On such a change you need to get the new set of filters and provide them(in the ItemDataRequested event handler) to the call to your service - this way the service will return only filtered data.
Another thing you should do is to inavalidate the VC's cache in order to make the vc to request all the elements in the page. You could do so by calling VC's Refresh() method.
HTH,