This demo shows what schema information is brought across from the DB to a dataset in ADO.NET, depending upon the code statements used.

It  uses the Northwind SQL Server database.  There is a module-level variable ConnString, which holds the connection information. You will have to enter your own connection string information there.

Click the different buttons and see in the two datagrids what schema information and what data is brought over from the DB to the dataset for the different statements.

Also, click the Find Primary Key button to see when the primary key information is available in the dataset.