I was trying to find a left function in C# that is comparable to the LEFT FUNCTION in vbscript and found substring because I want to ensure that the string in only 100 characters in length before going into the database. Any help or direction would be appreciated. I have my code below as well as the error I am getting. Thank you.

This is the way I am using it when trying to pass in a parameter value via ADO from my web page:

// @FullName (input)
dbCommand.Parameters.Add("@FullName", SqlDbType.VarChar, 100);
dbCommand.Parameters["@FullName"].Direction = ParameterDirection.Input;
dbCommand.Parameters["@FullName"].Value = Server.HtmlEncode((this.fullNameTextBox.Text.Subst ring(1, 100)).Replace("'", ""));

Here is the error I am getting:

Exception Details: System.ArgumentOutOfRangeException: Index and length must refer to a location within the string. Parameter name: length

Not sure why you are getting that error. But maybe you need to test for the length first. If it's >100 use the SubString overload that takes start and length, otherwise, just use the overload that takes the start alone.

Also, unless you have another reason for replacing the ' in your string, you don't need to replace them when you are using a command parameter. The parameter object will take care of escaping the characters that need it.

-Peter

I was just about to say that I found what my problem is. I was not checking for length > 100. Pretty stupid, sorry for interuption.

Planoie, thanks for your time and reply. It is appreciated.