Click here to Skip to main content
13,095,218 members (77,742 online)
Rate this:
Please Sign up or sign in to vote.
See more:

i am using visual c# 2010. I have got two boxes one with combo which i have filled with ID from database and then a textbox to type in pin number. what i need to do is if the ID and Pin number is correct to go to next form and if it wrong to bring error message up... i am using the sqlcommand. here my code so far

sqlCommandCheckLogin.Parameters["cardNumber"].Value = cardNo.Text;
sqlCommandCheckLogin.Parameters["PIN"].Value = pinNumber.Text;
                //not sure what to put here
            catch (Exception ex)
                switch (ex.Message)
                    case "1":
                        MessageBox.Show("You have 2 attempts left");
                    case "2":
                        MessageBox.Show("You have 1 attempts left");
                    case "3":
                        MessageBox.Show("Your id is not blocked");

hope someone can help :)
Posted 21-Feb-12 2:12am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Exception handling should not be used for program flow. I would have the stored proc return a scalar value, 1 or 0, based on whether the parameters meet the criteria.

if( (int)cmd.ExecuteScalar() == 1 )
  // Next form
  // Display error

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.170813.1 | Last Updated 21 Feb 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100