How to add if not exist rows to SQL table from DataGridView

when you call the Update() method then only for the rows that are affected since the last time DataSet was filled, corresponding SQL statements will be fired.

If after filling the DataSet you have inserted a new row then row state becomes inserted and when you call the Update() then the necessary Insert statement is fired only for that new row.