DataSet WriteXML empty fields /columns

[Milo]

Hi all,

I am doing a windows mobile project that uses ASP.NET web services.

Web service returns dataset-s that are pulled from database and later saved
on local mobile storage (write XML). On client (WM 6.1) program loads
dataset (read XML and read XML schema) when needed. User can insert/aappend
new records.

My problem occures when some data fileds are empty... default method
WriteXML, on client side, does not create XML nodes for empty
fields/columns.
Than when you are trying to reference some field value that was empty, you
get exception.

Is there any property or method of DataSet that I could use to save dataset
with all fields/columns regardless if empty or not ?

Reagards,
Milo

 

[Jamal Samedov]

Hi Milo,
there was almost the same problem with some differencies:
- it was in VS 2005
- windows XP
- the datasource MS SQL 2005
By reading Image field if it is empty.
The problem was solved by implementation of Binding.Format event.
If the field was referenced by some control then assign to evenet handler
some procedure which should treat the field special way.
The same you can do for other field types.
Regards,

J.N. Samedov,