Accessing DataSet

[Yama]

Hi,

I have the following loaded into a dataset:

<xml version="1.0" encoding="UTF-16">
<xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<s:Schema id="RowsetSchema">
<s:ElementType name="row" content="eltOnly"
rs:CommandTimeout="30">
<s:AttributeType name="CustomerID" rs:number="1"
rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="5"
rs:fixedlength="true" rs:maybenull="false" />
</s:AttributeType>
<s:AttributeType name="CompanyName" rs:number="2"
rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="40"
rs:maybenull="false" />
</s:AttributeType>
<s:AttributeType name="ContactName" rs:number="3"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="30" />
</s:AttributeType>
<s:AttributeType name="ContactTitle" rs:number="4"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="30" />
</s:AttributeType>
<s:AttributeType name="Address" rs:number="5"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="60" />
</s:AttributeType>
<s:AttributeType name="City" rs:number="6"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="15" />
</s:AttributeType>
<s:AttributeType name="Region" rs:number="7"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="15" />
</s:AttributeType>
<s:AttributeType name="PostalCode" rs:number="8"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="10" />
</s:AttributeType>
<s:AttributeType name="Country" rs:number="9"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="15" />
</s:AttributeType>
<s:AttributeType name="Phone" rs:number="10"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="24" />
</s:AttributeType>
<s:AttributeType name="Fax" rs:number="11"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="24" />
</s:AttributeType>
<s:extends type="rs:rowbase" />
</s:ElementType>
</s:Schema>
<rs:data>
<z:row CustomerID="ALFKI" CompanyName="Alfreds Futterkiste"
ContactName="Maria Anders"
ContactTitle="Sales Representative" Address="Obere Str. 57"
City="Berlin" PostalCode="12209"
Country="Germany" Phone="030-0074321" Fax="030-0076545" />
<z:row CustomerID="ANATR" CompanyName="Ana Trujillo Emparedados
y helados" ContactName="Ana Trujillo"
ContactTitle="Owner" Address="Avda. de la Constitución 2222"
City="México D.F." PostalCode="05021"
Country="Mexico" Phone="(5) 555-4729" Fax="(5) 555-3745" />
</rs:data>
</xml>
Now when I try to access a row:

foreach (DataRow dr in ds.Tables[0].Rows)
{
dr[0] = "0";
}

How could I change column names and change row values?

Thanks,

~yamazed

[name]

Sorry, that did not make it into the visual zone of my OE Monitor
completely.

Don't you have some more crap to post.
"Yama" <Ya**@discussions.microsoft.com> wrote in message
news:83**********************************@microsof t.com...

Hi,

I have the following loaded into a dataset:

<xml version="1.0" encoding="UTF-16">
<xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema"> <s:Schema id="RowsetSchema">
<s:ElementType name="row" content="eltOnly"
rs:CommandTimeout="30">
<s:AttributeType name="CustomerID" rs:number="1"
rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="5"
rs:fixedlength="true" rs:maybenull="false" />
</s:AttributeType>
<s:AttributeType name="CompanyName" rs:number="2"
rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="40"
rs:maybenull="false" />
</s:AttributeType>
<s:AttributeType name="ContactName" rs:number="3"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="30" />
</s:AttributeType>
<s:AttributeType name="ContactTitle" rs:number="4"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="30" />
</s:AttributeType>
<s:AttributeType name="Address" rs:number="5"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="60" />
</s:AttributeType>
<s:AttributeType name="City" rs:number="6"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="15" />
</s:AttributeType>
<s:AttributeType name="Region" rs:number="7"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="15" />
</s:AttributeType>
<s:AttributeType name="PostalCode" rs:number="8"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="10" />
</s:AttributeType>
<s:AttributeType name="Country" rs:number="9"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="15" />
</s:AttributeType>
<s:AttributeType name="Phone" rs:number="10"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="24" />
</s:AttributeType>
<s:AttributeType name="Fax" rs:number="11"
rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="24" />
</s:AttributeType>
<s:extends type="rs:rowbase" />
</s:ElementType>
</s:Schema>
<rs:data>
<z:row CustomerID="ALFKI" CompanyName="Alfreds Futterkiste"
ContactName="Maria Anders"
ContactTitle="Sales Representative" Address="Obere Str. 57" City="Berlin" PostalCode="12209"
Country="Germany" Phone="030-0074321" Fax="030-0076545" />
<z:row CustomerID="ANATR" CompanyName="Ana Trujillo Emparedados y helados" ContactName="Ana Trujillo"
ContactTitle="Owner" Address="Avda. de la Constitución 2222" City="México D.F." PostalCode="05021"
Country="Mexico" Phone="(5) 555-4729" Fax="(5) 555-3745" /> </rs:data>
</xml>
Now when I try to access a row:

foreach (DataRow dr in ds.Tables[0].Rows)
{
dr[0] = "0";
}

How could I change column names and change row values?

Thanks,

~yamazed