hi there i just started .NET (ASP n VB) this semester n i created this webpage which brings back data from the database ... whn i enter the search parameter it gives me this error .. "Cast from string "" to type 'Integer' is not valid."
heres my code ...plz help me out ...

LookUpInventoryByStockNumber.aspx.vb

Private Sub btnSearchInvt_click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearchInvt.Click

        Try
            Dim InventoryInformation As DataSet = Lab1.OrderSystem.LookUpInventoryByStockNumber(txtE mpID2.Text, StockNum.Text)
            If InventoryInformation.Tables("InventoryInformation" ).Rows.Count > 0 Then
                With InventoryInformation.Tables("InventoryInformation" ).Rows(0)
                    StockNum.Text = .Item("StockNumber")
                    InventoryNumber.Text = .Item("InventoryNumber")
                    Description.Text = .Item("Description")
                    Price.Text = .Item("Price")
                    ReOrderLevel.Text = .Item("ReOrderLevel")
                    UnitCost.Text = .Item("UnitCost")
                    OrderUnitSize.Text = .Item("OrderUnitSize")
                    OrderUnitType.Text = .Item("OrderUnitType")
                    Discontinued.Text = .Item("Discontinued")
                    QuantityOnHand.Text = .Item("QuantityOnHand")
                End With
            Else
                lblErrStock.Text = txtEmpID2.Text & " was not found "
            End If
        Catch ex As Exception
            lblErrStock.Text = ex.Message
        End Try
    End Sub

Inventory.vb
Public Class Inventory
    Public Shared Function LookInventoryByStockNumber(ByVal EmployeeID As Integer, ByVal StockNum As Integer) As DataSet
        Dim eVideo As SqlConnection = New SqlConnection(eVideoConnectionString)
        Dim adapter As SqlDataAdapter = New SqlDataAdapter("exec LookUpInventoryByStockNumber @EmployeeID, @StockNum", eVideo)
        adapter.SelectCommand.Parameters.Add("@EmployeeID" , SqlDbType.Int).Value = EmployeeID
        Dim InventoryInformation As DataSet = New DataSet
        adapter.Fill(InventoryInformation, "InventoryInformation")
        Return InventoryInformation
    End Function
End Class

Your problem is exactly as the error describes. Somewhere in your code you are assigning an empty string to an integer. You need to use an If statement to assign the value, assigning 0 if the string is empty.

Try stepping through your code and seeing where the error occurs. If you need more help, post the exact line you're having problems on.

To find the line causing the trouble, you can set the value of an integer between each line of code, then assess its value in the Catch.
If the value in the Catch is 5, the line before it was set to 5 ran, the one after it was set to 5 didn't.