1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:

]namespace test_datenbank
{
public partial class Form1 : Form
{
SqlDataAdapter adapterPublisher;
SqlDataAdapter adapterBooks;
DataSet dsLibrary;
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename='C:\Users\nig go\Documents\Visual Studio 2010\Projects\Library.mdf';Integrated Security=True;Connect Timeout=30;User Instance=True");
SqlCommand command = new SqlCommand("SELECT * FROM Publishers", conn);
adapterPublisher = new SqlDataAdapter(command);
SqlCommandBuilder cbPublisher = new SqlCommandBuilder(adapterPublisher);

adapterBooks = new SqlDataAdapter("SELECT * FROM Books", conn);
SqlCommandBuilder cbBooks = new SqlCommandBuilder(adapterBooks);

dsLibrary = new DataSet();

dsLibrary.Tables.Add("Publishers");
adapterPublisher.Fill(dsLibrary, "Publishers");
dsLibrary.Tables.Add("Books");
adapterBooks.Fill(dsLibrary, "Books");

dsLibrary.Relations.Add("Publishers_Books",
dsLibrary.Tables["Publishers"].Columns["PublisherId"],
dsLibrary.Tables["Books"].Columns["PublisherId"]);

BindingSource bsPublishers = new BindingSource();
bsPublishers.DataSource = dsLibrary;
bsPublishers.DataMember = "Publishers";
dataGridView1.DataSource = bsPublishers;

dataGridView1.DataSource = bsPublishers;
dataGridView1.Columns[0].Visible = false;
BindingSource bsBooks = new BindingSource();
bsBooks.DataSource = bsPublishers;
bsBooks.DataMember = "Publishers_Books";

dataGridView2.DataSource = bsBooks;
}

private void btnAbbrechen_Click(object sender, EventArgs e)
{
Application.Exit();
}

private void btnSpeichern_Click(object sender, EventArgs e)
{
adapterPublisher.Update(dsLibrary, "Publishers");
adapterBooks.Update(dsLibrary,"Books");
}
}
}                    

1:
2:

adapterBooks.Update(dsLibrary,"Books");
adapterPublisher.Update(dsLibrary, "Publishers");