This may be a beginner’s issue, but I am having trouble with a situation that I need help with. One set of data that is stored in an ArrayList and another that is stored in the DB (results from a stored procedure).
I need to have a RadGrid with two columns (right now the RadGrid is on the .aspx page, but the datasource is binded in the code-behind). The first column’s cell’s will all have different values, but the second column should have a dropdown list populated with the same data in each cell (e.g. product list). Essentially the data in column 1 will not be editable, but the value in each cell/drop down for column 2 needs to be selectable. The data is column 1 is not stored in the DB (it is from an ArrayList that is built from reading data from a file the user just uploaded), while the data that would be in the drop downs in column 2 is from the results of a stored procedure in the DB. It is a mapping exercise where the user must match an item from the array list to an item from the drop down list then save the changes for each row or the RadGrid as a whole.
ArrayList Column DropDownListColumn (Each row should have a dropdown list with the same choices, populated from the same stored procedure call)
ArrayListString(i) DropDownList
Does something like a datatable/dataset need to be built programatically in the background? Could you please show me how to do this?
1 Answer, 1 is accepted
In this case, you have two types of data. The first is the data which resides in the database, and is pulled from there via the Stored Procedure. The other data is the static data. Hence, you can use the NeedDataSource event handler, and create a custom DataTable, which includes both types of data. This DataTable can be passed as a datasource for the grid.
I hope this suggestion helps.
All the best,
Yavor
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.