Declarative binding to multiple keys?

[Effendi]

I have a form which user enters a main Sales Order number as a "main key". This key is used to fetch data and display it on a gridview. In the same form, users can enter multiple other keys. This is when a customer has multiple sales order associated with a project.

1. Can I popolulate the data in the gridview in multiple key?
2. If this can be done only programatically, how to I keep appending the dataset on every data fetch before binding it to the grid?

Thanks in advance.

[Radoslav]

Hello Effendi,

To achieve the desired functionality you could try using the Advanced Data-Binding of the RadGrid. Into the NeedDataSource event you could set the DataSource of the RadGrid to the DataTable which contains the filtered data. When users apply new search criteria and add additional key you could build a new DataTable which contains new filtered data(by multiple keys) from database.
Generally the RadGrid could be bound to:

• DataSet, DataTable, or DataView

• Array of DataRow

• Any object collection that implements the IListSource, IList, IEnumerable, or ICustomTypeDescriptor interface.

So in your case you need to get data from the database by multiple keys and store it into one of the described containers.

Please give it try and let me know if you experience any problems.

Greetings,
Radoslav
the Telerik team