| Author: purushothaman 28 Aug 2008 | Member Level: Gold | Rating:  Points: 4 |
hi
see this link
http://aspalliance.com/1367_Typed_Dataset_and_its_Usages
http://www.c-sharpcorner.com/UploadFile/rupadhyaya/TypedDataSets12032005021013AM/TypedDataSets.aspx
http://www.sellsbrothers.com/askthewonk/Secure/Whatsthedifferencebetween.htm
|
| Author: Legend 29 Aug 2008 | Member Level: Silver | Rating: Points: 6 |
Introduction
The word Dataset does not need an introduction because it is one of most commonly used objects in the .NET world. So proceeding with this assumption, a typed dataset is an object that derives from the Dataset class and additionall, it provides strongly typed access to its containing tables and columns. To justify the above line still in depth, to access tables and columns in a dataset we use:
Listing 1: Dataset and Typed Dataset
ds.Tables["0"].Rows[0][0].ToString();or
ds.Tables["Customers"].Rows[0]["Name"].ToString();The same can be accessed in typed dataset as:
ds.Customers[0].Name;
AND SIPMLE EXAMPLE TO Creating of typed DATASET
Creating Typed Datasets with the Data Source Configuration Wizard or with the Dataset Designer
To create a dataset with the Data Source Configuration Wizard
On the Data menu, click Add New Data Source to start the Data Source Configuration Wizard.
Select Database on the Choose a Data Source Type page.
Complete the wizard and a typed dataset is added to your project. For more information, see Data Source Configuration Wizard.
To create a dataset with the Dataset Designer
On the Project menu, click Add New Item.
Select DataSet from the Add New Item dialog box.
Type a name for the dataset.
The dataset is added to the project and opens in the Dataset Designer.
Drag items from the DataSet tab of the Toolbox onto the designer. For more information, see How to: Edit a Dataset.
-or-
Drag items from an active connection in Server Explorer/Database Explorer onto the Dataset Designer.
|
| Author: Swaminathan 30 Aug 2008 | Member Level: Gold | Rating: Points: 4 |
Schema is present in typed dataset.That's the main difference
between dataset and typed dataset.
Because of the presence of schema, any mismatch in column of db table
will generate compile time error where as normal data set generates
run time error.
Also typed dataset retrieves data faster than the normal data set.
|
| Author: http://venkattechnicalblog.blogspot.com/ 31 Aug 2008 | Member Level: Diamond | Rating: Points: 2 |
Oops its closely associated with the schema ...
Regards,
Venkatesan Prabu .J
http://venkattechnicalblog.blogspot.com/
|