Typed Dataset and its Usages: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Typed Dataset and its Usages

page 1 of 10

Published: 24 Aug 2007

Abstract
This article explains the some uses of typed datasets and some of the common problems that may occur during typed dataset development.

by Satheesh Babu
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 44773/ 64

Article Contents:

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();

ds.Tables["Customers"].Rows[0]["Name"].ToString();

The same can be accessed in typed dataset as:

ds.Customers[0].Name;

View Entire Article

(Page 2) »

User Comments

Title: Why good for only very small projects?
Name: Mark
Date: 2010-11-14 5:14:00 PM
Comment:
Why are Typed DataSets viable only if our project sizes are really small? How about a hybrid: BOs in the middle and UI tiers; Typed DataSets at the DataLayer side--Resolving data-changes from BOs to DataSets?

Title: I need urgent help plz
Name: Fadi
Date: 2010-06-13 2:10:47 PM
Comment:
hi there, i am using typed dataset for my rdlc reports in my winforms app with C#. i m inserting data in database form different forms. the problem is, on run time when i insert data in the database its not updated data in rdlc reports, to get new data in my reports i need to close my app and debug it again to see new data in the reports. Is there any way to forcedly refresh data in my typed dataset on runtime???? Looking forward from your positive response.

Fadi

Title: developer
Name: John Jones
Date: 2009-08-27 5:19:58 PM
Comment:
One point I forgot to mention:
Our main goal is to use the same SQL queries (basic inserts, updates, deletes) in both MS Access and SQL Server. Our app was originally written for Access using the VS designer to generate the queries. After testing these queries, we found that if the ` char was removed and replaced by [ ] brackets, then all the queries would work in both db's.

Title: developer
Name: john
Date: 2009-08-26 12:46:38 PM
Comment:
We have a DataSet with Table Adapters built for MSAccess using OLEDB. We are using Visual Studio 2005 and .Net 2.0.

When the designer creates insert, update and delete queries it encloses the table name and field names with a ` (ASCII char 96).
For example:

INSERT INTO `table` (`col1`, `col2`, `col3`) values (....)

Is there a reason for this character? Assuming it's for escape purposes, is there a setting to make Visual Studio use another character, eg "[" or "]"?

Title: sir
Name: jim
Date: 2008-12-15 8:18:50 PM
Comment:
where is the method SetUnitPriceNull found - not in this sample

Product Spotlight