I have an app that is retrieving list data via the Lists web service. Currently, all data is returned as a string in a DataTable. This works ok, but it doesn't work with the charting tool, which needs values of type int or float. So
I set the column types based on
http://msdn.microsoft.com/en-us/library/ms437580(v=office.12).aspx. For example, if the field type is Number, then I set the DataColumn type to Double. But now, certain values cause exceptions because the returned value doesn't parse to the
documented type. For example, Lookup type fields are documented to be stored as int types, but the actual values returned are like "1;#".
Does anyone have some advice about how to do this? I have a big switch statement that checks the field type, and sets the DataColumn type according to the documentation, and I'm thinking of reducing it so that it only sets some of the types, for instance,
Number and DateTime, but leaves the rest as string types.my blog - Tea Time with Meowkins
View Complete Post