Reg: Copy data from GridGroupingControl to DataTable

[Anna Srinivasan]

Hi,
Source for GridGroupingConrol - DataTable

DataTable dt;
dt = dataTable.Copy();
If i do copy like this, what is there in dataTable is directly come to my dt(datatable).But i need grid look and feel to dt.

Problem Example:
If datatable column contain name for example Asset_ID,but while showing in to grid they are showing like this ''Asset''

Q1: I need datatable like what is there in grid.?

Help me..!

[Administrator]

Here is a sample that will move the columns into a datatable in the sample order as the grid if that is what you mean by look and feel.

http://www.syncfusion.com/Support/user/uploads/ggc_DT_b3e8e41f.zip

[Anna Srinivasan]

Hi,
Example is working fine....!

All records which are present in the grid i can able to get in the dataTable except column headers.

Colummn headers i am getting what is there in grid control source dataTable.

How do i get column header what is there in gridgrouping control..?

Thanks, Anna

[Administrator]

Instead of naming the columns using cd.Name, name them with the HeaderText.

foreach(GridVisibleColumnDescriptor cd in this.gridGroupingControl1.TableDescriptor.VisibleColumns)
{
	string s = this.gridGroupingControl1.TableDescriptor.Columns[cd.Name].HeaderText;
	dt.Columns.Add(new DataColumn(s, this.gridGroupingControl1.TableDescriptor.Columns[cd.Name].FieldDescriptor.GetPropertyType()));
}

[Anna Srinivasan]

Hi,
In your example , i need to change any of the code in this line.
dr[cd.Name] = r.GetValue(cd.Name);

b''cause. If i dint change i am getting following error.

Additional information: Column ''OUTST_QTY'' does not belong to table .

Note : ''OUTST_QTY'' this column belongs to grid source table

One more thing , I tried with header text string in [dr[cd.Name] = r.GetValue(cd.Name);] this point i am getting only header but not data which are present in the grid.

Help me...!

[Administrator]

Here is a sample that has different headertext than column names.

http://www.syncfusion.com/Support/user/uploads/ggc_DT_679e7885.zip