예제 #1
0
파일: Signin.cs 프로젝트: chanwooro/aimhigh
        private void button1_Click(object sender, EventArgs e)
        {
            MainStaff mainstaff = new MainStaff();

            OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\한국말\subjectData.accdb;Persist Security Info=False;");
            con.Open();
            OleDbDataAdapter sda = new OleDbDataAdapter("Select Count(*) From UserIds where USERID='" + textBox1.Text + "' and PASSWORD='******'", con);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            con.Close();
            Console.WriteLine("한국말");
            //if(dt.Rows[0][0].ToString() == "1")
            if (dt.Rows[0][0].ToString() == "1")
            {
                string username = textBox1.Text;

                Console.WriteLine("testing :" + dbHandler.loginProperty(username));
                if (dbHandler.loginProperty(username) != "1")
                {
                    Student student = new Student();
                    student.username.Text = "Welcome to AimHigh QnA";
                    student.Show();
                }
                else
                {
                    MainStaff staffMain = new MainStaff();
                    staffMain.username.Text = "Welcome " + username;
                    staffMain.Show();

                }
                this.Hide();
            }
            else
            {
                errormessage.Visible = true;

            }
        }
예제 #2
0
파일: Signin.cs 프로젝트: chanwooro/aimhigh
        private void button1_Click(object sender, EventArgs e)
        {
            MainStaff mainstaff = new MainStaff();

            OdbcConnection con = new OdbcConnection("Dsn=QNA");
            con.Open();
            OdbcDataAdapter sda = new OdbcDataAdapter("Select Count(*) From UserIds where USERID='" + textBox1.Text + "' and PASSWORD='******'", con);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            con.Close();

            //if(dt.Rows[0][0].ToString() == "1")
            if (dt.Rows[0][0].ToString() == "1")
            {
                string username = textBox1.Text;

                Console.WriteLine("testing :" + dbHandler.loginProperty(username));
                if (dbHandler.loginProperty(username) != "1")
                {
                    Student student = new Student();
                    student.username.Text = "Welcome to AimHigh QnA";
                    student.Show();
                }
                else
                {
                    MainStaff staffMain = new MainStaff();
                    staffMain.username.Text = "Welcome " + username;
                    staffMain.Show();

                }
                this.Hide();
            }
            else
            {
                errormessage.Visible = true;

            }
        }