Folge dem Video um zu sehen, wie unsere Website als Web-App auf dem Startbildschirm installiert werden kann.
Anmerkung: Diese Funktion ist in einigen Browsern möglicherweise nicht verfügbar.
using System;
using System.Data.SqlClient;
using System.Data;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
IDbConnection dbcon;
dbcon = new MySqlConnection(
"Database=2Manage;Data Source=localhost;User Id=xxx;Password=xxx;"
);
dbcon.Open();
IDbCommand dbcmd = dbcon.CreateCommand();
dbcmd.CommandText = "INSERT INTO `MWST` ( `MWST` ) VALUES ( '16.00' );";
dbcon.Close();
MySqlConnection conn = new MySqlConnection("Database=2Manage;Data Source=localhost;User Id=xxx;Password=xxx;");
MySqlDataAdapter adapter = new MySqlDataAdapter();
adapter.SelectCommand = new MySqlCommand("INSERT INTO `MWST` ( `MWST` ) VALUES ( '16.00' );", conn);
adapter.Fill(dataset);
conn.Close();
MySqlConnection conn = null;
MySqlDataReader reader = null;
conn = new MySqlConnection("Database=dbname;Data Source=localhost;User Id=xxx;Password=xxx;");
conn.Open();
MessageBox.Show("TEST","TEST");
txtboxUser.Text = conn.State.ToString();
MessageBox.Show("TEST","TEST");
MySqlCommand cmd = new MySqlCommand("SELECT MWST FROM mwst WHERE MWSTID = 1;", conn);
//MySqlCommand cmd = new MySqlCommand("select `MWST` from `MWST` where `MWSTID` = `?Id`", conn);
/*
MySqlParameter param = new MySqlParameter();
param.ParameterName = "?Id";
param.Value = "1";
cmd.Parameters.Add(param);
*/
reader = cmd.ExecuteReader();
while (reader.Read())
{
txtboxDBName.Text = reader["MWST"].ToString();
}
if (reader != null)
{
reader.Close();
}
if (conn != null)
{
conn.Close();
}
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.Odbc;
...
...
...
private void Anmelden_Button_Click(object sender, System.EventArgs e)
{
benutzer = Benutzer_TextBox.Text.ToString();
passwort = Passwort_TextBox.Text.ToString();
MySqlConnection connection = new MySqlConnection();
connection.ConnectionString = " DataBase = kontakt; Data Source = localhost; User ID = benutzer; Password = passwort";
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
Fehler_Label.Text = "Verbindung erfolgreich";
connection.Close();
}
}
catch (Exception exception)
{
Fehler_Label.Text = exception.Message;
connection.Close();
}
}
}
}