How to extract RadGrid EditableItem into a DataTable?

[Matthew]

Is it possible to extract the edited row from a RadGrid into a DataTable object?

The examples I've seen online show how to extract the data into a HashTable, but once you do that, you lose the data type (string, datetime, ect). We're building a generic grid that can display different tables, so we don't want to have to hard code the columns/data types. If the data is in a DataTable, then it can be passed directly to a SQL stored procedure that accepts a Table Value Parameter.

[Viktor Tachev]

Hello Matthew,

I guess you are referring to the ExtractValues() method that can be used to retrieve the values from an edited item in the grid. The parameter for the method is an IDictionary, this is why the examples are using Hashtable.

In order to pass the new values to the database I can suggest different approaches.

• Use the key/value pairs in the Hashtable and build the SQL query for update manually. Note that by default the keys will be the column UniqueNames and they will likely match the name of the field in the database (unless you modified them explicitly).
• Use the Hashtable and convert it to a DataTable like described in this article
• Use custom logic to retrieve the values from the grid cells and construct the DataTable manually. If you would like additional information on how to access the cell values you will like this article.

Regards,
Viktor Tachev
Telerik