Reply to thread

Message

<blockquote data-quote="Skythrust" data-source="post: 456461" data-attributes="member: 87030">Thanks griimnak, but the code is messy because I need to get some data out of SQLSRV <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" />[automerge]1581195764[/automerge]Okay Imma bit further.. I can move on now without any errors.But my messagebox will be empty when I ask a record up..[CODE=csharp]&nbsp; &nbsp; &nbsp; &nbsp; public ObjectTypeList data { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public class ObjectTypeList&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [JsonProperty(PropertyName = &quot;info&quot;)]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; public Dictionary&lt;string, Object&gt; info { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public class Object&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [JsonProperty(PropertyName = &quot;Firstname&quot;)]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; public string Firstname { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [JsonProperty(PropertyName = &quot;Middlename&quot;)]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; public string Middlename { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [JsonProperty(PropertyName = &quot;Lastname&quot;)]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; public string Lastname { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [JsonProperty(PropertyName = &quot;Badge&quot;)]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; public int CredentialNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [JsonProperty(PropertyName = &quot;CustomerId&quot;)]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; public string CustomerId { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; using (var webClient = new WebClient())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string json = webClient.DownloadString(&quot;http://localhost/intergrator/test.php?uid=U569418&amp;pwd=P497965&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Object Personal = JsonConvert.DeserializeObject&lt;Object&gt;(json);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(&quot;JSON result: &quot; + Personal.Firstname);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }[/CODE][automerge]1581256740[/automerge]Solved.[CODE=csharp]public class Object&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public string Firstname { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string Middlename { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string Lastname { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CredentialNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CustomerId { get; set; }&nbsp; &nbsp; }void JSONtest()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; using (var webClient = new WebClient())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string json = webClient.DownloadString(&quot;URL&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; // Do something &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // example MessageBox.Show(ev.Firstname);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }[/CODE][automerge]1589794677[/automerge]I would like to use this code in a service, but I am not able to do that[CODE]&nbsp;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.</blockquote>

[QUOTE="Skythrust, post: 456461, member: 87030"] Thanks griimnak, but the code is messy because I need to get some data out of SQLSRV :-) [automerge]1581195764[/automerge] Okay Imma bit further.. I can move on now without any errors. But my messagebox will be empty when I ask a record up.. [CODE=csharp] public ObjectTypeList data { get; set; } public class ObjectTypeList { [JsonProperty(PropertyName = "info")] public Dictionary<string, Object> info { get; set; } } public class Object { [JsonProperty(PropertyName = "Firstname")] public string Firstname { get; set; } [JsonProperty(PropertyName = "Middlename")] public string Middlename { get; set; } [JsonProperty(PropertyName = "Lastname")] public string Lastname { get; set; } [JsonProperty(PropertyName = "Badge")] public int CredentialNumber { get; set; } [JsonProperty(PropertyName = "CustomerId")] public string CustomerId { get; set; } } using (var webClient = new WebClient()) { string json = webClient.DownloadString("http://localhost/intergrator/test.php?uid=U569418&pwd=P497965"); Object Personal = JsonConvert.DeserializeObject<Object>(json); MessageBox.Show("JSON result: " + Personal.Firstname); }[/CODE] [automerge]1581256740[/automerge] Solved. [CODE=csharp] public class Object { public string Firstname { get; set; } public string Middlename { get; set; } public string Lastname { get; set; } public string CredentialNumber { get; set; } public string CustomerId { get; set; } } void JSONtest() { using (var webClient = new WebClient()) { string json = webClient.DownloadString("URL"); var Personal = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Object>>(json); foreach (var pv in Personal) { // Do something // example MessageBox.Show(ev.Firstname); } } } [/CODE] [automerge]1589794677[/automerge] 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. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members