GIS related data from RIA service

Question

I have gis data in an sql-server database I need to bind to a datagrid.  I can use an ria service and bind the data directly to the datagrid but ideally, I would like to loop through the fields in these  entities and create hyperlinks for certain fields prior to adding the data to the datagrid.  Does anyone have any thoughts on how to approach this problem ?

Thanks,

Chula_VistaGIS · Answer

One of the ways to do... 1) For your datagrid, set the AutoGenerateColumns="false" As an example 2) Populate your columns As an example ... 3) Depending on your field type, you can use one of the following a) DataGridTextColumn b) DataGridCheckBoxColumn c) DataGridTemplateColumn 4) Thus, if you want to have a hyperlink, you may want to use "DataGridTemplateColumn" As an example //add a Hyperlink Control ... 5) Check the following link as well http://msdn.microsoft.com/en-us/library/system.windows.controls.datagridtemplatecolumn(v=vs.95).aspx Thanks for the suggestion. Unfortunately, I need to handle this in code behind since I don't know what field(s) may be returned and/or need a hyperlink. In code behind, I am able to create the datatemplate and hyperlink field by iterating through the dictionary object returned by an esri query. What I'm looking for is a way to create a dictionary and iterate through entitiy objects returned from an ria service (loadoperation). Regards,

STharshini · Answer

One of the ways to do... 1) For your datagrid, set the AutoGenerateColumns="false" As an example 2) Populate your columns As an example ... 3) Depending on your field type and Silverlight Version, you can use one of the following a) DataGridTextColumn b) DataGridCheckBoxColumn c) DataGridTemplateColumn Check the following link http://msdn.microsoft.com/en-us/library/system.windows.controls.datagridtemplatecolumn(v=VS.100).aspx 4) Thus, if you want to have a hyperlink, you may want to use "DataGridTemplateColumn" or "DataGridHyperlinkColumn" As an example //add a Hyperlink Control ... 5) Check the following link as well http://msdn.microsoft.com/en-us/library/system.windows.controls.datagridtemplatecolumn(v=vs.95).aspx http://msdn.microsoft.com/en-us/library/system.windows.controls.datagridtemplatecolumn(v=VS.100).aspx I have gis data in an sql-server database I need to bind to a datagrid. I can use an ria service and bind the data directly to the datagrid but ideally, I would like to loop through the fields in these entities and create hyperlinks for certain fields prior to adding the data to the datagrid. Does anyone have any thoughts on how to approach this problem ? Thanks,