How to Pass a Name Variable After Login To Second Form

Question

I'm creating a program that involves a user logging in on Form1 in order to access Form2. When at Form2, a Label at the top needs to display the user's first name and job position. So, I'll have to pass the name and position variables from Form1 to Form2 in order to display it. Unfortunately, when I try to do this, it won't display.

Currently, the program is set to check the database for the entered login credentials, while an OleDBDataReader finds the name and position associated with those credentials. I've tried declaring a public static string in order to pass the variable along to Form2, but it only returns a null value.

On Form 1, above the Button_Click method:

    private string _name;
    public string name
        {
            get
            { return _name; }
            set
            { _name = value; }
        }

     private string _position;
     public string position
        {
            get
            { return _position; }
            set
            { _position = value; }
        }

On Form1 beneath Button_Click method:

try
        {

            if (textBox1.Text == string.Empty || textBox2.Text == string.Empty)
            {
                MessageBox.Show("Invalid! Please enter a valid Username and/or Password.");
            }

            cmd = new OleDbCommand("SELECT * FROM Staff Where Username='" + textBox1.Text + "' AND Password='" + textBox2.Text + "'", sql);
            if (sql.State == ConnectionState.Closed)
            {
                sql.Open();
                i = (int)cmd.ExecuteScalar();
            }

            using (OleDbDataReader read = cmd.ExecuteReader())
            {
                while (read.Read())
                {
                    _name = (read["FirstName"].ToString());
                    _position = (read["Position"].ToString());
                }
            }
            sql.Close();

            if (i > 0)
            {
                MainHub enter = new MainHub();
                this.Hide();
                enter.Show();
            }
            else
            {
                MessageBox.Show("Invalid! Please enter the correct username or password.");
            }
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.ToString());
        }
    }

Finally, On Form2:

Form1 f=new Form1();
string name = f.name;
string position = f.position;
Label2.Text = "Welcome! Now logged in as User " + name +" ("+ position + ").";

I'd like Label2 to read "Welcome! Now logged in as [insert name] ([insert position])." Instead it just leaves those name and position slots empty.

Possible duplicate of [Send values from one form to another form](https://stackoverflow.com/questions/1559770/send-values-from-one-form-to-another-form) — dcg, Mar 29 '19 at 00:25
It isn’t related to your question, but you should never build a SQL like that. You’re opening yourself up to a SQL injection attack. — Sean, Mar 29 '19 at 01:28
Thank you, Sean. You're absolutely right. Don't know how I missed that. — stevereno, Mar 29 '19 at 01:46

score 0 · Answer 1 · answered Mar 29 '19 at 02:03

0

You can create a class and use static variables for e.g : Create a class that name is 'G' and write a variable on it :

public static string name = '';

then you can access it from your app when you want!

G.name = "Your Name";

answered Mar 29 '19 at 02:03

miss nefrat

93
1
1
9

How to Pass a Name Variable After Login To Second Form

1 Answers1