예제 #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            string userid, password;

            userid   = textBox1.Text;
            password = maskedTextBox1.Text;
            var orastr           = "User Id=nubitsoft;Password=101171;Data Source=202.143.125.108/fyldb;";
            OracleConnection con = new OracleConnection(); //OracleConnection("Data Source=.;Initial Catalog=Login;User ID=sa;Password=gs123");

            con.ConnectionString = orastr;
            con.Open();
            // MessageBox.Show(con.ServerVersion);

            OracleCommand cmd = new OracleCommand("Select USERID,USERNAME,USERPASSWORD from  USERS where USERNAME='******' and USERPASSWORD='******'", con);

            DataTable dt = new      DataTable();

            OracleDataAdapter adap = new OracleDataAdapter(cmd);

            adap.Fill(dt);
            OracleDataReader dr = cmd.ExecuteReader();

            dr.Read();


            if (dt.Rows.Count > 0)
            {
                sUserId = textBox1.Text;
                sFYear  = comboBox1.Text;

                MyWinApp.MyGlobals.sFYear    = sFYear;
                MyWinApp.MyGlobals.sUserName = sUserId;


                // this.Hide();
                frmIndex frm = new frmIndex();
                frm.Icon = this.Icon;

                frm.ShowDialog();
                // MessageBox.Show(dt.Rows.Count.ToString());
            }
            else
            {
                textBox1.Text       = "";
                maskedTextBox1.Text = "";

                MessageBox.Show("invalid userid or password");
            }

            con.Close();
        }
예제 #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            string userid, password;

            userid   = textBox1.Text;
            password = maskedTextBox1.Text;
            sFYear   = comboBox1.Text;


            // var orastr = "User Id=rsrir;Password=101171;Data Source=202.143.125.108/fyldb;";
            OracleConnection con = new OracleConnection(); //OracleConnection("Data Source=.;Initial Catalog=Login;User ID=sa;Password=gs123");


            con.ConnectionString = MyWinApp.MyGlobals.sOrastr;
            con.Open();
            // MessageBox.Show(con.ServerVersion);

            //  OracleCommand cmd = new OracleCommand("Select USERID,USERNAME,USERPASSWORD from  USERS where USERNAME='******' and USERPASSWORD='******'", con);

            OracleCommand cmd = new OracleCommand("pr_LoginPass", con);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("VsFYear", OracleDbType.Varchar2).Value     = sFYear;
            cmd.Parameters.Add("VsUserName", OracleDbType.Varchar2).Value  = userid;
            cmd.Parameters.Add("VsUserPass", OracleDbType.Varchar2).Value  = password;
            cmd.Parameters.Add("retval", OracleDbType.RefCursor).Direction = ParameterDirection.Output;



            DataTable dt = new      DataTable();

            OracleDataAdapter adap = new OracleDataAdapter(cmd);

            adap.Fill(dt);
            OracleDataReader dr = cmd.ExecuteReader();

            dr.Read();


            if (dt.Rows.Count > 0)
            {
                sUserId = textBox1.Text;
                sFYear  = comboBox1.Text;

                MyWinApp.MyGlobals.sFYear    = sFYear;
                MyWinApp.MyGlobals.sUserName = sUserId;


                // this.Hide();
                frmIndex frm = new frmIndex();
                frm.Icon = this.Icon;

                frm.ShowDialog();
                // MessageBox.Show(dt.Rows.Count.ToString());
            }
            else
            {
                textBox1.Text       = "";
                maskedTextBox1.Text = "";

                MessageBox.Show("invalid userid or password");
            }

            con.Close();
        }