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