Reply to thread

Message

<blockquote data-quote="Skythrust" data-source="post: 456349" data-attributes="member: 87030">Goodmorning people,I have a web page with some PHP data (JSON) and I would like to read this string in C#.PHP string; [{&quot;Firstname&quot;:&quot;Janet&quot;,&quot;Middlename&quot;:&quot;van&quot;,&quot;Lastname&quot;:&quot;Hope&quot;,&quot;Key&quot;:&quot;12018&quot;,&quot;Cid&quot;:5}] This string will change when there is a new record for Cid:5 (SELECT TOP 1 * FROM Users WHERE Cid = 5 ORDER BY CreatedOn)Now I am trying to make a Windows Service which is reading this array, I was thinking to do it like this with a read commandstring Firstname = &quot;&quot;;string Middlename = &quot;&quot;;string Lastname = &quot;&quot;;string Key = &quot;&quot;;string Cid = &quot;&quot;;using(WebClient client = new WebClient()) {string s = client.DownloadString(url);}But I have no idea how I can call the right parameters (Firstname,Middlename,Lastname,Key,Cid)The next step in this call is to insert them in a sqlsrv_connect, but I have no idea how to do that.Extra Info; I have 2 seperate servers, in a datacenter (1 applicationserver with IIS &amp; SQL with the PHP string, and another one with an other application.) port 1433 (SQL) is closed and cannot be opened for security reason.There is no LAN connection between those and the future will be is that anyone can install the application (service) to connect application A with application B without portforwarding and just reading the PHP string. Over here they are talking that I need to call it a SOAP intergration.But I am not familliar with this. So I need to call the PHP string from server A in a service to push it in a insert via a Windows service for server B. I can insert the PHP code but this seems okay I guess.If there is more information needed let me know.I would like to use this code in a service, but I am not able to do that[CODE]using (var webClient = new WebClient())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string json = webClient.DownloadString(new Uri(&quot;http://localhost/test.php&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var Personal = Newtonsoft.Json.JsonConvert.DeserializeObject&lt;List&lt;Object&gt;&gt;(json);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach (var pv in Personal)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string Badge = pv.CredentialNumber;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string Firstname = pv.Firstname;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string Middlename = pv.Middlename;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string Lastname = pv.Lastname;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlConnection sc = new SqlConnection(GetConnectionStringTemp());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sc.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string query = string.Format(&quot;INSERT INTO Visitors (Badge,Firstname,Middlename,Lastname) VALUES ('{0}','{1}','{2}','{3}')&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; , Badge&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; //0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; , Firstname&nbsp; &nbsp; &nbsp; //1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; , Middlename&nbsp; &nbsp; //2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; , Lastname&nbsp; &nbsp; &nbsp; //3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; );&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (SqlCommand command = new SqlCommand(query, sc))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int countrecords = command.ExecuteNonQuery();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sc.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }[/CODE]when I paste this code in a Winform I am able to recieve the information, and I am able to insert it into a SQLSRV.[SPOILER= Already Solved]I have done some more research and I got this now;[CODE=csharp]void JSONtest()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Uri requestUri = new Uri(&quot;http://localhost/test.php&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; HttpWebRequest request = (HttpWebRequest)WebRequest.Create(requestUri);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; request.Method = &quot;GET&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; request.BeginGetResponse(new AsyncCallback(ProcessResponse), request);&nbsp; &nbsp; &nbsp; &nbsp; }private void ProcessResponse(IAsyncResult asynchronousResult)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string ExportFromPHP = string.Empty;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; HttpWebRequest request = (HttpWebRequest)asynchronousResult.AsyncState;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (HttpWebResponse response = (HttpWebResponse)request.EndGetResponse(asynchronousResult))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Stream responseStream = response.GetResponseStream();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (var reader = new StreamReader(responseStream))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ExportFromPHP = reader.ReadToEnd();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; responseStream.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Do something?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(ExportFromPHP);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp;&nbsp; [/CODE][/SPOILER]</blockquote>

[QUOTE="Skythrust, post: 456349, member: 87030"] Goodmorning people, I have a web page with some PHP data (JSON) and I would like to read this string in C#. PHP string; [B][{"Firstname":"Janet","Middlename":"van","Lastname":"Hope","Key":"12018","Cid":5}] [/B] This string will change when there is a new record for Cid:5 (SELECT TOP 1 * FROM Users WHERE Cid = 5 ORDER BY CreatedOn) Now I am trying to make a Windows Service which is reading this array, I was thinking to do it like this with a read command string Firstname = ""; string Middlename = ""; string Lastname = ""; string Key = ""; string Cid = ""; using(WebClient client = new WebClient()) { string s = client.DownloadString(url); } But I have no idea how I can call the right parameters (Firstname,Middlename,Lastname,Key,Cid) The next step in this call is to insert them in a sqlsrv_connect, but I have no idea how to do that. Extra Info; I have 2 seperate servers, in a datacenter (1 applicationserver with IIS & SQL with the PHP string, and another one with an other application.) port 1433 (SQL) is closed and cannot be opened for security reason. There is no LAN connection between those and the future will be is that anyone can install the application (service) to connect application A with application B without portforwarding and just reading the PHP string. Over here they are talking that I need to call it a SOAP intergration. But I am not familliar with this. So I need to call the PHP string from server A in a service to push it in a insert via a Windows service for server B. I can insert the PHP code but this seems okay I guess. If there is more information needed let me know. I would like to use this code in a service, but I am not able to do that [CODE] using (var webClient = new WebClient()) { string json = webClient.DownloadString(new Uri("http://localhost/test.php")); var Personal = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Object>>(json); foreach (var pv in Personal) { string Badge = pv.CredentialNumber; string Firstname = pv.Firstname; string Middlename = pv.Middlename; string Lastname = pv.Lastname; SqlConnection sc = new SqlConnection(GetConnectionStringTemp()); { sc.Open(); string query = string.Format("INSERT INTO Visitors (Badge,Firstname,Middlename,Lastname) VALUES ('{0}','{1}','{2}','{3}')" , Badge //0 , Firstname //1 , Middlename //2 , Lastname //3 ); using (SqlCommand command = new SqlCommand(query, sc)) { int countrecords = command.ExecuteNonQuery(); } sc.Close(); } } } [/CODE] when I paste this code in a Winform I am able to recieve the information, and I am able to insert it into a SQLSRV. [SPOILER= Already Solved] I have done some more research and I got this now; [CODE=csharp] void JSONtest() { Uri requestUri = new Uri("http://localhost/test.php"); HttpWebRequest request = (HttpWebRequest)WebRequest.Create(requestUri); request.Method = "GET"; request.BeginGetResponse(new AsyncCallback(ProcessResponse), request); } private void ProcessResponse(IAsyncResult asynchronousResult) { string ExportFromPHP = string.Empty; { HttpWebRequest request = (HttpWebRequest)asynchronousResult.AsyncState; using (HttpWebResponse response = (HttpWebResponse)request.EndGetResponse(asynchronousResult)) { Stream responseStream = response.GetResponseStream(); using (var reader = new StreamReader(responseStream)) { ExportFromPHP = reader.ReadToEnd(); } responseStream.Close(); } // Do something? MessageBox.Show(ExportFromPHP); } } [/CODE] [/SPOILER] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members