DataSet

Question

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

Kalai · Answer

Thank you very much for ur reply.

Abhishek Kumar · Answer

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.

Akhil Mittal · Answer

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.

Akhil Mittal · Answer

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;

Jignesh Trivedi · Answer

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/

Hussain Ahmed · Answer

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

DataSet

Answers (6)