2
Answers

Downloading CSV to database?

Brendan Moroney

Brendan Moroney

15y
4.5k
1
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!


Answers (2)
0
Bhabani Prasad

Bhabani Prasad

NA 1.4k 36.2k 10y
You just include the exception details as it will be easier to find the detailed error
0
Rajagopalan R V

Rajagopalan R V

NA 422 33.2k 10y
Sorry Can't Get Meaning For Your Above Post Please Can You Explain it Clearly
0
Jasmine Nagrecha

Jasmine Nagrecha

NA 180 4.2k 10y
i need to keep ssl=false, and defaultcredentials is =false. ideally, these settings should help. but i guess its something related to machine configuration
0
Rajagopalan R V

Rajagopalan R V

NA 422 33.2k 10y
Hi.,

Had You Allow Permissions in IIS

If Not Check With Below Method

Go to IIS
IIS---->
Default SMTP Virtual Server (Right Click) ----> Properties ----> Access ----> Relay ----> All Except the List Below (Radio Button) Select that And Click Ok And then Execute Your Code

If U Got Solution With this Mark it Has Accepted

Or Else Please Post The Error

With Regards..,

R.V.Rajagopalan
0
Yadlapalli Srikanth

Yadlapalli Srikanth

NA 238 51.6k 10y
Please share the sample code and also do the following settings

smtpClient.UseDefaultCredentials = false;
smtpClient.EnableSsl = true;