Downloading CSV to database?

Question

Hi there!

I am creating an finance application for the pocket pc(windows mobile sdk6),with C#.

Anyway,I want to download stock prices from yahoo finance and save them directly to a database.The files are downloaded in CSV format,eg:

http://finance.yahoo.com/d/quotes.csv?s=XOM+BBDb.TO+JNJ+MSFT&f=snd1l1yr

Theres loads of examples online of how to import a .CSV file to a database,but how can I import the information directly,without having to reference a physical file saved on the c drive?

Any help is greatly appreciated!!!

Thanks!

Sam Hobbs · Answer

If my reply helped you then please express your appreciation by checking the  Do you like this Answer  checkbox.

Sam Hobbs · Answer

The following will read the data directly but I am not sure what more you want. You indicate you don't want to import the data but probably it is possible to import from a web page. If you want to read the CSV data and then write the code to insert the data row-by-row into a table then I think I can help with that but I hope this is enough to get you going. using System; using System.IO; using System.Net; namespace _79686 { class Program { static void Main(string[] args) { String url = http://download.finance.yahoo.com/d/quotes.csv?s=XOM+BBDb.TO+JNJ+MSFT&f=snd1l1yr; const int BufferSize = 1000; Char[] BufferChars = new Char[BufferSize]; String BufferString; Console.WriteLine(Reading page: {0} url); HttpWebRequest myHttpWebRequest = (HttpWebRequest)WebRequest.Create(url); HttpWebResponse myHttpWebResponse = (HttpWebResponse)myHttpWebRequest.GetResponse(); Stream streamResponse = myHttpWebResponse.GetResponseStream(); StreamReader streamRead = new StreamReader(streamResponse); int count = streamRead.Read(BufferChars 0 BufferSize); while (count > 0) { BufferString = new String(BufferChars 0 count); Console.Write(BufferString); count = streamRead.Read(BufferChars 0 BufferSize); } streamResponse.Close(); streamRead.Close(); myHttpWebResponse.Close(); } } }