DataSet

Kalai

12y1.7kLearn iOS Programming

What is Typed Dataset and UnTyped Dataset? When to use this ?

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kalai12y ago
Thank you very much for ur reply.
0
Abhishek Kumar12y ago
Hi,

Typed dataset :
A typed DataSet is a class that derives from a DataSet. As such, it inherits all the methods, events, and properties of a DataSet. Additionally, a typed DataSet provides strongly typed methods, events, and properties. This means you can access tables and columns by name, instead of using collection-based methods.

Creation :
RightClick solution explorer -> Add New Item then select DataSet.xsd

Untyped dataSet you can created in following manner by creating object of DataSet Class.
Dataset has one table with column name Name.
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataColumn cname= new DataColumn("Name");
dt.Columns.Add(cname);
ds.Tables.Add(dt);

Hope this helps.
0
Akhil Mittal12y ago
1)Typed DataSets use explicit names and DataTypes for their members.
example:
northwindDataSet.Products.ProductNameColumn.Caption = "pnames";

2)They have .xsd file (Xml Schema definition) file associated with them and do error checking regarding their schema at design time using the .xsd definitions.

UnTyped DataSets:
1)UnTyped DataSets use table and column collections for their members
ex:
ds.Tables["emp"].Columns["eno"].ReadOnly=true;

2)They do not do error checking at the design time as they are filled at run time when the code executes.
0
Akhil Mittal12y ago
Typed DataSet

1.It provides additional methods, properties and events and thus it makes it easier to use.
2.They have .xsd file (Xml Schema definition) file associated with them and do error checking regarding their schema at design time using the .xsd definitions.
3.We will get advantage of intelliSense in VS. NET.
4.Performance is slower in case of strongly typed dataset.
5.In complex environment, strongly typed dataset's are difficult to administer.
6.Typed DataSets use explicit names and DataTypes for their members.
Example: northwindDataSet.Products.ProductNameColumn.Caption = "pnames";

Untyped DataSet

1.It is not as easy to use as strongly typed dataset.
2.They do not do error checking at the design time as they are filled at run time when the code executes.
3.We cannot get an advantage of intelliSense.
4.Performance is faster in case of Untyped dataset.
5.Untyped datasets are easy to administer.
6.UnTyped DataSets use table and column collections for their members.
Example: ds.Tables["emp"].Columns["eno"].ReadOnly=true;
0
Jignesh Trivedi12y ago
hi,
Please refer following link it might help you
http://www.c-sharpcorner.com/UploadFile/rupadhyaya/TypedDataSets12032005021013AM/TypedDataSets.aspx
http://collecteddotnet.wordpress.com/2013/05/01/typed-dataset-and-untyped-dataset/
0
Hussain Ahmed12y ago
Dear Chk this Link

http://net-informations.com/faq/ado/typed-dataset.htm

AND

https://sites.google.com/site/interviewsharing/asp-net/difference-between-typed-dataset-and-untyped-dataset
0