I need to insert 10 records into a table. They are all slightly different.
What would be the best way?
Table
ID int (autonumber)
Person varchar(50)
Amount money
DateInserted datetime
Data
John, $1.23, 1/2/2007
Sally, $2.43, 1/3/2007
Mark, $3.45, 1/6/2007
Carol, $5.00, 1/1/2007
Bob, $2.32, 1/1/2008
etc...
Should I populate an array, walk through it, and call an insert statement for each?
Is there a better data type to use?
New to C#... could use this as an example. Thanks.
Start Free Trial
