Email Address Text String Problem

Hi,

I am having a problem storing an Email Address in an SQL database using .net (ASP). I think the problem is in .net.

I run a storred procedure by passing parameters.
Some code:

SqlCommand1.Parameters("@Email").Value = Str(htxtEmail.Value)
SqlCommand1.Parameters("@UserID").Value = CStr(txtUserID.Value)
SqlCommand1.Parameters("@Password").Value = Password1.Value
SqlCommand1.Parameters("@FName").Value = FName.Value
SqlCommand1.Parameters("@LName").Value = LName.Value
SqlCommand1.Parameters("@Zip").Value = Zip.Value SqlCommand1.Parameters("@CountryCode").Value = RTrim(ddlCountry.SelectedItem.Value)

SqlCommand1.ExecuteScalar()

If I enter an Email Address such as [email protected] I get this error: "Input string was not in a correct format." I think .net is interpetting a small Email address as a number somehow.

I have tried many dtring conversions and changes to Parameter collections but no help.

The Stack Trace is attached in case somebody knows how to interpet it.

Anybody have any ideas????

Try htxtEmail.Text instead of htxtEmail.Value

Thanks for the reply.

I am currently using a html input box (run at server) which has only the "value" property. I have also tried the asp textbox with the "text" property but got the same result as before.

Any other ideas out there???

What datatype are you declaring your parameters as?

Post your code where you are creating your parameters
For example:

Code:

---

        Dim cmd As SqlClient.SqlCommand
        With cmd.Parameters
            .Add("@Param1", DbType.String)
        End With

---

Hi,

I am using the Colletion Property in SqlCommand for setting parameter types. My settings are:

@Email Properties:
Direction = Input
Precision = 0
Scale = 0
Size = 75
Source Column = "blank"
Source Version = Current
SqlDbType = Char
Value = "blank"

I have also tried SqlDbType = VarChar and = Text