DataGrid Column Display

[hkl]

Thank you for Soliant's suggestion using the DataTableMapping object. But I think the TableMapping function is just to map the data from source to datatable. It doesn't specify the order of the columns in the dataset, does it? I still can't figure out how I can display the data in my own way. It is still in alphabetical order from left to right. I've also tried using TableMapping property from the DataAdapter. Did I do something wrong? or miss anything? Please give me a little more detail about it. Thank you!

[A Wegierski]

Very unusual case (I use Oracle, MSSQL and DB2). Try to define Your own fields in DataGrid: DataGridTextBoxColumn tc1,tc2; DataGridTableStyle ts; DataGrid myDataGrid; tc1 = new DataGridTextBoxColumn(); tc1.MappingName="myColumn1Name"; ... tc2 = new DataGridTextBoxColumn(); tc2.MappingName="myColumn2Name"; ... ts = new DataGridTableStyle() ts.MappingName = "myTableName"; ... ts.GridColumnStyles.AddRange(new DataGridColumnStyle[] { tc1,tc2 }); myDataGrid.TableStyles.AddRange(new DataGridTableStyle[]{ ts }); myDataGrid.DataSource = myTable ... Sincerely AW