This code is without using tableadapter, but with dataadapter.Please clear your dataset with Clear() function and then Fill() the dataset.I have used MS Access Database with OleDB Connection
string con1 = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Documents and Settings\sam\my documents\visual studio 2010\Projects\WindowsFormsApplication1\WindowsFormsApplication1\Database1.accdb";
string query1 = "SELECT * FROM Table2";
OleDbDataAdapter da1 = new OleDbDataAdapter(query1, con1);
OleDbCommandBuilder cmd = new OleDbCommandBuilder(da1);
da1.Update(database1DataSet2.Table2);
this.database1DataSet2.Table2.Clear();
da1.Fill(database1DataSet2.Table2);