Monte Baker
Top achievements
Rank 2
Rank 2
Monte Baker
asked on 28 Apr 2010, 10:01 PM
Do you have any samples of ItemSourceBinding using ADO.Net Data Services. I am trying to filter the contents of the comboboxcolumn by an ID column in the GridView, but as yet I have found no references on how to do this when you are consuming data from ADO.Net
Monte Baker
Monte Baker
3 Answers, 1 is accepted
0
Hello Monte Baker,
I am not sure we have such example. However please give me some more details on the logic you need to implement and I wil try to provide some sample code or guidance.
All the best,
Pavel Pavlov
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
I am not sure we have such example. However please give me some more details on the logic you need to implement and I wil try to provide some sample code or guidance.
All the best,
Pavel Pavlov
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Monte Baker
Top achievements
Rank 2
Rank 2
answered on 29 Apr 2010, 04:54 PM
what I am trying to do is use a gridview to allow a user to create a schedule. I have a gridview grouped by Days of the Week with each employee listed as the row. I have the hours or shifts as column headings. the idea was that each cell would be a combo with the Job Roles that employee was allowed to work. In the database I have three tables that matter for this, Employee (EmployeeID, Name, Etc.); JobCodes (JobCodeID, JobCode, JobCodeDescription, Etc.); and EmployeeJobCode(EmployeeID, JobCodeID, PayRate, Active). What I was hoping to achieve was either to be able to load EmployeeJobCode when the grid was loaded and then be able to reference that in the repetitive rows, or to load all of EmployeeJobCode in one object and filter each combo based on that rows employee ID.
With the Begin, endExecute methods with ADO.Net Data Services I have had no look at either method. the "Driver Sample" at the bottom of http://www.telerik.com/help/silverlight/radgridview-columns-column-types-combobox-column.html is almost exactly what I would like to do, but I dont see any way to use Binding in XAML and set the datasource equal to a BindingCollection object.
With the Begin, endExecute methods with ADO.Net Data Services I have had no look at either method. the "Driver Sample" at the bottom of http://www.telerik.com/help/silverlight/radgridview-columns-column-types-combobox-column.html is almost exactly what I would like to do, but I dont see any way to use Binding in XAML and set the datasource equal to a BindingCollection object.
0
Hello Monte Baker,
I found I have a similar example here. Please find it attached ( VS2010,RIA and NorthWind required)
It uses RIA services , but the client side implementation of the combo column would be the same.
It has a RadGridView bound to the Orders table of the Northwind database.
For each row it displays a combobox with Customers filtered by the ShipCountry.
So to achieve this - I have added a Customers property to the Order Entity . (List<Customer)
This way in XAML I Can use binding like <ComboBoxColumn ItemsSourceBinding={Binding Customers} ...
In your case you will need to add a property to the Employee class - Roles ( e.g. List<Roles> Roles)
to contain the roles filtered by users.
then in XAML use syntax like :
<ComboBoxColumn ItemsSourceBinding={Binding Roles} . . .
If you have troubles implementing this approach , just send me your project ( in a compileable/runable state) and I will make the neccessary modifications.
Regards,
Pavel Pavlov
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
I found I have a similar example here. Please find it attached ( VS2010,RIA and NorthWind required)
It uses RIA services , but the client side implementation of the combo column would be the same.
It has a RadGridView bound to the Orders table of the Northwind database.
For each row it displays a combobox with Customers filtered by the ShipCountry.
So to achieve this - I have added a Customers property to the Order Entity . (List<Customer)
This way in XAML I Can use binding like <ComboBoxColumn ItemsSourceBinding={Binding Customers} ...
In your case you will need to add a property to the Employee class - Roles ( e.g. List<Roles> Roles)
to contain the roles filtered by users.
then in XAML use syntax like :
<ComboBoxColumn ItemsSourceBinding={Binding Roles} . . .
If you have troubles implementing this approach , just send me your project ( in a compileable/runable state) and I will make the neccessary modifications.
Regards,
Pavel Pavlov
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.