Hi Leute,
ich möchte die Tabelle aus der dataGridView drucken, leider bekomme ich nur eine weiße Seite...
private void tabelleAnzeigenComboBox3_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
this.connectionBuilder2 = new MySqlConnectionStringBuilder
{
Server = server,
Database = datenbank,
UserID = user,
Password = passwort
};
using (MySqlConnection connection = new MySqlConnection(this.connectionBuilder2.ConnectionString))
{
sql = String.Format("SELECT * FROM `{0}`", tabelleAnzeigenComboBox3.Text);
datatable2 = new DataTable(tabelleAnzeigenComboBox3.Text);
this.dataAdapter2 = new MySqlDataAdapter(sql, connection);
this.dataAdapter2.MissingSchemaAction = MissingSchemaAction.AddWithKey;
MySqlCommandBuilder builder = new MySqlCommandBuilder(this.dataAdapter2);
dataAdapter2.Fill(this.datatable2);
}
dataGridViewAusgabe.DataSource = this.datatable2;
}
catch (Exception er)
{
MessageBox.Show("An Error Occured" + er.Message);
}
}
private void updateButton_Click(object sender, EventArgs e)
{
if (this.dataAdapter2 == null)
return;
try
{
dataAdapter2.Update(datatable2);
}
catch (System.FormatException)
{
MessageBox.Show("Bitte das Format der Spate(n) beachten!");
}
catch (InvalidOperationException f)
{
MessageBox.Show("Fehler" + f);
}
}
private void druckenButton_Click(object sender, EventArgs e)
{
printDocument1.Print();
}
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
Bitmap bm = new Bitmap(this.dataGridViewAusgabe.Width, this.dataGridViewAusgabe.Height);
dataGridViewAusgabe.DrawToBitmap(bm, new Rectangle(0, 0, this.dataGridViewAusgabe.Width, this.dataGridViewAusgabe.Height));
e.Graphics.DrawImage(bm, 0, 0);
}
Sieht jemand den Fehler?
