I suppose you are looking for the actual flow among datatable, dataset, Dataview and Datagrid..
whenever, you need to fetch data and show in the data to the user, this is the normal flow..
1) First establish a connection to the database from which data is to be retrieved
2) Open the connection and use either DataAdapter or Datareader to read the data from the Database with the opened connection.
3) Store the data into Dataset which is the local cache of the actual Database fetched
4) Optionally Dataview can be created for this data which is in Dataset( which is literally collection of tables or a single table)
5) Assign either Dataview or a Datatable directly to the source of the Datagrid
You can see in MSDN for more in detail..
check this how to work dynamically with the above said
http://www.codeproject.com/KB/aspnet/dynamicdataoperations.aspx |