Login em C#

Landi20 · 15 de fevereiro de 2010

como eu faço a login em c# com ligação a base de dados

segue-se o codigo

não estou a conseguir ligar a base de dados

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;




namespace WindowsFormsApplication3
{
    public partial class Form2 : Form
    {
        private MySqlConnection connection;
        private string server;
        private string database;
        private string uid;
        private string password;

        public Form2()
        {
            InitializeComponent();
        }

        private void panel1_Paint(object sender, PaintEventArgs e)
        {
            Graphics g = e.Graphics;
            g.DrawString("LOGIN", new Font("Times New Roman", 30), Brushes.Blue, 25, 20);
        }

        private void panel2_Paint(object sender, PaintEventArgs e)
        {
            Graphics g = e.Graphics;
            g.DrawString("USERNAME", new Font("Times New Roman", 10), Brushes.Blue, 20, 10);
        }

        private void panel3_Paint(object sender, PaintEventArgs e)
        {
            Graphics g = e.Graphics;
            g.DrawString("PASSWORD", new Font("Times New Roman", 10), Brushes.Blue, 20, 10);
        }

        private void button2_Click(object sender, EventArgs e)
        {
            Form1 frm = new Form1();
            frm.Show();
            Hide();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string NomeUsuario="";
            string senha="";
            int nivel = 0;
            server = "localhost";
            database = "gest";
            uid = "root";
            password = "";
            string connectionString;
            connectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";

            connection = new MySqlConnection(connectionString);
            MySqlCommand command = connection.CreateCommand();

            connection.Open();

            command.CommandText = "SELECT COUNT(*) FROM user where (Usename=" +
                "'" + NomeUsuario + "' and password='" + senha + "'and nivel=" +"'"+nivel+"')";


            command.Parameters.Add("NomeUsuario", MySqlDbType.VarChar).Value = textBox1.Text;

            command.Parameters.Add("senha", MySqlDbType.VarChar).Value = textBox2.Text;





            // Se i for maior que zero ‚ porque achou o usuario/senha, senao nÆo acho

            if (this.textBox1.Text == NomeUsuario && this.textBox2.Text==senha/* && nivel==0*/)
            {

                Form3 frm = new Form3();

                frm.Show();

                Hide();

            }
         /*   if (this.textBox1.Text == NomeUsuario && this.textBox2.Text == senha /*&& nivel == 1)
            {
                Form4 frm = new Form4();

                frm.Show();

                Hide();
            }*/
            else

                MessageBox.Show("Usuario ou Senha incorretos");




        }


        private void aBOUTGESTSTOCKSToolStripMenuItem_Click(object sender, EventArgs e)
        {
            AboutBox1 frm = new AboutBox1();
            frm.Show();
            Hide();
        }

        private void hELPToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Form3 frm = new Form3();
            frm.Show();
            Hide();

        }

        private void sAIRToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }

        private void gRAVARToolStripMenuItem_Click(object sender, EventArgs e)
        {

        }
        }
    }