_dataSet = new DataSet();
_dataSet.Locale = System.Globalization.CultureInfo.InvariantCulture; 


_adapterBooks.SelectCommand = new SqlCommand(@"	SELECT К.*, А.ФИО FROM Книги К 
						INNER JOIN Авторы А ON А.ИД_автора = К.ИД_автора", conn); 
_adapterBooks.Fill(_dataSet, "Книги");
   
_baseAdapterBooks.SelectCommand = new SqlCommand(@"SELECT * FROM Книги", conn);//для commandbuilder'а  

DbCommandBuilder builderBooks = factory.CreateCommandBuilder();
builderBooks.DataAdapter = _baseAdapterBooks;
            
_adapterBooks.InsertCommand = builderBooks.GetInsertCommand();
_adapterBooks.UpdateCommand = builderBooks.GetUpdateCommand();
_adapterBooks.DeleteCommand = builderBooks.GetDeleteCommand();

dgv.DataSource = _dataSet.Tables["Книги"];

_adapterBooks.Update(this._dataSet, "Книги");

_dataSet.AcceptChanges();

CurrencyManager cmgr = (CurrencyManager)this.dgv.BindingContext[this.dgv.DataSource];

_adapterBooks.Update(this._dataSet, "Книги");

 DataRow row = ((DataRowView)cmgr.Current).Row;
                    
                    SqlCommand cmd = new SqlCommand(@"	SELECT К.*, А.ФИО FROM Книги К 
						INNER JOIN Авторы А ON А.ИД_автора = К.ИД_автора
WHERE К.ИД_книги = " + row["ИД_книги"].ToString(), conn);

                    SqlDataReader reader = cmd.ExecuteReader();
                    
                    List<object> lst = new List<object>();

                    while (reader.Read())
                    {                       
                        for (int i = 0; i <= reader.FieldCount - 1; i++)
                        {
                            if (reader.GetValue(i).ToString() != row[reader.GetName(i)].ToString())
                            {
                                if (row.Table.Columns[reader.GetName(i)].ReadOnly)
                                {
                                    row.Table.Columns[reader.GetName(i)].ReadOnly = false;
                                    row[reader.GetName(i)] = reader.GetValue(i);
                                    row.Table.Columns[reader.GetName(i)].ReadOnly = true;
                                }
                                else
                                {
                                    row[reader.GetName(i)] = reader.GetValue(i);
                                } 
                            }
                        }
                        break;
                    }
                    reader.Close();
                  
                    _dataSet.AcceptChanges();