I'm trying to find the best way to configure my radgrid to accomplish this scenario.
Here is the scenario:
(This all occurs within my Default.aspx page)
1. A radtextbox control prompts the user to input the customer number. The customer number is validated using data coming from a table adapter.
2. I want to pass the customer number entered above into another query (table adapter) and return a item details dataset using it. This is the dataset
that I want my RadGrid connected to.
I have been able to figure out how to accomplish everything above by using the RadGrid (onneeddatasource) event.
Here is where my problem comes in:
3. One of the columns in my item details dataset (column name PRINT) is a Boolean datatype. I have set the PRINT column in my datatable associated with the table adapter to read-only = false. I need to give the user ability to (check or un-check) that column in my RadGrid and have it update the datatable only. I have no requirement to go back and update the SQL database with the updated datatable. This data is going to be used to generate a sql report which is included in this project.
In summary, I haven't been able to find a way to query and store results in a local datatable and allow the radgrid to update that local datatable. I've looked at the batch editing capability, but I don't like the way it requires having to press the save button in between paging. I'd like to code it so that the user can click the check box and it immediately saves the result to the data table.
Is there anyone out there that can give me some advice or an example of how I can accomplish this problem?