DataSet and DataTable

What is dataset and datatable? How both of them are related to each other. And what are the uses of it.

I also want to know how to create a dataset manually and display the data in the web page using c sh开发者_如何学编程arp.

As i am newbie to .net and c sharp

A data set is a collection of data tables and the relationships between them. It normally represents a set of database tables and the relationships (foreign keys) between them. See DataSet on MSDN.

A data table is usually a representation of a database table, in memory. See DataTable on MSDN.

The uses are that you do not need to go to the database every time you want to lookup a value.

The rest of your question is rather broad and not really answerable, as there are many ways to create a dataset in memory. You need to be much more specific regarding what you are trying to do.

A DataSet is an in memory representation of data,It containing one or more DataTables. A DataTable is an in-memory representation of data, typically retrieved from a database or XML source.

As far as I remember, a DataSet is a collection of DataTables and the Relations between tables.

A DataTable is an object that represents a table of data similar to a database table.

If I were you I'd avoid the use of DataSets and DataTables as they are fairly heavyweight objects and for simple display you don't need any of the extra features that they provide.

Google for information about DataReaders and maybe DataReaders vs DataTables