Index and length must refer to a location within the string?

Question

hi frnds  i am running the application so i m getting the error like Index and length must refer to a location within the string. my code is RtrvData(MnpltData.RtrvData_I(select irtn_Id from dbo.itemrtrns where irtn_Suffix =' + _Key.Substring(0 9) + ' and irtn_Fnyr=' + _Key.Substring(10) + '));

Ravi Patel · Answer

Hi  The second parameter is the length of the substring not the end index. try this check the length of string then apply substring() RtrvData(MnpltData.RtrvData_I(select irtn_Id from dbo.itemrtrns where irtn_Suffix =' + _Key.Substring(0 3 ) + ' and irtn_Fnyr=' + _Key.Substring( 3 ) + '));

Ranjit Powar · Answer

Your input string must have 11 or greater characters in it. May be the string is less than 11 characters. Check your input string.