Fill combo box in silverlight using collections !!

Question

Dear All I have a table and I want to load a combobox in silverlight using LINQ-to-SQL Classes. Table- ID FName 1 Keyur 2 Nishant Now In my silverlight Page I want to load the combobox with FName columns. I have to compulsarily use System.Collection.Generics - eg - list. My Linq Query - var fnames = from names in TblNames select new { names.FName}; I am getting an error in using IList Interface. Please help me out.. Thank You all in advance !!

Santhosh Kumar Jayaraman · Answer

You have return type as Tbl_FNames. But you are returning list of string. public List LoadTypes() { try { context = new ComplaintManagementSystemDataClasses1DataContext(); return context.Tbl_FNames.ToList() ; } catch (Exception err) { err.Message.ToString(); return null; } }

Santhosh Kumar Jayaraman · Answer

List strlist= from names in TblNames select new { names.FName}.ToList();

Riddhi Valecha · Answer

Hi all... I am still having issues in loading combo box in silverlight dynamically. My requirement is - There is a Silverlight Page(.xaml file) Class file(class1.cs file) Service file(svc.cs file). I have written the [OperationContract] in Service file(svc.cs file). I have written the EventHandlers and Listeners and Methods in Class file(class1.cs file). There are 2 methods: 1)CheckLogin() and 2)FillData(). And finally invoked the method in Silverlight Page(.xaml file). There is no error. But during debugging the control goes to the CheckLogin() after debugging FillData() method. And the combo box is not loaded. Please help me out.

Riddhi Valecha · Answer

Hi... I have taken your code... Started solving and debugging it... I'll try and complete it by today itself....

Bhushan Gupta · Answer

plz help solve this problem ... Crystal report generate in silverlight use sql DB  use service WCF plz check and solve it ....thanks bhushangniit@yahoo.com

Santhosh Kumar Jayaraman · Answer

check my article.. http://www.c-sharpcorner.com/UploadFile/1a81c5/silverlight-application-with-mvvm-wcf-and-entity-framework/

Riddhi Valecha · Answer

True !! I did your code in a new silverlight project !! It worked.... But the SilverlightServiceReference is not getting updated and hence I am not able to make the event handlers to load the combo box... To update the ServiceReference I did a right click on the servicereference and clicked Update Service Reference. Still not working !!! Thanks !!!

Santhosh Kumar Jayaraman · Answer

then change the return type to list

Riddhi Valecha · Answer

Very true !! But in the combobox I just want the First Names column..... I am unable to get that !! The linq query is - var result = from users in context.Tbl_FirstName select users.FName;

Riddhi Valecha · Answer

Hi I have to write a method in WCF Service in silverlight as below: public List LoadTypes() { try { context = new ComplaintManagementSystemDataClasses1DataContext(); var comtypes = from types in context.Tbl_FNames select types.FNames.ToList() ; return comtypes.ToList(); } catch (Exception err) { err.Message.ToString(); return null; } }