Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# SQL
Hey,
 
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;
            try
            {
                //not sure what to put here
            }
            catch (Exception ex)
            {
                switch (ex.Message)
                {
                    case "1":
                        MessageBox.Show("You have 2 attempts left");
                        break;
                    case "2":
                        MessageBox.Show("You have 1 attempts left");
                        break;
                    case "3":
                        MessageBox.Show("Your id is not blocked");
                        break;
                }
            
 
 
hope someone can help Smile | :)
Posted 21-Feb-12 2:12am

1 solution

Rate this: bad
good
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
}
else
{
  // Display error
}
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 646
1 OriginalGriff 385
2 CPallini 240
3 PIEBALDconsult 150
4 Magic Wonder 131
0 OriginalGriff 5,795
1 Sergey Alexandrovich Kryukov 5,158
2 CPallini 4,740
3 George Jonsson 3,167
4 Gihan Liyanage 2,450


Advertise | Privacy | Mobile
Web03 | 2.8.140916.1 | Last Updated 21 Feb 2012
Copyright © CodeProject, 1999-2014
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