c# - Add/modify SQL table -
This is the best way to code the requirement:
- The rows have multiple key indices (PlantID, Year, Month) in a SQL table.
- The row may already exist, update or delete an existing line.
- The row contains approximately 150 fields, which are the other SQL tables.
In trying to determine the easiest way to complete, I would like to use that SQLDataAdaptor, any thoughts would be appreciated.
SQL queries are easy:
Delete existing rows. Delete
table WHERE plantID = "..." and year = "..." and month = "..."
and now Enter a new one: INSERT (PlantID, Year, Month, Other_Col_1, ..., other_col_N) in the
table of prices ("...", "...", "... "," ... ", ...," ... ")
Comments
Post a Comment