Populating DataSet: (xsd and xml) Or (xml). Difference? - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Populating DataSet: (xsd and xml) Or (xml). Difference?

viwufiviwufi Posts: 22Member

(using .net2003)

[code]
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"] );
[/code]

and

[code]
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"] );
[/code]

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

Thanx,

Comments

  • iwilld0itiwilld0it Posts: 1,134Member
    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)
    :
    : [code]
    : 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"] );
    : [/code]
    :
    : and
    :
    : [code]
    : 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"] );
    : [/code]
    :
    : What is the difference, because ReadXml method works just fine without first reading the schema?
    :
    : Thanx,
    :

Sign In or Register to comment.