Brief overview Datasets/XSD within ADO.NET

  • Thread starter Thread starter Dave Bundy
  • Start date Start date
D

Dave Bundy

Hi, I've been studying ADO.NET for a couple of weeks now. Books can only
explain so much so I thought maybe someone could shed some light on the matter
( that a vb newbie could understand )

What's the main purpose of a Dataset? Does it manipulate the DB on the clients
end?

What's the main purpose of XSD's?

I apologize if it seems out of the ordinary to ask such a question but I'm just
now getting to the point of addressing the learning curve. I'm studying the MS
ADO.NET Step by Step and the author seems to lack details...

Dave
Amnx(at)aol.com
 
Dave Bundy said:
Hi, I've been studying ADO.NET for a couple of weeks now. Books can only
explain so much so I thought maybe someone could shed some light on the matter
( that a vb newbie could understand )

What's the main purpose of a Dataset? Does it manipulate the DB on the clients
end?

Dave,
Think of a DataSet as an **in-memory** database. It can contains zero
to many DataTables.

It is kind like a client-side ADO Recordset. However the DataSet
can contain more than one DataTable (result set), whereas the
client-side ADO Recordset could only have one result set.

http://msdn.microsoft.com/library/en-us/cpguide/html/cpconcreatingusingdatasets.asp

What's the main purpose of XSD's?

The XSD allows you to create a scheme file, which you can use to
create a Typed DataSet. e.g. Add a new XSD file to your project,
then drag and drop a table from the server explorer onto the XSD
designer form, then right click on the designer form and select
"Generate DataSet", which runs the xsd.exe compiler for you.

http://msdn.microsoft.com/library/en-us/cpguide/html/cpconworkingwithtypeddataset.asp

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP
http://www.able-consulting.com
 
Back
Top