private DataSet _dataSet;
	private SqlDataAdapter _adapterBooks;
	private SqlDataAdapter _adapterWriters;
	
	BindingSource bsBooks;
	BindingSource bsWriters;
	BindingSource bsAuthors;
	
	DbProviderFactory factory;
	
	private void GetData()
	{
		_dataSet = new DataSet();
		_dataSet.Locale = System.Globalization.CultureInfo.InvariantCulture;

		//==================================================================
		//создаем адаптеры
		//==================================================================
		_adapterBooks = new SqlDataAdapter();
		_adapterBooks.SelectCommand = new SqlCommand(@"SELECT * FROM Книга", conn);

		_adapterWriters = new SqlDataAdapter();
		_adapterWriters.SelectCommand = new SqlCommand(@"SELECT * FROM Писатели", conn);
		
		//-------------создаем адаптеры


		//==================================================================
		//заполняем датасет и создаем отношения     
		//==================================================================
		_adapterBooks.Fill(_dataSet, "Книги");
		_adapterBooks.FillSchema(_dataSet.Tables["Книги"], SchemaType.Source);
	 
		_adapterWriters.Fill(_dataSet, "Писатели");
		_adapterWriters.FillSchema(_dataSet.Tables["Писатели"], SchemaType.Source);
		
		relation = _dataSet.Relations.Add("Авторы",
		  _dataSet.Tables["Писатели"].Columns["ИД_писателя"],
		  _dataSet.Tables["Книги"].Columns["ИД_автора"]); 
		
		//------------заполняем датасет и создаем отношения


		//==================================================================
		//устанавливаем bindings и SQL-команды для вкладки Главное
		//==================================================================
		bsBooks = new BindingSource(_dataSet, "Книги");

		bsWriters = new BindingSource(_dataSet, "Писатели");

		bsAuthors = new BindingSource(bsWriters, "Авторы");

		tbName.DataBindings.Add(new Binding("Text", bsBooks, "Название", true));//textBox с названием книги
		lblAuthor.DataBindings.Add(new Binding("Text", bsAuthors, "Фамилия"));//label с фио автора

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