I have a form contains a datagridview to show product details. There're two tables called as "LOCATION_PRODUCT" and "TARGET_PRODUCT". Initially , product codes are retrieved by "LOCATION_PRODUCT" table and displays inside the DataGridView. Datagridview contain 13 columns as follows,
TARGET_PROD_ID, TARGET_JAN, TARGET_FEB, TARGET_MAR, TARGET_APR, TARGET_MAY, TARGET_JUN, TARGET_JUL, TARGET_AUG, TARGET_SEP, TARGET_OCT, TARGET_NOV,
TARGET_DEC
What I need to know is, if the product code is exist in the "TARGET_PRODUCT" table,
How to get the row which contain the product code and replace it in datagridview.
Please help me to sort out this issue