Go to edit dataset with designer (you can go there from the "Data" menu then "show data sources" and "Edit dataset with designer".
Right click the adapter and select "Configure". Click "Advanced options". Make sure the "Refresh the data table" is selected. Click OK and Finish.