title: when should dataset reflect the updated rows count after an insert in vb.net
body: <p>i have a sql database, and have created a dataset for a sample table in it.</p>
  
  <p>The dataset is HotelDataSet2 and data table adapter to insert to it is Various_itemsTableAdapter.</p>
  
  <pre><code> MsgBox(HotelDataSet2.various_items.Rows.Count)
   Various_itemsTableAdapter.Insert(Item_nameTextBox.Text, itemcode, PackingTextBox.Text, UomTextBox.Text, PriceTextBox.Text, RemarksTextBox.Text, TaxTextBox.Text, StatusCheckBox.Checked, Rate_inclusiveCheckBox.Checked)
   MsgBox(HotelDataSet2.various_items.Rows.Count)
  </code></pre>
  
  <p>This always reflects the same count, before and after inserting..But if i execute this</p>
  
  <pre><code>MsgBox(HotelDataSet2.various_items.Rows.Count)
  Various_itemsTableAdapter.Insert(Item_nameTextBox.Text, itemcode, PackingTextBox.Text, UomTextBox.Text, PriceTextBox.Text, RemarksTextBox.Text, TaxTextBox.Text, StatusCheckBox.Checked, Rate_inclusiveCheckBox.Checked)
  Various_itemsTableAdapter.Fill(HotelDataSet2.various_items)
  MsgBox(HotelDataSet2.various_items.Rows.Count)
  </code></pre>
  
  <p>it shows the new count to be +1 of the old one. So i concluded that everytime i change some data to the table via table adapter, i have to always refill the dataset?? How is that useful then??</p>