[Quantproject-developers] QuantDownloader/Downloader WebDownloader.cs,1.4,1.5
Brought to you by:
glauco_1
|
From: <gla...@us...> - 2003-11-30 22:42:18
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader
In directory sc8-pr-cvs1:/tmp/cvs-serv20248/Downloader
Modified Files:
WebDownloader.cs
Log Message:
- The namespace has been changed from QuantDownloader
to QuantProject.Applications.Downloader
- The ImportQuotesCsv class has been removed
Index: WebDownloader.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/WebDownloader.cs,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** WebDownloader.cs 30 Nov 2003 18:31:45 -0000 1.4
--- WebDownloader.cs 30 Nov 2003 22:41:59 -0000 1.5
***************
*** 11,15 ****
using QuantProject.DataAccess;
! namespace QuantDownloader
{
/// <summary>
--- 11,15 ----
using QuantProject.DataAccess;
! namespace QuantProject.Applications.Downloader
{
/// <summary>
***************
*** 371,400 ****
}
}
- public class ImportQuotesCsv
- {
- public ImportQuotesCsv()
- {
- OleDbConnection odConnection = new OleDbConnection();
- odConnection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=C:\Documents and Settings\Glauco\My Documents\Visual Studio Projects\QuantProject\QuantProject.mdb;Mode=Share Deny None;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False";
- odConnection.Open();
- OleDbCommand odc = new OleDbCommand();
- odc.CommandText =
- "INSERT INTO quotes" +
- "( quTicker, quDate, quOpen, quHigh, quLow, quClose, quVolume )" +
- "SELECT Ticker, cDate(Date), cDbl(Open), cDbl(High), cDbl(Low), cDbl(Close), cDbl(Volume) " +
- "FROM quotes_csv";
- odc.Connection = odConnection;
- try
- {
- odc.ExecuteNonQuery();
- }
- catch (Exception ex)
- {
- MessageBox.Show( ex.ToString() );
- }
- odConnection.Close();
- }
- }
-
}
--- 371,374 ----
|