I gang

vb.net 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: read flat file ms sql data base net, google marker click load sql data asp net, generate html pages sql data asp net, asp net webservice calling vb, asp ms sql data, save bangla sql server net, postgres sql data net, sql net webservice, load data json sql vbnet javascript, webservice aspnet sql data syncronization, sql data sync webservice, save image sql server 2005 net, save image sql server data sql 2005, save arabic sql server 2005 using net

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