I gang

[url removed, login to view] webservice to accept JSON data and save to MS SQL

I need a web service, similar to the one posted below to accepts JSON data and saves it to a MS SQL table. It must accept multiple rows and multiple columns.

I cannot give you access to my server. I would like you to deliver a sql data structure and a full .net solution that I can test with, then I will migrate to my environment.

<HttpPost>

Public Function UploadSurveyData_array(<FromBody()> ByVal strInput() As Table) As DataSet

Dim conn As New [url removed, login to view](strConn)

Dim ds As New [url removed, login to view]()

Dim ShowAdapter As New [url removed, login to view]()

Dim cn As New [url removed, login to view](strConn)

Dim myDS As DataSet

Dim da As SqlDataAdapter

Dim cb As SqlCommandBuilder

Dim cmd As SqlCommand

Dim affectedRows As Integer

Dim rdr As StringReader

Dim BatchID As String = ""

Dim xml As String = ""

Dim stringwriter As StringWriter = New StringWriter()

Dim serializer As XmlSerializer = New XmlSerializer([url removed, login to view]())

[url removed, login to view](stringwriter, strInput)

xml = [url removed, login to view]()

xml = Replace(xml, "&", "-")

xml = Replace(xml, "noid", "0")

xml = Replace(xml, "<dteSurveyDate>0001-01-01</dteSurveyDate>", "<dteSurveyDate>2001-01-01</dteSurveyDate>")

Try

rdr = New StringReader(xml)

'source stuff

myDS = New [url removed, login to view]()

[url removed, login to view](rdr)

[url removed, login to view]()

da = New [url removed, login to view]("SELECT lngUniqueSurveyID, lngShowID, lngSpecialistID, dteSurveyDate, strFName, strLName, strAddress, " & _

"strZip, strPhone, strEMail, strMarketTime, strVehiclesOfInterest, strPurchaseLease, strUseEMail, lngPDASurveyID, strDeviceID, strCurrentMake, strLDNRequested, strDebug, PreferredDealerCode, intBlackLabel, blnIgnoreLead FROM tblQuestionAnswer", cn)

cb = New [url removed, login to view](da)

[url removed, login to view] = "["

[url removed, login to view] = "]"

[url removed, login to view] = [url removed, login to view]()

Dim p As [url removed, login to view]

Dim row As [url removed, login to view]

For Each row In [url removed, login to view](0).Rows

For Each p In [url removed, login to view]

[url removed, login to view] = [url removed, login to view]([url removed, login to view])

Next

affectedRows += [url removed, login to view]

Next

[url removed, login to view] = New [url removed, login to view]("SELECT '" & affectedRows & "'", conn)

[url removed, login to view](ds, "tblResults")

Catch ex As Exception

WriteLog("Error :" & [url removed, login to view] & " " & [url removed, login to view])

ds = Nothing '[url removed, login to view] & vbCrLf & [url removed, login to view]

Finally

[url removed, login to view]()

da = Nothing

cb = Nothing

cmd = Nothing

WriteLog("done")

End Try

Return ds

End Function

Færdigheder: IIS, JSON, VB.NET

Se mere: asp net webservice calling, asp sql data, postgres sql data net, sql net webservice, sql data sync webservice

Om arbejdsgiveren:
( 49 bedømmelser ) Walled Lake, United States

Projekt-ID: #12527058

Tildelt til:

kalpesh2804

Hello, I have 12+ years of experience in C#, Vb.Net, MSSQL, MySQL, SQLite, Visual FoxPro 9. I can provide web service. thanks Kalpesh

$100 USD in 2 dage
(3 bedømmelser)
3.6

5 freelancere byder i gennemsnit $141 for dette job

$95 USD in 3 dage
(3 bedømmelser)
1.6
marketiplace

We have 8+years work experience in .NET,FLASH,C#,Linux,Visual Studio2010,Joomla,ASP,Javascript,Java,PHP,Python,Prestashop, MS access,SQL,Shell script,XML,moodle,AJAX,CMS,HTML,Drupal,SEO,CSS,wordpress,Bootstrap,Photos Mere

$77 USD in 2 dage
(1 bedømmelse)
2.3
furqaanwar

Hello Sir I am an expert dotnet developer with an experience of over 6 years and graduate in computer science major.i have worked in many framework of dotnet as well. With development i myself do the designing and Mere

$333 USD in 3 dage
(0 bedømmelser)
0.0
mstechIN

Have experience building webservices for backup solutions and other data backup services. Let me know if you have any specific questions.

$100 USD in 2 dage
(0 bedømmelser)
0.0