Customer:
----------------
George
Jane
Joe     <---I edit this to "Allan" and then click Update

Customer:
-------------
Allan
Allan
Allan

public partial class Form3 : Form
    {
        
        private BindingSource bindingSource1 = new BindingSource();
        private SqlDataAdapter dataAdapter = new SqlDataAdapter();
        DataSet ds = new DataSet();

        public Form3()
        {

            InitializeComponent();
            dataGridView1.Dock = DockStyle.Fill;

            
            FlowLayoutPanel panel = new FlowLayoutPanel();
            panel.Dock = DockStyle.Top;
            panel.AutoSize = true;
            panel.Controls.AddRange(new Control[] { button1, button2 });

            this.Controls.AddRange(new Control[] { dataGridView1, panel });
            this.Text = "DataGridView databinding and updating demo";
        }

        private void invoiceToolStripMenuItem1_Click(object sender, EventArgs e)
        {

        }

        private void Form3_Load(object sender, EventArgs e)
        {
            dataGridView1.DataSource = bindingSource1;
           // Utilities myUtilities = new Utilities();
           // myUtilities.GetData("select * from Client");
           GetData("select * from Client");

        }

        private void button1_Click(object sender, EventArgs e)
        {
            GetData(dataAdapter.SelectCommand.CommandText);
           // Utilities myUtilities = new Utilities();
           // myUtilities.GetData(dataAdapter.SelectCommand.CommandText);
        }

        private void button2_Click(object sender, EventArgs e)
        {
          
            //dataAdapter.Update(ds,"Client");
            this.dataAdapter.Update(this.ds, "Client");

            
        }

        private void GetData(string selectCommand)
        {
            try
            {
                // Specify a connection string. Replace the given value with a
                // valid connection string for a Northwind SQL Server sample
                // database accessible to your system.
                String connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\FS.mdf;Integrated Security=True;User Instance=True";


                // Create a new data adapter based on the specified query.
                dataAdapter = new SqlDataAdapter(selectCommand, connectionString);
                dataAdapter.Fill(ds, "Client");
                // Create a command builder to generate SQL update, insert, and
                // delete commands based on selectCommand. These are used to
                // update the database.
                SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);
                
                dataAdapter.Fill(ds);
                // Populate a new data table and bind it to the BindingSource.
                DataTable table = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                dataAdapter.Fill(table);
                bindingSource1.DataSource = table;

                // Resize the DataGridView columns to fit the newly loaded content.
                dataGridView1.AutoResizeColumns(
                    DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
            }
            catch (SqlException)
            {
                MessageBox.Show("To run this example, replace the value of the " +
                    "connectionString variable with a connection string that is " +
                    "valid for your system.");
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            GetData(textBox1.Text);
        }

      
    }