Don I do not think that you just can start with copying code. Before you start coding, you should know about the objectives of your project and develop a data model. This will in the end determine how your code will look like. Just copying other code will probably not resolve any issue you face today. For example it is crucial for you to know whether you want to keep quarterly data in a historical database (as I do) or you just want to copy in the QP data and replace older values.
As a quick start I recommend: - identify what data do you want to import to AB - group data items together (e.g. by frequency of update) - create the tables - Visual Studio then allows you a very easy access to the tables using TableAdapters; everything is generated automatically - Create the update procedures in C# Hope this helps. Rolf --- In [email protected], "Don Lindberg" <[EMAIL PROTECTED]> wrote: > > Jim, > > As to what I am trying to accomplish. I'm trying to learn how to get various > fundamental information from Quotes Plus into a SQL database that I will > then add additional data from another source. Ultimately I will then use the > upcoming SQL plug-in that Tomasz is working on to bring some parts of this > combined database into AmiBroker. But first I have to understand how to move > data around. That why I am interested in your code. I would really > appreciate it if you could share that code with me. I am sure I will learn > from it. > > > > > > Donald F Lindberg > > _____ > > From: [email protected] [mailto:quotes- [EMAIL PROTECTED] On > Behalf Of James Hutchison > Sent: Wednesday, September 26, 2007 9:47 AM > To: [email protected] > Subject: RE: [quotes-plus] Accessing Quotes Plus data from C# > > > > What are you trying to accomplish. I created this code a while back when i > was experimenting with the QP interface. If you like I can give you the > complete code for so you can play with it. I am not sure if you will > understand what I was doing but if you step through it with watches you may > be able to understand how to use the QP interface > > Jim Hutchison > > > > > At 01:53 AM 9/26/2007, you wrote: > > Jim, > > I am not a programmer, but I would like to set up a SQL Database using > Quotes Plus data. There are ways that I can use this data in my AmiBroker > charting software from SQL. > > The question I have is what lines do I have to change in your code to make > it work in my system ( file location? SQL Server ID? Etc) > > I am using MS SQL Server Express 2005, I also have Visual C++ 2008 Express > and Visual Basic 2008 Express. Anything I do in these programs is going to > be slow as I am just learning, but if you can tell me how to adapt your code > to my environment I would be VERY Grateful. > > > > Donald F Lindberg >
