input string was not in a correct format error will occur

Feb 24 2011 3:43 AM
hi,

  i want to insert the record to a table using stored procedure.when i insert ithe record input string was not in a correct format, error will occur,i didn't know why this error will occur.here i specify the datatypes are                            
field name              datatype        (Input given)

companyname----->varchar----->south nest
companymailid----->varchar--->[email protected]
phonenmber-------->bigint---->044569874
mobilenumber------>bigint---->987456321
functionalarea----->varchar---->IT
keyskill----->varchar--->.net,sql
qualify----->varchar---->BE,MCA,M.Sc
experience--->nchar--->fresher,1+
annualincome---->int--->2,00,000
description---->varchar---->having good knowledge in sql
location--->varchar---->chennai
lastdate---->date/time--->by using now function it loaded
posteddate--->date/time---->2/2/2011

likewise the inputs are given but why the input string was not in a correct format error will occur.can anyone help me.

Answers (4)