title: Problems updating the database
body: <p>I have attached code for reference. I am trying to create database for my project details. I have currently 2 forms:</p>
  
  <ol>
  <li>main form  </li>
  <li>project detail form</li>
  </ol>
  
  <p>Main form used to switch various forms </p>
  
  <p>Project detail forms are meant for add / edit / load project details</p>
  
  <p>My main form in visual basic look like this.</p>
  
  <pre><code>Public Class Form1
  
      Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
      End Sub
  
      Private Sub Bt_Project_Details_Click(sender As Object, e As EventArgs) Handles Bt_Project_Details.Click
          Me.Hide()
          Project_Details_Form.Show()
      End Sub
  End Class
  </code></pre>
  
  <p>My project detail form look like this.</p>
  
  <pre><code>Public Class Project_Details_Form
  
      Private Sub Project_Details_Form_Load(sender As Object, e As EventArgs) Handles MyBase.Load
          'TODO: This line of code loads data into the 'Project_Data_Set.Project_Data_Table' table. You can move, or remove it, as needed.
          Me.Project_Data_TableTableAdapter.Fill(Me.Project_Data_Set.Project_Data_Table)
      End Sub
  
      Private Sub Bt_Load_Project_Click(sender As Object, e As EventArgs) Handles Bt_Load_Project.Click
      End Sub
  
      Private Sub Bt_Cancel_Click(sender As Object, e As EventArgs) Handles Bt_Cancel.Click
          Me.Hide()
          Form1.Show()
      End Sub
  
      Private Sub BindingNavigatorAddNewItem_Click(sender As Object, e As EventArgs) Handles BindingNavigatorAddNewItem.Click
          Project_Data_TableBindingSource.AddNew()
      End Sub
  
      Private Sub Project_Data_TableBindingNavigatorSaveItem_Click(sender As Object, e As EventArgs) Handles Project_Data_TableBindingNavigatorSaveItem.Click
          Me.Validate()
          Me.Project_Data_TableBindingSource.EndEdit()
          Me.TableAdapterManager.UpdateAll(Me.Project_Data_Set)
      End Sub
  
      Private Sub BindingNavigatorDeleteItem_Click(sender As Object, e As EventArgs) Handles BindingNavigatorDeleteItem.Click
          Project_Data_TableBindingSource.RemoveCurrent()
      End Sub
  
      Private Sub FillByToolStripButton_Click(sender As Object, e As EventArgs)
          Try
              Me.Project_Data_TableTableAdapter.FillBy(Me.Project_Data_Set.Project_Data_Table)
          Catch ex As System.Exception
              System.Windows.Forms.MessageBox.Show(ex.Message)
          End Try
  
      End Sub
  End Class
  </code></pre>
  
  <p>Now I am facing a few problems:</p>
  
  <ol>
  <li><p>Whenever I run the program, try to enter first entry data being saved but with empty value. The data enter next time being stored properly. How can make my first entry visible?</p></li>
  <li><p>In below code:</p>
  
  <pre><code>Private Sub BindingNavigatorAddNewItem_Click(sender As Object, e As EventArgs) Handles BindingNavigatorAddNewItem.Click
      Project_Data_TableBindingSource.AddNew()
  
  End Sub
  </code></pre>
  
  <p>I am using <code>AddNew()</code>. This working fine, but problem is even I don't enter data like date, name kept empty, data recorded in their position is store empty only. I would like to say if any of project data set is empty give error message (since it mandatory for user to enter those data)</p></li>
  </ol>