SQL statement

[gollnick]

What is wrong with this...

' define and get the Customers Master
Dim cmdSQL_C As New SqlCommand("Select Top 1 * from Customers where CustomerID = @CustomerID")
cmdSQL_C.Connection = conSQL
cmdSQL_C.Parameters.Add("@CustomerID", System.Data.SqlDbType.Int)
cmdSQL_C.Parameters("@CustomerID").Value = TextBox3.Text 'has a valid key value
conSQL.Open()
Rdr = cmdSQL_C.ExecuteReader()
Rdr.Read()

At the .ExecuteReader I get the error :

An unhandled exception of type 'System.FormatException' occurred in system.data.dll

Additional information: Input string was not in a correct format


The key to Customers is nchar(5).

When I use this same set of code for a key that numeric .. all is fine... What's up???

gollnick

[Edneeis]

Its probably just a casting problem try changing this line:

cmdSQL_C.Parameters("@CustomerID").Value = Interger.Parse(TextBox3.Text)

[gollnick]

Tried that.. Does not like "Interger" ... If this is a character key value .. should it be a numeric assignment?

[MrGTI]

I think Edneeis just made a typo. Did you try Integer? (without the extra "r")

[Edneeis]

Yeah that was my bad I meant Integer my fingers just got going a lil TOO fast and I threw in an extra r.

[gollnick]

Yupper .. Integer....... still .. with a charactor key?

[Edneeis]

If its not a numeric assignment then you set up the parameter wrong. This line sets the Parameter to an integer type:
cmdSQL_C.Parameters.Add("@CustomerID", System.Data.SqlDbType.Int)

So if it shouldn't be an integer then you'll need to change the parameter declaration to whatever it should really be.

What do you mean by character key? What is the value you are passing in?

[gollnick]

Duh .....

cmdSQL_C.Parameters.Add("@CustomerID", System.Data.SqlDbType.NChar) .... works.....

Thanks to all....

[Edneeis]

Really there is no need for the parameter you can include it right in the SQL statement since they are created at the same time:

Dim sql_str As String=String.Format("Select Top 1 * from Customers where CustomerID = '{0}'",TextBox3.Text)
Dim cmdSQL_C As New SqlCommand(sql_str)
conSQL.Open()

Although if the value is numeric then remove the ' and ' around the {0}.