GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Microsoft  >  ADO.NET 2.0

 Print  |  
Question:  What is basic difference between Dataset and Typed Dataset. When to use Typed dataset?



February 02, 2008 20:13:38 #4
 amitkumar316   Member Since: February 2008    Total Comments: 6 

RE: What is basic difference between Dataset and Typed Dataset. When to use Typed dataset?
 

A typed dataset uses .xsd file i.e. the XML file to get information about the tables & columns. So we can use the table names & column names directly. We can derive a new dataset from a typed dataset.

In a general dataset, the tables & columns are exposed as collections & we have to make use of them.

 

e.g. consider a dataset 'ds' having a table 'emp' with a column 'eid' & we want to retrive the 1st record.

in typed dataset:- ds.emp(0).eid

in dataset:- ds.tables("emp")(0).columns("eid")

     

 

Back To Question