예제 #1
0
        private void pictureBox1_Click(object sender, EventArgs e)
        {
            FrmAnaMenu form = new FrmAnaMenu();

            form.Show();
            this.Hide();
        }
예제 #2
0
        // SqlConnection bgl = new SqlConnection(@"Data Source=LAPTOP-RRVHUN4A\SQLEXPRESS;Initial Catalog=yeniyurtvertiabani;Integrated Security=True");



        private void btnGiris_Click_1(object sender, EventArgs e)
        {
            try
            {
                string       sql        = "Select * From GirisSistemi where kullanici_adi=@girisAdi AND sifre=@girisSifresi";
                SqlParameter parametre1 = new SqlParameter("girisAdi", txtKullaniciAdi.Text.Trim()); //boşluk karakteri önlendi.
                SqlParameter parametre2 = new SqlParameter("girisSifresi", txtSifre.Text.Trim());
                SqlCommand   komut      = new SqlCommand(sql, bgl.Open());
                komut.Parameters.Add(parametre1);
                komut.Parameters.Add(parametre2);
                DataTable      dt = new DataTable();
                SqlDataAdapter da = new SqlDataAdapter(komut);
                da.Fill(dt);


                if (dt.Rows.Count > 0) //e
                {
                    FrmAnaMenu form = new FrmAnaMenu();
                    form.Show();
                    this.Hide();
                }
            }
            catch (Exception)
            {
                MessageBox.Show("Hatalı giriş yaptınız.");
            }
        }