DataGridView

DataGridView Einstieg

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using System.IO; //Öffnen der XMLnamespace DataGridView{ public partial class Form1 : Form { public Form1() { InitializeComponent(); } DataTable table = new DataTable(); DataSet dataSet = new DataSet(); DataRow dr; string[] Device = new string[10]; // Hier wird eine Array mit 10 Stringelementen erzeugt private void Form1_Load(object sender, EventArgs e) { //Datatable erstellen table.Columns.Add("Gerät", typeof(String)); table.Columns.Add("Typ", typeof(String)); table.Columns.Add("Anzahl", typeof(String)); table.Columns.Add("Bezeichnung", typeof(String)); dgv.DataSource = table; //Der Inhalt der Tabelle wird mit dem DataGridView verknüpft dataSet.Tables.Add(table);//Die Tabelle wird mit DataSet verknüpft //Gerät für Combobox Device[0] = "Computer"; Device[1] = "Tastatur";

Device[2] = "Maus"; Device[3] = "Bildschirm"; Device[4] = "Drucker"; Device[5] = "Handy"; Device[6] = "Bluetooth Stick"; Device[7] = "Fernbedienung"; Device[8] = "Mousepad"; Device[9] = "Wlan Karte";
for (int i = 0; i < Device.Length; i++) { cbDevice.Items.Add(Device[i]); //Die Geräte als Items der Combobox hinzufügen }
} private void Adding_Click(object sender, EventArgs e) //Anfügen an die vorhandene Tabelle { label1.Text = cbDevice.Items.Count.ToString(); dr = table.NewRow(); dr[0] = cbDevice.Text; dr[1] = tbTyp.Text; dr[2] = tbMenge.Text; dr[3] = tbBez.Text; table.Rows.Add(dr); } private void insert_Click(object sender, EventArgs e) //Oberhalb der markierten Zeile einfügen { dr = table.NewRow(); dr[0] = cbDevice.Text; dr[1] = tbTyp.Text; dr[2] = tbMenge.Text; dr[3] = tbBez.Text; table.Rows.InsertAt(dr, dgv.CurrentCell.RowIndex); } private void Speichern_Click(object sender, EventArgs e) //Speichern als XML { SFD1.FileName = "Tabelle"; SFD1.DefaultExt = "xml"; SFD1.Filter = "XML-Datei (*.xml)|*.xml"; if (SFD1.ShowDialog() == System.Windows.Forms.DialogResult.OK) { table.WriteXml(@SFD1.FileName); } } private void Laden_Click(object sender, EventArgs e) //Öffnen einer XML { OFD1.FileName = "Tabelle"; OFD1.Filter = "XML-Datei (*.xml)|*.xml"; if (OFD1.ShowDialog() == System.Windows.Forms.DialogResult.OK) { //System.IO.StreamReader sr = new System.IO.StreamReader(OFD1.FileName); table.ReadXml(@OFD1.FileName); //sr.Close(); } } private void DelRow_Click(object sender, EventArgs e) //Ausgewählte Zeile löschen { table.Rows.RemoveAt(dgv.CurrentCell.RowIndex); } private void TabDel_Click(object sender, EventArgs e) //Ganze Tabelle löschen { table.Clear(); } }

Tutorial Arbeiten mit Multi DataGridViews, Zeilen auslesen, Spalten- /Zeilenindex auswerten, eigenes Ereignis hinzufügen.

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms;

