Hi,
I am using XamGrid from v10.2. I am having issues when the data from a stored proc has columns with special characters(ex #, % etc). Such columns have no data shown on the grid. How do I resolve this issue?
Harish,
Do you mean that the column names have special characters?
Sincerely,FrancisDeveloper Support Engineer
Yes, the column names have special characters. I have query that says
Select EmpId, Emp_Name, Loan as 'Loan #', Total as 'Total %' from TestEmp
The output on Sql Server looks like this:
And on XamGrid as this:
When I see the raw data from using Fiddler, I see that the data is passed through correctly but disappears as it binds to the grid. Not sure what I am doing wrong here.
I'd like to follow up by reiterating what Devin asked earlier: "...are you binding to a collection of objects whose properties include these characters? Exactly what type of objects and collection are you binding to XamGrid? How are you getting that data into your Silverlight application?"
Understanding how you have your business objects and bindings set up will help us resolve the issue.
Hello SHarish,
Thanks for the update. Please let me know if I can be of further assistance.
Sorry for the delayed response. I was away on vacation. The issue with columns having special characters and not binding to the grid is definitely not a Infragistics issue. I tried the same with a toolkit grid and had same results.
In the WCF service, I query a stored procedure using ADO.NET however I convert the data to objects of type IEnumerable<Dictionary<string, object>> and pass the data to silverlight application and bind the list to grid.The stored procedure sometimes have column names with special characters and that is exactly when the binding fails.
As firestorm suggested, I am trying to avoid aliases in the procs to avoid this problem.