error occuring after storing data

Question

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

Santhosh Kumar Jayaraman · Answer

What was the error u get now? after using this code Int32.TryParse( txtnumdays .Text out number2);

Ashok Kumar · Answer

thank you very much Int32.TryParse(txtnumdays.Text out number2); this is working fine thank u

Deepak Verma · Answer

Hi Ashok Restrict user to enter and only enter numbers into that TextBox.

Santhosh Kumar Jayaraman · Answer

dont assign value: just make it as int.TryParse(txtnumdays.Textout number2); remove the number2= . The out parameter will automatically set value.

Ashok Kumar · Answer

when i am use this number2 = int.TryParse(txtnumdays.Textout number2); the error is Cannot implicity convert type 'bool' to 'int'

Ashok Kumar · Answer

thank you but the code which you given is not working fine. i have tried it

Santhosh Kumar Jayaraman · Answer

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

Atul Kumar · Answer

If it is going empty string you can provide the zero value to your calculation. But it really depends on your business logic.

Ashok Kumar · Answer

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

Atul Kumar · Answer

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.