namespace RadioRec { public partial class Form2 : Form { public Form2() { InitializeComponent(); } DataTable t1 = new DataTable(); DataSet ds1 = new DataSet(); DataRow dr; DataTable t2 = new DataTable(); DataSet ds2 = new DataSet(); DataTable t3 = new DataTable(); DataSet ds3 = new DataSet(); //Internes Datagridview zur Datenverarbeitung DataGridView dgv = new DataGridView(); DataTable dt = new DataTable(); //Alle DGVs, die ich erstellen werde DataGridView dgv2 = new DataGridView(); DataGridView dgv3 = new DataGridView(); private void Add_Page(String Bez, String Name, DataGridView DGV, DataTable dt, DataSet ds) { TabPage tp = new TabPage(Bez); tp.Name = "tp" + Bez; tc1.TabPages.Add(tp); for (int i = 0; i < dgvStart.Columns.Count; i++) { dt.Columns.Add(t1.Columns[i].ColumnName, typeof(String)); } DGV.DataSource = dt; ds.Tables.Add(dt); DGV.Size = dgvStart.Size;

DGV.Location = dgvStart.Location; DGV.Name = Name; DGV.AllowUserToAddRows = true; DGV.Click += new EventHandler(this.Tabelle_SelectedIndexChanged); tp.Controls.Add(DGV); } private void Form2_Load(object sender, EventArgs e) { t1.Columns.Add("Name"); t1.Columns.Add("Alter"); t1.Columns.Add("Sonstiges"); dgvStart.DataSource = t1; ds1.Tables.Add(t1); dgv = dgvStart; dt = t1; Add_Page("Test","dgv2", dgv2, t2, ds2); Add_Page("Test2","dgv3", dgv3, t3, ds3); OFD.Title = "Tabellen Laden"; OFD.FileName = "Tabelle1"; OFD.DefaultExt = "xml"; OFD.Filter = "XML-Datei (*.xml)|*.xml"; if (OFD.ShowDialog() == System.Windows.Forms.DialogResult.OK) { t1.ReadXml(OFD.FileName); } OFD.Title = "Tabellen Laden"; OFD.FileName = "Tabelle2"; OFD.DefaultExt = "xml"; OFD.Filter = "XML-Datei (*.xml)|*.xml"; if (OFD.ShowDialog() == System.Windows.Forms.DialogResult.OK) { t2.ReadXml(OFD.FileName); } OFD.Title = "Tabellen Laden"; OFD.FileName = "Tabelle3";

OFD.DefaultExt = "xml"; OFD.Filter = "XML-Datei (*.xml)|*.xml"; if (OFD.ShowDialog() == System.Windows.Forms.DialogResult.OK) { t3.ReadXml(OFD.FileName); } } int Zeile; int Spalte; private void Tabelle_SelectedIndexChanged(object sender, EventArgs e) { dgv = sender as DataGridView; try { Zeile = dgv.CurrentCell.RowIndex; Spalte = dgv.CurrentCell.ColumnIndex; } catch(Exception) { } tb1.Text = dgv.Rows[Zeile].Cells[0].Value.ToString(); tb2.Text = dgv.Rows[Zeile].Cells[1].Value.ToString(); tb3.Text = dgv.Rows[Zeile].Cells[2].Value.ToString(); } private void button1_Click(object sender, EventArgs e) { SFD.Title = "Tabellen Speichern"; SFD.FileName = "Tabelle1"; SFD.DefaultExt = "xml"; SFD.Filter = "XML-Datei (*.xml)|*.xml"; if (SFD.ShowDialog() == System.Windows.Forms.DialogResult.OK) { t1.WriteXml(SFD.FileName); } SFD.Title = "Tabellen Speichern"; SFD.FileName = "Tabelle2";

SFD.DefaultExt = "xml"; SFD.Filter = "XML-Datei (*.xml)|*.xml"; if (SFD.ShowDialog() == System.Windows.Forms.DialogResult.OK) { t2.WriteXml(SFD.FileName); } SFD.Title = "Tabellen Speichern"; SFD.FileName = "Tabelle3"; SFD.DefaultExt = "xml"; SFD.Filter = "XML-Datei (*.xml)|*.xml"; if (SFD.ShowDialog() == System.Windows.Forms.DialogResult.OK) { t3.WriteXml(SFD.FileName); } } private void tc1_SelectedIndexChanged(object sender, EventArgs e) { switch(tc1.SelectedIndex) { case 0: dgv = dgvStart; dt = t1; break; case 1: dgv = dgv2; dt = t2; break; case 2: dgv = dgv3; dt = t3; break; default: dgv = dgvStart; dt = t1; break; } } private void btAdd_Click(object sender, EventArgs e) { try { dr = dt.NewRow(); dr[0] = tb1.Text; dr[1] = tb2.Text; dr[2] = tb3.Text; dt.Rows.Add(dr); } catch(Exception)

{ } } } }

DataGridView durchsuchen

//In allen Zeilen in einer Spalte nach Vergleich suchen for(int i = 0; i < DGV.RowCount; i++) { if(ReadDGV(DGV, i, SPALTE) == "TEXT") { } }
//Jede Zelle Suchen/Ersetzen for (int spalte = 0; spalte < DGV.ColumnCount; spalte++) { for (int i = 0; i < DGV.RowCount; i++) { } }