This is a migrated thread and some comments may be shown as answers.

Suggestion for ExtractValues

8 Answers 302 Views

Grid

This is a migrated thread and some comments may be shown as answers.

skysailor asked on 08 May 2008, 06:23 AM

Hi,
I would like to suggest that you extend the RadGrid GridEditFormItem.ExtractValues method to support updating any business object. It could use reflection to find any properties that match the names of data bound columns.

This would make the data binding very powerful! If you don't use declarative databinding getting the values back into your database is a pain. But being able to simply update a LINQ generate entity object with a single method call would be a huge improvement.

So instead of doing :-

    
                Hashtable values = new Hashtable();  
        
                item.ExtractValues(values);  
        
                C.CategoryValue = (string)values["CategoryValue"];  
        
                C.Selectable_ = (bool)values["Selectable_"];  
        
            // etc. for all fields

You could do :-

    
                item.ExtractValues(C);

8 Answers, 1 is accepted

Accepted

answered on 18 Mar 2009, 03:31 PM

I want to ask a question please

I am using the following snippet of code:

Private Sub MyFunction(ByVal row As Telerik.Web.UI.GridDataItem)

   Dim data As New Dictionary(Of String, Object)
   row.ExtractValues(data)
   Dim mytype As String=row("id").GetType().ToString()

End Sub

although [id] stored in database as integer and returned in the datatable as integer also,but mytype always string,

you may tell me that it's because of the value type of Dictionary is Object, but if I do it like this:

data.Add("myid",1)
mytype = data("myid").GetType.ToString()

the type of myid is [System.int32]

the question is that why it's always string??? I need to make some mathematics for the values...

answered on 24 Mar 2009, 10:05 AM

I wrote the following code which corrects the issue i talked about previously , this function works exactly like row.ExtractValues, but it returns the correct format for each cell, not always (string)..

public static void ExtractValues(ref Telerik.Web.UI.GridDataItem row, ref Dictionary<string, object> data)
        {
            RadGrid rgrid = (RadGrid)row.Parent.Parent.Parent;

            for (int index = 0; index < rgrid.MasterTableView.Columns.Count; index++)
            {
                Type type = Type.GetType(rgrid.MasterTableView.Columns[index].DataType.ToString());
                object obj = Convert.ChangeType(row[rgrid.MasterTableView.Columns[index].UniqueName].Text, type);
                data.Add(rgrid.MasterTableView.Columns[index].UniqueName, obj);
            }

            for (int index = 0; index < rgrid.MasterTableView.AutoGeneratedColumns.Length; index++)
            {
                Type type = Type.GetType(rgrid.MasterTableView.AutoGeneratedColumns[index].DataType.ToString());
                object obj = Convert.ChangeType(row[rgrid.MasterTableView.AutoGeneratedColumns[index].UniqueName].Text, type);
                data.Add(rgrid.MasterTableView.AutoGeneratedColumns[index].UniqueName, obj);
            }
        }