This is the Select query, is this correct?
ID, Shrt_Desc, Qty, Units, Water, Energ_Kcal, Lipid_Tot, FA_SAt, FA_Poly, FA_Mono, Cholestrl,
Carbohydrt, Fiber_TD, Sugar_Tot, Protein, Sodium, Vit_A_IU, Vit_B6, Vit_B12, Vit_C, Vit_E, Vit_K,
Alpha_Carot, Beta_Carot, Folate_Tot, Folic_Acid, Lycopene, Niacin, Retinol, Ribolfavin, Thiamin,
Calcium, Copper, Iron, Manganese, Magnesium, Phosphorus, Potassium, Selenium, Zinc, Meal, [User],
Make sure that your initial SELECT query is pulling the primary key down
from the database and is populated in the DataTable along with the other
info. You do not need to show the PK brought down, but you can use it as the
value to check against during your updates.