Esempio n. 1
0
 public Main(myInfo infoFromLogin)
 {
     InitializeComponent();
     userInfo = infoFromLogin;
     //Example of use
     lblMessage.Text = userInfo.loginMessage;
 }
Esempio n. 2
0
        private void BTN_Login_Click(object sender, EventArgs e)
        {
            SqlConnection SRFNconnection = new SqlConnection();

            //WE ARE GONNA USE 3 PROPERTIES OF SQLCONNECTION:
            //myconnection.ConnectionString;
            //myconnection.Open();
            //myconnection.Close();

            //myconnection.ConnectionString =
            //    "Server=myServerAddress;" +
            //    "Database=myDataBase;" +
            //    "User Id=myUsername;" +
            //    "Password = myPassword; ";
            // I looked for it at ConnectionString.com
            SRFNconnection.ConnectionString = ConnectionStringSRFN;

            //THIS ONE WOULD ALSO WORK
            //SqlConnection SRFNconnection = new SqlConnection(ConnectionStringSRFN);
            //OR EVEN THIS ONE:
            //SqlConnection SRFNconnection = new SqlConnection("Server =DatabaseSRFN.mssql.somee.com;Database=DatabaseSRFN;User Id=serafin;Password = 19771977;");

            try
            {
                SRFNconnection.Open();
                //OPEN THE CONNECTION. always close it before going out (just if its open)
                //PERFORM THE COMMAND
                MessageBox.Show("connection should be already OPEN");
                //SqlCommand SRFNcommand = new SqlCommand("SELECT * FROM Login;");
                SqlCommand SRFNcommand = new SqlCommand();
                //COMMAND PROP1
                SRFNcommand.CommandText = String.Format(
                    "SELECT * FROM Login WHERE UserId='{0}' AND Password='******'",
                    TB_User.Text.Trim().Replace("\"", "").Replace(";", ""),
                    TB_Password.Text.Trim().Replace("\"", "").Replace("; ", "")
                    );
                MessageBox.Show("Data inserted...: " + TB_User.Text + "...." + TB_Password.Text);
                //COMMAND PROP2
                SRFNcommand.Connection = SRFNconnection;

                //----------------------------------
                SqlDataReader SRFNdatareader = SRFNcommand.ExecuteReader();
                if (SRFNdatareader.Read())
                {
                    MessageBox.Show("YEAHHHHHHHHHHHHHHHHHHHH.Logged in");
                    myInfo infoFromLogin = new myInfo();
                    infoFromLogin.loginMessage = "Welcome!! you are:" + TB_User.Text;

                    //Pass it on!
                    Main newFrom = new Main(infoFromLogin);
                    newFrom.Show();
                    this.Hide();
                }
                else
                {
                    MessageBox.Show("THERE ARE NO USER LOGINS IN THE DATABASE Logins");
                }
            }
            catch (Exception eex)
            {
                //CATCH ANY ERRORS AND DEBUG
                MessageBox.Show("oHHHHHHHHHHHHHHHHHHHHHHHHHH");
            }
            finally
            {
                if (SRFNconnection.State == ConnectionState.Open)
                {
                    SRFNconnection.Close();
                }
            }
        }