Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using MySql.Data.MySqlClient;
- 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 sql_test
- {
- public partial class Form1 : Form
- {
- public Form1()
- {
- InitializeComponent();
- }
- private void label5_Click(object sender, EventArgs e)
- {
- reg.Location = new Point(-1, -2);
- }
- private void button3_Click(object sender, EventArgs e)
- {
- reg.Location = new Point(249, 241);
- }
- private void label5_MouseMove(object sender, MouseEventArgs e)
- {
- label5.ForeColor = Color.Black;
- }
- private void label5_MouseLeave(object sender, EventArgs e)
- {
- label5.ForeColor = Color.Blue;
- }
- private void auth_Click(object sender, EventArgs e)
- {
- String loginUser = login.Text;
- String passUser = password.Text;
- DB db = new DB();
- DataTable table = new DataTable();
- MySqlDataAdapter adapter = new MySqlDataAdapter();
- MySqlCommand command = new MySqlCommand("SELECT name, surname FROM `users` WHERE `login` = @uL AND `pass` = @uP", db.getConnection()); //Сделали запрос к базе данных
- command.Parameters.Add("@uL", MySqlDbType.VarChar).Value = loginUser;
- command.Parameters.Add("@uP", MySqlDbType.VarChar).Value = passUser;
- adapter.SelectCommand = command;
- adapter.Fill(table);
- if (table.Rows.Count > 0)
- {
- MessageBox.Show("Аккаунт надйен но разраб пока не реализовал профиль:(");
- }
- else
- MessageBox.Show("Ошибка профиль не найден :(");
- }
- private void button2_Click(object sender, EventArgs e)
- {
- String nameUser = name.Text;
- String surnameUser = surname.Text;
- String dateUser = date.Text;
- String loginUser = loginreg.Text;
- String passUser = passreg.Text;
- DB db = new DB();
- MySqlCommand command = new MySqlCommand("INSERT INTO Users (name, surname, date, login, pass) VALUES (@n, @s, @d, @l, @p)", db.getConnection());
- command.Parameters.Add("@n", MySqlDbType.VarChar).Value = nameUser;
- command.Parameters.Add("@s", MySqlDbType.VarChar).Value = surnameUser;
- command.Parameters.Add("@d", MySqlDbType.VarChar).Value = dateUser;
- command.Parameters.Add("@l", MySqlDbType.VarChar).Value = loginUser;
- command.Parameters.Add("@p", MySqlDbType.VarChar).Value = passUser;
- db.openConnection();
- if (command.ExecuteNonQuery() == 1)
- {
- MessageBox.Show("Профиль успешно создан!");
- }
- else
- MessageBox.Show("Хмм... Возникли какие то ошибки, попробуй ещё раз!");
- db.closeConnection();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement