da = new SqlDataAdapter(query, cn);

            SqlCommandBuilder cb = new SqlCommandBuilder(da);
            cb.ConflictOption = ConflictOption.OverwriteChanges;

            dt = new DataTable();
            da.FillSchema(dt, SchemaType.Source);
            da.Fill(dt);

            dataGridView1.DataSource = dt;

            dataGridView1.EndEdit();               
            da.Update((DataTable)dataGridView1.DataSource);