Thanks Erel
Thanks mate.
I use one command object throughout my app.
How do I clear the parameters after I use them?
For example the Shifts tabls has these fields
ShiftId, Owner, ShiftDate, ShiftStart, ShiftEnd, Fares, EndSpeedo, StartSpeedo, PayIn50, InsLevy, FuelExp, Dockets, EFTPOS, MyTotal & Quotes
The Fares table has
FareId, FareDate, FareHash, TimeStart, TimeEnd, Pickup, Dropoff, Fare, FareType, Booked & Tip
I'd like to name my parameters like
cmd.AddParameter("Owner") and add all Shifts parameters, then build for the Fares table and so on for all the other tables.
or do I add all parameters in say app_start and then build my command text using only the parameters I need.
regards, Ricky