Synchrous between ADO table and Sql Server databse table
At first ,i use bulk insert to insert ADO table to SQl Server Database table .But if i use bulk insert ,i must delete all record in SQl server table.My problem is synchrous between ADO table and Sql Server databse table ,it mean i don't need delete exit data in SQL server table (ex : if data is exit i do not something ,but data is not exit so insert data.Or data in SQL table and data in ADO table is difference So make to update .... ) Please help me