error occuring after storing data

Ashok Kumar

Hi friends,

i am getting error after performing calculation and after storing data in database

The error is

formatExeption was unhandled

Input string was not in a correct format

the error is on
number2 = Convert.ToInt32(txtnumdays.Text);

the logic i have used to perform calculation is

string maxleave = "";

            int number1;
            int number2;
            int returnValue = 0;
            qry = "Select MaxLeave from LeaveMaster where LeaveName = '" + cmbLeave.Text.ToString() + "' ";
            number2 = Convert.ToInt32(txtnumdays.Text);

            DBCom.getData(qry);
            if (DBCom.rdr.HasRows)
            {
                while (DBCom.rdr.Read())
                {
                    maxleave = DBCom.rdr["MaxLeave"].ToString();
                    number1 = int.Parse(maxleave);
                    returnValue = Subtract(number1, number2);
                    txtLvslft.Text = returnValue.ToString();

please help how to solve this error

thanks

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Santhosh Kumar Jayaraman14y ago
Accepted answer
What was the error u get now? after using this code
Int32.TryParse(txtnumdays.Text, out number2);
0
Ashok Kumar14y ago
thank you very much

Int32.TryParse(txtnumdays.Text, out number2);
this is working fine

thank u
0
Deepak Verma14y ago
Hi Ashok, Restrict user to enter and only enter numbers into that TextBox.
0
Santhosh Kumar Jayaraman14y ago
dont assign value:
just make it as
int.TryParse(txtnumdays.Text,out number2);

remove the number2= .

The out parameter will automatically set value.
0
Ashok Kumar14y ago
when i am use this
number2 = int.TryParse(txtnumdays.Text,out number2);
the error is
Cannot implicity convert type 'bool' to 'int'
0
Ashok Kumar14y ago
thank you
but the code which you given is not working fine. i have tried it
0
Santhosh Kumar Jayaraman14y ago
int number1;
            int number2;
            int returnValue = 0;
            qry = "Select MaxLeave from LeaveMaster where LeaveName = '" + cmbLeave.Text.ToString() + "' ";
Int32.TryParse(txtnumdays.Text, out number2); //try this
0
Atul Kumar14y ago
If it is going empty string, you can provide the zero value to your calculation. But it really depends on your business logic.
0
Ashok Kumar14y ago
if i not convert the string into integer it will not perform calculation
i have used
string maxleave ="";
and i am converting to integer to calculate
0
Atul Kumar14y ago
You txtnumdays.Text could be going blank something like this "". check it out. Apply condition before conversion that if it is empty string it should not convert it.
0