Heloo All,
I have two simple tables. Tbl_Users, Tbl_Roles.
Tbl_users is defined as...
UserID --> PK(Varchar)
UserName
Password
RoldID(Int)
Tbl_Roles is defined as ...
RoleId --> PK(int)
RoleDescription(varchar)
Data Model is ADO.NET Entity Data Model, SilverLight3.0(Navigation Apllication), .NET RIA Services Class Lib.
All I need to do is have a DataForm to do Crud Operations on the Tbl_users,, but the roleID should show List of RoleDescription in a combobox. When adding new User a drop down of all the available rolesdescriptions and when editig an exixting user, the combo should have the Role selected.
I am so far able to create the CRUD operations without the Combobox. I am using DomanDataServices as my bridge to Silverligh and Data.
Unfortunatly I cannot change the table schema as there is a classic ASP app sitting on top of it.
Any ideas or pointer will be very helpful. I searched blogs of Manish Dalal, Nikhil, but did not fit my need.
I really appreciate your feedback as I hit a wall at this point.
Thanks a million.