Downloading CSV to database?

Brendan Moroney

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!

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs16y ago
If my reply helped you, then please express your appreciation by checking the "Do you like this Answer" checkbox.

Sam Hobbs16y ago

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

		}

	}

}