I have a combo in grid
Main table that populates grid has the id and other table has the details/description of that ID
I have tried to follow the sample
http://labs.infragistics.com/silverlight/lobsamples/2010.3/#/Samples/ComboEditor/DataBinding/ComboInGrid
But that does not work with db
Any links
Hi,
I am not sure how you are providing the db to the xamGrid. If you use RIA Services you could check this blog post.
If this is not your case please provide more details.
HTH
What happens in case views are used
Hello
Thanks for the solution
I have attached my sample code and db, what should be the ConverterParameter when its the database view
Any help is appreciated
I have attached the sample code
Hello,
I have checked the sample you provided. I was not able to debug it and to make sure everything works. However I got the general idea. Here are few pointers:
You need to provide the DetailsTable1(or DetailsView1 - don't know are they different) - basically you need to provide ConverterParameter the table that is mapping Id to TextDescription. Your TextBlock code should look something like this:
<TextBlock Text="{Binding Path=detailid1, Converter={StaticResource LookupValueConverter}, ConverterParameter={Binding ElementName=LayoutRoot, Path=DataContext.DetailsView1}}" />
After that in the Converter you look up the parameter(you should know and cast to the type it is). The Convert method should look :
public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture) { var viewY = parameter as EntitySet<DetailsView1>; return viewY.FirstOrDefault(row => row.Id == (int)value).Description;}HTH,
What does the ElementName signify
Also I dont get intellisence for FirstOrDefault
check this link from msdn ElementName. Since the DataContext of the TemplateColumn cell is the bound row data, you need a way to access the DetailsTable1. To do so 'LayoutRoot' grid is used as binding source and the path is its data context and finally the DetailsView1.
Regarding the intellisence problem ... I am not sure what do you mean. (you need to add a using statement 'using SilverlightApplication2.Web;' )
Regards,
Yes I have added the reference correctly
For somereason when i run the application I get error Provide value on 'System.Windows.Data.Binding' and this is on same line where i give the Converter