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(); } } }

Downloading CSV to database?

Fadi Yoosuf

Bechir Bejaoui