Pull SQL value then run If/Else statement

Question

I want to take the value of agronomy either yes/no... if yes it opens another form if no it pops up a message box... just can't seem to wrap my head around how to pull that stored value from the SQL command. Any help would be great I am sure it is something super simple...

SqlConnection cn = new SqlConnection(@"Data Source=*****;Initial Catalog=agSale;Integrated Security=True");
        SqlCommand cmd = new SqlCommand("SELECT agronomy from logins where userName = @userName", cn);
        cmd.Parameters.AddWithValue("userName", nameLabel.Text);
        cn.Open();
        SqlDataReader reader = cmd.ExecuteReader();


        if (agronomy == "yes") 
             new agronomy().Show();
        else
            MessageBox.Show("You can't access this part of the program.  For questions call 867-5309.");


        cn.Close();

ExecuteScalar instead of ExecuteReader

Zein Makki
– Zein Makki

2017-06-22 14:22:32 +00:00
Commented Jun 22, 2017 at 14:22 — Zein Makki
– Zein Makki, Commented Jun 22, 2017 at 14:22

Romano Zumbé · Accepted Answer · 2017-06-22 14:22:19Z

1

Since you just need a single value use ExecuteScalar:

SqlConnection cn = new SqlConnection(@"Data Source=*****;Initial Catalog=agSale;Integrated Security=True");
        SqlCommand cmd = new SqlCommand("SELECT agronomy from logins where userName = @userName", cn);
        cmd.Parameters.AddWithValue("userName", nameLabel.Text);
        cn.Open();
        string agronomy = cmd.ExecuteScalar()?.ToString();


        if (agronomy == "yes") 
             new agronomy().Show();
        else
            MessageBox.Show("You can't access this part of the program.  For questions call 867-5309.");


        cn.Close();

answered Jun 22, 2017 at 14:22

Romano Zumbé

8,1495 gold badges37 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

ksuProgrammer Over a year ago

I have the user in the database and under agronomy is set to yes... however it pops up the message box.... wonder what it would be missing?

Romano Zumbé Over a year ago

What is the result if you run the SQL Statement in SSMS? Whats the value of agronomy in the if statement?

ksuProgrammer Over a year ago

Just ran it and it comes back as yes for that username

Rory Over a year ago

And if you set a breakpoint on the "if" line then what is the value of agronomy?

ksuProgrammer Over a year ago

(If agronomy.Trim() == "yes") fixed the issue

Collectives™ on Stack Overflow

Pull SQL value then run If/Else statement

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related