C#

Moderators: None (Apply to moderate this forum)
Number of threads: 2720
Number of posts: 5746

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
Populating DataSet: (xsd and xml) Or (xml). Difference? Posted by viwufi on 27 Dec 2004 at 3:47 PM

(using .net2003)

DataSet ds = new DataSet();
FileStream fs = 
new FileStream( "XML.xml", FileMode.Open, FileAccess.Read );
ds.ReadXml( fs ); 
fs.Close();
						
foreach( DataRow dr in ds.Tables["user"].Rows ) 
  Console.WriteLine( "name:{0}", dr["name"] );


and

DataSet ds = new DataSet();

FileStream fs = 
new FileStream( "schema.xsd", FileMode.Open, FileAccess.Read );
ds.ReadXmlSchema( fs ); 
fs.Close(); 

fs = new FileStream( "XML.xml", FileMode.Open, FileAccess.Read );
ds.ReadXml( fs ); 
fs.Close();

foreach( DataRow dr in ds.Tables["user"].Rows )
  Console.WriteLine( "name:{0}", dr["name"] );


What is the difference, because ReadXml method works just fine without first reading the schema?

Thanx,
Report
Re: Populating DataSet: (xsd and xml) Or (xml). Difference? Posted by iwilld0it on 28 Dec 2004 at 12:25 PM
Schema explicitly defines the data-types for the columns and such. Not using the schema forces the dataset to make the best guess for the data-types, which might be a wrong assumption.

:
: (using .net2003)
:
:
: DataSet ds = new DataSet();
: FileStream fs = 
: new FileStream( "XML.xml", FileMode.Open, FileAccess.Read );
: ds.ReadXml( fs ); 
: fs.Close();
: 						
: foreach( DataRow dr in ds.Tables["user"].Rows ) 
:   Console.WriteLine( "name:{0}", dr["name"] );
: 

:
: and
:
:
: DataSet ds = new DataSet();
: 
: FileStream fs = 
: new FileStream( "schema.xsd", FileMode.Open, FileAccess.Read );
: ds.ReadXmlSchema( fs ); 
: fs.Close(); 
: 
: fs = new FileStream( "XML.xml", FileMode.Open, FileAccess.Read );
: ds.ReadXml( fs ); 
: fs.Close();
: 
: foreach( DataRow dr in ds.Tables["user"].Rows )
:   Console.WriteLine( "name:{0}", dr["name"] );
: 

:
: What is the difference, because ReadXml method works just fine without first reading the schema?
:
: Thanx,
:




 

Recent Jobs