none
How can i insert JSON containting multiple rows into my SQL server database? RRS feed

  • Question

  • Public Function WorkOrderTask(JSON As WorkOrderTask11) 

    Dim strConn = WcfService1.My.Settings.dbconn
    Dim strSql As String = "Insert into dbo.workorder(wot_id,wot_workorder,wot_machinenumber)values('" & JSON .wot_id & "','" & JSON .wot_workorder & "','" & JSON .wot_machinenumber &  "')"

    Using oSql As New Databases.MSSql(strConn)

    Try

    oSql.OpenSqlServerConnection()

    oSql.SelectQuery(strSql)

    Catch ex As Exception
    Throw New System.Exception(ex.Message)
    Finally
    oSql.CloseSqlServerConnection()
    End Try

    End Using

    End Function

    Tuesday, September 22, 2015 12:57 PM

All replies