private void Form1_Load(object sender, EventArgs e) { string connect = "datasource=localhost;port=33068;username=Dnlpq66;password=irhN3e0c1Tzu;database=tabla"; string query = "select * from login where user = '******' AND password = '******'"; MySqlConnection databaseConnection = new MySqlConnection(connect); MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection); commandDatabase.CommandTimeout = 60; MySqlDataReader reader; try { databaseConnection.Open(); reader = commandDatabase.Executereader(); if (reader.Read()) { MessageBox.Show("Bienvenido al Sistema"); } else { MessageBox.Show("Usuario o contraseña incorrecta"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//Insert statement public void Insert() { try { string Query = "insert into mastercode(Etunimi,Sukunimi,Lahiosoite,Postinumero,Postitoimipaikka,Puhelinnumero,Sahkopostiosoite,Salasana) values('" + this.enimiBoxi.Text + "','" + this.snimiBoxi.Text + "','" + this.osoiteBoxi.Text + "','" + this.pnumeroBoxi.Text + "','" + this.ptpBoxi.Text + "','" + this.puhelinBoxi.Text + "','" + this.emailBoxi.Text + "','" + this.salasanaBoxi.Text + "');"; MySqlCommand MyCommand2 = new MySqlCommand(Query); MySqlDataReader MyReader2; connection.Open(); MyReader2 = MyCommand2.Executereader(); MessageBox.Show("Tiedot tallennettu"); while (MyReader2.Read()) { } connection.Close(); } catch (Exeption ex) { MessageBox.Show(ex.Message); } }