title: Show values instead of id's sqlite
body: <p>I have database with tables <strong>user</strong> and <strong>department</strong>. Fields in <strong>user</strong> table are: id, login, pwd, editdate. In department table the field are id, description, user_id, editdate.
  The relation is: Relation only in VisualStudio. </p>
  
  <p>You can see screenshot here:
  <img src="https://i.stack.imgur.com/xZe8F.png" alt="http://i.imgur.com/3oRXSiN.png"></p>
  
  <p>So, i have dataGridView at form, which is binded to <strong>department</strong> table. </p>
  
  <p>Screen of the form with dataGridView (in Russian): 
  <img src="https://i.stack.imgur.com/qbWCu.png" alt="http://i.imgur.com/4urti4l.png"> .</p>
  
  <p>I want to see value from user table instead of ID 1 in "Автор записи" column.
  The some code:</p>
  
  <pre><code>    private void CatalogForm_Load(object sender, EventArgs e)
      {
          departmentTableAdapter.Fill(dataDataSet.department);
          userTableAdapter.Fill(dataDataSet.user);
      }
  
      private void DepartmentCatalogView()
      {
          catalogGridView.DataSource = departmentBindingSource;
          Text = @"Подразделения";
          catalogGridView.AutoGenerateColumns = false;
          catalogGridView.Columns[0].Visible = false;
          catalogGridView.Columns[1].HeaderText = @"Подразделение";
          catalogGridView.Columns[2].HeaderText = @"Автор записи";
          catalogGridView.Columns[3].HeaderText = @"Дата записи";
      }
  </code></pre>