include rowstate in dataset.getxml

[Guest]

Hi Gurus,

how can i include rowstate value in dataset.getxml string

<datatable>
<row1 state="Added">
<col1>v1</col1>
</row1>
<row2 state="Modified">
<col1>v2</col1>
</row2>
</datatable>
</dataset>

i am passign the above string to stored proc(sql200) to perform DML operations
any help on this.

regards
mak

 

[amir massourian]

You can not, DataSet will not write RowState in Xml.

 

[Sahil Malik]

DataSet.GetXML is not what you need since it doesn't support such an
overload.

However you can use DataSet.WriteXML and pass in XmlWriteMode.DiffGram to
get the job done.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik