vj#: Do you know of a way to add columns to a DataTable? I have to use a
DataView, which needs a DataTable, with columns.

[quoted text, click to view]

Yes, we do.


Lets say you have this datatable.
System.Data.DataTable dt = new System.Data.DataTable("One Table");


( fill some data into the data table)
sqlDataAdapter1.Fill( dt );


Make a dataview to hold the data table.
System.Data.DataView dv = new System.Data.DataView( dt );


Add a new column to the data tabel and the dataview.
dt.get_Columns().Add("A new column");


Or you can do this:
dv.get_Table().get_Columns().Add("A second column");



You can view the DataView through a DataGrid WinForms GUI control with this
code:

dataGrid1.set_DataSource( dv );



Regards,
Lars-Inge Tønnessen