private void Sesion()
{
string connect = "datasource=localhost;port=3306;username=root;password=;database=formulario";
string query = "SELECT * from user where user = '******'AND password='******'";
MySqlConnection databaseConnection = new MySlConnection(connect);
MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection);
commandDatabase.CommandTimeout = 60;
MySqlDataReader reader;
try
{
databaseConnection.Open();
reader = commandDatabase.ExecuteReader();
if (reader.Read())
{
MessageBox.Show("Welcome User");
}
else
{
MessageBox.Show("Error, Incorrect Data");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
string connect = "datasource=localhost;port=3306;username=root;password=;database=formulario";
string query = "INSERT INTO usuario(`ID`, `User`, `Password`) VALUES (NULL, '" + textuser.Text + "', '" + textpassword.Text + "')";
MySqlConnection databaseConnection = new MySlConnection(connect);
MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection);
commandDatabase.CommandTimeout = 60;
MySqlDataReader reader;
try
{
databaseConnection.Open();
MySqlDataReader reader = commandDatabase.ExecuteReader();
MessageBox.Show("Registered User");
databaseConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}