Changing a datatable from many columns to just 2

Question

I have a datatable with many columns, like so;

Name | Age | Foo | Bar | Etc..
Joe | 30 | foo | bar | Etc..

I need to now get this datatable into just two columns consisting of just the headers followed by their values, like so;

This is so that a DataBinder can access it easily when the data is bound.

How can this be done, and do I need to do this at all?

EDIT: Including example code

asp.net

<div class="itemDetail col-s">                                                                                                                       
  <div class="itemDetailLabel">                                                                                                                            
    <%# DataBinder.Eval(Container.DataItem, "Caption")%>                                                                                                                        
  </div>                                                                                                                        
  <div class="itemDetailValue">                                                                                                                       
    <%# If(DataBinder.Eval(Container.DataItem, "UIValue") Is Nothing OrElse String.IsNullOrEmpty(DataBinder.Eval(Container.DataItem, "UIValue").ToString()), "&nbsp;", DataBinder.Eval(Container.DataItem, "UIValue"))   %>                                                                                                                        
  </div>                                                                                                                    
</div>

vb.net

Dim oldDataTable As DataTable = DataSource ''Which is a datatable of a single row
Dim newDataTable As New DataTable

newDataTable.Columns.Add("Caption")
newDataTable.Columns.Add("UIValue")

''Change the single row into multiple rows

fooControl.DataSource = newDataTable
fooControl.DataBind()

EDIT2: So for those that are still learning like me, this is called transposing. Thanks for @gofal3 for pointing it out

You should add your current code to the question so that we can help you with the issue — Valerio Santinelli, May 14 '18 at 10:10
See codeproject : https://www.codeproject.com/Questions/816778/How-to-bind-particular-columns-of-dataset-to-a-dat — jdweng, May 14 '18 at 10:11

score 0 · Accepted Answer · answered May 14 '18 at 10:28

0

You have to transpose the DataTable. As far as I know there is no built in method, but you have to write your own code to do so. But there are a lot of examples how other did it. eg: https://www.codeproject.com/Articles/44274/Transpose-a-DataTable-using-C or Transpose a datatable

answered May 14 '18 at 10:28

gofal3

1,213
10
16

Ah okay, I didn't know there was a name for it, which is probably why my searching wasn't returning anything of value. – Alex Wilson May 14 '18 at 10:35

Changing a datatable from many columns to just 2

1 Answers1