I have been asked by a client to access information from a web service.
They have given me the following access code
WebRequest request = WebRequest.Create( "http://www.odata.charities.govt.nz/GrpOrgLatestReturns?$filter=Donationskoha gt 1000000&$format=csv");
WebResponse Response = request.GetResponse();
What is the best way to get this information into a datatable so I can display this in a datagrid?
Do I have to loop through each line and split the comma separated values?
How do I save this as a CSV file?