DataSet WriteXML

Does dataset writexml has a limit? let say it can only write 500 records or less..

As far as I am aware there is no limit, unless you are running out of space?

what error are you seeing?

No error! but the xml is ruined..
<OPEN>
<Table ................................/>
<Table ................................/>
<Table ................................/>
</OPEN><Table
<Table ................................/>
<Table ................................/>
<Table ................................/>
</OPEN>

Looks like possibly a coding error - can you post some sample code of how you are writing the file

I write xml using dataset.writexml

xmlDataSet.WriteXml(setConnectionString)

There is a vb.net sample here that works well