954,551 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Difference between typed dataset and untyped dataset..?

Hi all...

Someone give me the difference between typed dataset and untyped dataset..

Regards,
Balagurunathan S

BalagurunathanS
Light Poster
26 posts since Apr 2007
Reputation Points: 10
Solved Threads: 0
 

A typed dataset is a custom class generated for your project by Visual Studio that makes common jobs easier. It adds things like named properties that match column and row data in the tables. It's generated code and not a part of .NET, so you can't use typed datasets without Visual Studio unless you copy all of the code and manually customize it for your project. An untyped dataset is an object of the DataSet class. It's a part of .NET and you can use it even if you don't have Visual Studio.

Hamrick
Posting Whiz
325 posts since Jun 2007
Reputation Points: 180
Solved Threads: 34
 

Typed Dataset:

s = dsCustomersOrders1.Customers(0).CustomerID

Untyped Dataset:

string s = (string) dsCustomersOrders1.Tables["Customers"].Rows[0]["CustomerID"];

typed dataset is generally used as it is easy to use and moreover gives errors at compile time...compared to untyped which gives on run time

vinod991
Newbie Poster
1 post since Jun 2010
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You