Hallo,
kann mir bitte jemand mitteilen, wo hier der Fehler ist?
http://www1.minpic.de/bild_anzeigen.php?id=119691&key=90780188&ende
http://www1.minpic.de/bild_anzeigen.php?id=119692&key=77439128&ende
DataSet
Aktualisieren: TableMapping['Table'] oder DataTable 'Table' kann nicht gefunden werden.
DataTable
"Das Objekt des Typs System.Data.DataSet kann nicht in Typ System.Data.DataTable umgewandelt werden."
// Create a DataSet.
DataSet data =
new DataSet ();
// Bind the master data connector to the Customers table.
masterBindingSource.DataSource = data;
masterBindingSource.DataMember = "Customers" ;
Ich weise dem BindingSource das Dataset zu.
Jetzt will ich halt updaten. Beide Fälle gehen nicht.
private void tsBSave_Click(object sender,
EventArgs e)
{
//masterDataAdapter.Update((DataSet)masterBindingSource.DataSource);
//detailsDataAdapter.Update((DataSet)detailsBindingSource.DataSource);
masterDataAdapter.Update((DataTable )masterBindingSource.DataSource);
detailsDataAdapter.Update((DataTable )detailsBindingSource.DataSource);
}
P.S. Das muss ich noch so lassen, da ich keinen SQL Express Server installiert habe.
string
help2;
help2 = string .Format("Data Source=.\\SQLEXPRESS;AttachDbFilename=\"C:\\_Prog\\ \\MasterDetail\\NORTHWIND.MDF\";Integrated Security=True;Connect Timeout=10;User Instance=True"
);
connectionString = help2;
Grüße Andreas
using
System;
using
System.Collections.Generic;
using
System.ComponentModel;
using
System.Data;
using
System.Drawing;
using
System.Linq;
using
System.Text;
using
System.Windows.Forms;
using
System.Data.SqlClient;
namespace
MasterDetail
{
public partial
class Form1 :
Form
{
// private DataGridView masterDataGridView = new DataGridView();
// private BindingSource masterBindingSource = new BindingSource();
// private DataGridView detailsDataGridView = new DataGridView();
// private BindingSource detailsBindingSource = new BindingSource();
SqlDataAdapter masterDataAdapter;
SqlDataAdapter detailsDataAdapter;
public Form1()
{
InitializeComponent();
// masterDataGridView.Dock = DockStyle.Fill;
// detailsDataGridView.Dock = DockStyle.Fill;
// SplitContainer splitContainer1 = new SplitContainer();
// splitContainer1.Dock = DockStyle.Fill;
// splitContainer1.Orientation = Orientation.Horizontal;
// splitContainer1.Panel1.Controls.Add(masterDataGridView);
// splitContainer1.Panel2.Controls.Add(detailsDataGridView);
// this.Controls.Add(splitContainer1);
// this.Load += new System.EventHandler(Form1_Load);
this .Text = "DataGridView master/detail demo" ;
}
private void Form1_Load(object sender,
EventArgs e)
{
// Bind the DataGridView controls to the BindingSource
// components and load the data from the database.
masterDataGridView.DataSource = masterBindingSource;
detailsDataGridView.DataSource = detailsBindingSource;
GetData();
// Resize the master DataGridView columns to fit the newly loaded data.
masterDataGridView.AutoResizeColumns();
// Configure the details DataGridView so that its columns automatically
// adjust their widths when the data changes.
detailsDataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode .AllCells;
}
private void GetData()
{
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 =
"Integrated Security=SSPI;Persist Security Info=False;" +
"Initial Catalog=Northwind;Data Source=localhost" ;
string help2;
help2 = string .Format("Data Source=.\\SQLEXPRESS;AttachDbFilename=\"C:\\_Prog\\ \\MasterDetail\\NORTHWIND.MDF\";Integrated Security=True;Connect Timeout=10;User Instance=True"
);
connectionString = help2;
SqlConnection connection =
new SqlConnection (connectionString);
// Create a DataSet.
DataSet data =
new DataSet ();
data.Locale = System.Globalization.CultureInfo .InvariantCulture;
// Add data from the Customers table to the DataSet.
masterDataAdapter = new
SqlDataAdapter ("select * from Customers" , connection);
masterDataAdapter.Fill(data, "Customers" );
// Add data from the Orders table to the DataSet.
detailsDataAdapter = new
SqlDataAdapter ("select * from Orders" , connection);
detailsDataAdapter.Fill(data, "Orders" );
// northwindDataSet.
// Establish a relationship between the two tables.
DataRelation relation =
new DataRelation ("CustomersOrders" ,
data.Tables["Customers" ].Columns["CustomerID" ],
data.Tables["Orders" ].Columns["CustomerID" ]);
data.Relations.Add(relation);
// Bind the master data connector to the Customers table.
masterBindingSource.DataSource = data;
masterBindingSource.DataMember = "Customers" ;
// Bind the details data connector to the master data connector,
// using the DataRelation name to filter the information in the
// details table based on the current row in the master table.
detailsBindingSource.DataSource = masterBindingSource;
detailsBindingSource.DataMember = "CustomersOrders" ;
}
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 tsBSave_Click(object sender,
EventArgs e)
{
//masterDataAdapter.Update((DataSet)masterBindingSource.DataSource);
//detailsDataAdapter.Update((DataSet)detailsBindingSource.DataSource);
masterDataAdapter.Update((DataTable )masterBindingSource.DataSource);
detailsDataAdapter.Update((DataTable )detailsBindingSource.DataSource);
}
}
}
