[RESOLVED] Input String was not in correct format

[FishGuy]

Im getting this error when I try to do an insert on one of my tables does anyone know what the problem could be.

Public Sub AddOrder()
        Try
            objDatabaseClass.SqlAddNewOrder.Parameters("@OrderID").Value = OrderNo
            objDatabaseClass.SqlAddNewOrder.Parameters("@ShipName").Value = ShipName
            objDatabaseClass.SqlAddNewOrder.Parameters("@ShipAddress1").Value = ShipAddress1
            objDatabaseClass.SqlAddNewOrder.Parameters("@ShipAddress2").Value = ShipAddress2
            objDatabaseClass.SqlAddNewOrder.Parameters("@ShipAddress3").Value = ShipAddress3
            objDatabaseClass.SqlAddNewOrder.Parameters("@ShipAddress4").Value = ShipAddress4
            objDatabaseClass.SqlAddNewOrder.Parameters("@ShipAddress5").Value = ShipAddress5
            objDatabaseClass.SqlAddNewOrder.Parameters("@ShipDate").Value = DateShipped
            objDatabaseClass.SqlAddNewOrder.Parameters("@RailSerialNumber").Value = objCarriage.SelectedInstockCarriage
            objDatabaseClass.SqlAddNewOrder.Parameters("@SerialNumber").Value = objRail.SelectedInstockRail
            objDatabaseClass.SqlAddNewOrder.Parameters("@ShippedFrom").Value = objRDC.CurrentLocation
            If objDatabaseClass.SqlAddNewOrder.Connection.State = ConnectionState.Closed Then
                objDatabaseClass.SqlAddNewOrder.Connection.Open()
            End If
            objDatabaseClass.SqlAddNewOrder.ExecuteNonQuery()
            If objDatabaseClass.SqlAddNewOrder.Connection.State = ConnectionState.Open Then
                objDatabaseClass.SqlAddNewOrder.Connection.Close()
            End If
            objCarriage.UpdateStockCarriages()
            objRail.UpdateStockRails()
            objCarriage.GetInStockCarriages()
            objRail.GetInStockRails()

The error occurs on the execute non query line

[jmcilhinney]

I would guess that one of the objects that you assign to a parameter is of the wrong type. You might like to set a breakpoint and check the type each parameter against the type of the object you are assigning to it.

[FishGuy]

Yep thanks in my Insert SP I had a Varchar but the parameter was declared as Int in my vb code.