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);
   }
  }
 }
}