Help with Data Tables

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Ok. Brand new at this so please give a little patience and help me on the
baby steps. I'm rewriting something I did initially in PHP / MySql on a
vb.net / mysql platform. Here's what I'm doing:

1) Data is pulled from the internet and stored to a CSV file
2) Data is loaded into the database with some changes
3) All sorts of data crunching goes on.

Step one works fine -- data is saved to a csv file.
Step 2 -- The data is loaded from a CSV file into a table in a dataset. This
part works fine too. I have added a column to the table once it is full.
Code is:
DS.Tables("CSV").Columns.Add("Symbol")

That works fine too. Now I want to set fill that "Symbol" column with
something of my choosing. This will change regularly. How do I do this? I
have poked around the web for quite some time. I tried using:



Dim TestCmd As New OleDb.OleDbCommand("UPDATE CSV Set Symbol = 'YHOO';")

' testing below

DA.SelectCommand = TestCmd

DS.AcceptChanges()



And that doesn't work at all. Of course I"m very new to ADO.Net and could
use some pointers here. The only tutorials I can find online are how to
create a table from scratch. I want to simply add a column and, if
possible, set the text in all the fields in this column. Eventually, I will
need to know how to take the info from this datatable and dump it into my
database, but that's for later.



Please help! Thanks.



-Scott


.

Relevant Pages

  • Re: PHP/MySQL project
    ... > Looking to build a dynamic site using PHP/MySQL. ... > import changes to the database easily. ... Import the csv file into the MySql db, and then use phpmyadmin in the future ... The version of PHP will be important if you are considering finding / buying ...
    (alt.php)
  • Re: CSV(???)
    ... What csvline does is straightforward: ... into a csv file, the idea being that the office ... to a real database? ... The boss wanted me to use php because Python ...
    (comp.lang.python)
  • Re: Exporting From MySQL to .csv using PHP
    ... I'm sort of new to PHP. ... I am using the following code to retrieve a ... This allows creates a .csv file, ... result from the database. ...
    (comp.lang.php)
  • Re: In memory database
    ... from an Excel spreadsheet or CSV file. ... How do I sort this by gender+salary+age and get a subset of anyone over ... I've never used it from PHP, but AIUI SQLite has a PHP ... and can be used to create an in-memory database. ...
    (comp.lang.php)
  • Re: transfer data into an external database
    ... >With regards to your SQL code I have no idea about SQL. ... If there is a schema.ini in the same folder as the CSV file, ... >> Create a Schema.ini file based on an existing table in your database: ... John Nurick ...
    (microsoft.public.access.externaldata)