Ejemplo n.º 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection  conn = new SqlConnection("Data Source=DESKTOP-DELL-30;Initial Catalog=testdb;Integrated Security=True");
            SqlDataAdapter sda  = new SqlDataAdapter(@"select * from Stock.dbo.Login where username = '******' and password = '******'", conn);
            DataTable      dt   = new DataTable();

            sda.Fill(dt);

            if (dt.Rows.Count == 1)
            {
                this.Hide();
                StockMain main = new StockMain();
                main.Show();
            }
            else
            {
                MessageBox.Show("Invalid Username/Password..!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                button2_Click(sender, e);
            }
        }
Ejemplo n.º 2
0
        private void button2_Click(object sender, EventArgs e)
        {
            //To-Do: Check Username and password
            SqlConnection  con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\project\stock\stock\Database1.mdf;Integrated Security=True");
            SqlDataAdapter sda = new SqlDataAdapter("select count(*) from Login where username='******' and password='******'", con);
            DataTable      dt  = new DataTable();

            sda.Fill(dt);
            if (dt.Rows[0][0].ToString() == "1")
            {
                this.Hide();
                StockMain main = new StockMain();
                main.Show();
            }
            else
            {
                MessageBox.Show("Please Enter The Correct Username and password", "alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
                button1_Click(sender, e);
            }
        }
Ejemplo n.º 3
0
        }  // Login Button

        private void button2_click(object sender, EventArgs e)
        {
            //TO-DO: Check user name and password
            SqlConnection  con = new SqlConnection("Data Source=ELITE2560P;Initial Catalog=stock;Integrated Security=True");
            SqlDataAdapter sda = new SqlDataAdapter(@"SELECT *
  FROM [dbo].[Login] Where UserName='******' and Password='******'", con);
            DataTable      dt  = new DataTable();

            sda.Fill(dt);
            if (dt.Rows.Count == 1)
            {
                this.Hide();
                StockMain main = new StockMain();
                main.Show();
            }
            else
            {
                MessageBox.Show("Invalid Username and Password...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                button1_click(sender, e);
            }
        }
Ejemplo n.º 4
0
        private void button2_Click(object sender, EventArgs e)
        {
            //To-do check login and password

            String strSql = "Select* from[commondb].[dbo].StaffCode_ct where Stf_Code = '" + textBox1.Text + "' and password = '******'";

            SqlConnection con = Connection.GetConnection();

            SqlDataAdapter sda = new SqlDataAdapter("Select * from [commondb].[dbo].StaffCode_ct as aa  where aa.[STF_CODE] = '" + textBox1.Text + "' ", con);
            DataSet        dt  = new DataSet();

            sda.Fill(dt, "StaffCode");


            if (dt.Tables[0].Rows.Count == 1)
            {
                String dpwd  = dt.Tables[0].Rows[0]["password"].ToString();
                String dpwd2 = dt.Tables["StaffCode"].Rows[0]["password"].ToString();
                String tpwd  = textBox2.Text;

                if (dpwd == tpwd)
                {
                    this.Hide();

                    StockMain main = new StockMain();
                    main.Show();
                }
                else
                {
                    MessageBox.Show("로그인 아이디 또는 패스워드가 틀립니다. ", "에러 메세지 박스", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            else
            {
                MessageBox.Show("로그인 아이디 또는 패스워드가 틀립니다. ", "에러 메세지 박스2", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                button1_Click(sender, e);
            }
        }