using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using datagridview1.DataSet1TableAdapters;
namespace datagridview1
{
 public partial class Form1 : Form
 {
  public Form1()
  {
   InitializeComponent();
  }
  private void Form1_Load(object sender, EventArgs e)
  {
   CustomersTableAdapter adapter = new CustomersTableAdapter();
   bindingSource1.DataSource = adapter.GetData();
   dataGridView1.AutoGenerateColumns = false;
   int newColIndex = dataGridView1.Columns.Add("CompanyName", "CompanyName");
   dataGridView1.Columns[newColIndex].DataPropertyName = "CompanyName";
   newColIndex = dataGridView1.Columns.Add("ContactName", "ContactName");
   dataGridView1.Columns[newColIndex].DataPropertyName = "ContactName";
   newColIndex = dataGridView1.Columns.Add("Phone", "Phone");
   dataGridView1.Columns[newColIndex].DataPropertyName = "Phone";
   newColIndex = dataGridView1.Columns.Add("Contact", "Contact");
   dataGridView1.CellFormatting += OnCellFormatting;
   dataGridView1.DataSource = bindingSource1;
  }
  private void OnCellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
  {
   if (e.ColumnIndex == dataGridView1.Columns["Contact"].Index)
   {
    e.FormattingApplied = true;
    DataGridViewRow row = dataGridView1.Rows[e.RowIndex];
    e.Value = string.Format("{0}:{1}", row.Cells["ContactName"].Value, row.Cells["Phone"].Value);
   }
  }
 }
}