Help with ..FAILED TO CONVERT PARAMERTR VALUE FROM STRING TO INT32

• teddy.sfsu

  SSC Enthusiast

  Points: 174

  More actions

  March 24, 2010 at 10:32 am

  #220313

  I have a table with different columns ( CourseCode int, title nvarchar,creditHour int...) courseCode as aprimary key.

  I am using ASP.NET , C# and MS SQL .

  my problem is , when I send empty text box to CreditHour, it generates an error wchih says FAILED TO CONVERT PARAMERTR VALUE FROM STRING TO INT32. But when I give vale for the text box it works fine.

  I tried a lot but not sucessful. please help me..........

• Ben Teraberry

  SSChampion

  Points: 11845

  More actions

  March 24, 2010 at 1:03 pm

  #1139188

  Don't pass "" to a parameter of sqlDbType.int ... instead convert it to System.DBNull.Value and you'll be fine.

  I don't remember my C# enough to know what happens if you try to convert "" to an int type so you may try that and see if it works.

  └> bt
  

  ---

  
  Forum Etiquette: How to post data/code on a forum to get the best help[/url]