Daten können folgendermassen in die Datenbank geschrieben werden:
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 MySql.Data.MySqlClient; namespace First_C_Sharp_App { public partial class Form2 : Form { public Form2() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { string myConnection = "datasource=localhost;port=3306; " + "username=root;password=xyz"; string Query = "insert into database.edata (Eid, name, surname, age) values('" + this.Eid_txt.Text + "','" + this.Name_txt.Text + "','" + this.Surname_txt.Text + "','" + this.Age_txt.Text + "');"; MySqlConnection conDataBase = new MySqlConnection(myConnection); MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase); MySqlDataReader myReader; try { conDataBase.Open(); myReader = cmdDataBase.ExecuteReader(); MessageBox.Show("Saved"); conDataBase.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }
Keine Kommentare:
Kommentar veröffentlichen