MichaelWClark 0 Junior Poster

I am trying to just Insert from my script but I keep getting ::

"Conversion from string "INSERT INTO [PURCHASE_ORDER_OFFI" to type 'Double' is not valid."

Here is my insert code... any ideas... this is driving me crazy today!

Protected Sub linkOfficeAddRow_Click(ByVal sender As Object, ByVal e As System.EventArgs)
        ddPurchaseOrderID.DataBind()
        Dim POOEQ As String = CType(CType(PurchaseOrderOfficeEquipmentGridView.FooterRow.FindControl("txtPO_Office_EQ"), TextBox).Text, String)
        Dim POOPR As String = CType(CType(PurchaseOrderOfficeEquipmentGridView.FooterRow.FindControl("txtPO_Office_PR"), TextBox).Text, String)
        Dim POOQU As String = CType(CType(PurchaseOrderOfficeEquipmentGridView.FooterRow.FindControl("txtPO_Office_QU"), TextBox).Text, String)
        Dim POOID As Integer = ddPurchaseOrderID.SelectedValue + 1

        SQLPO_OfficeDataSource.InsertCommand = "INSERT INTO [PURCHASE_ORDER_OFFICE_EQUIPMENT] ( [PURCHASE_ORDER_ID], [PURCHASE_ORDER_OFFICE_EQUIPMENT], [PURCHASE_ORDER_OFFICE_PRICE], [PURCHASE_ORDER_OFFICE_QUANTITY]) VALUES ( '" + POOID + "', '" + POOEQ + "','" + POOPR + "','" + POOQU + "')"
        SQLPO_OfficeDataSource.Insert()
    End Sub
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.