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
i want to insert multiple rows, this json object contains lists of data, it cannot enter rows into the sql server database, can i use loop or what to enter it one by one in the database?
Go to the complete details ...