I have an assigment where I must send queries to the database and the returns data. I would like to convert that data to a json and then use it with jQuery
My idea is make an array (żarrayList?) and then convert it to json.
How can i use json with asp.net vb? I'm not allowed to use a webservice yet
UPDATE 2: I did not mention that I do not get the error below in Chromium, but I do get it in IE8.
UPDATE 1:
Response Headers:
HTTP/1.1 200 OK
Date: Fri, 20 May 2011 15:40:23 GMT[code].....
Why does that happen and how can I stop the error message from appearing?
I need to return json data from the server, which can be used on the client side and I am not sure the best way to format the json data.
So basically, What is the best way to format the json data to include:
key/value pairs so they can be looped through at clientside (loop via jquery), a count of the number of id/value pairs which can be used at clientside for other purposes (used via jquery).
I have a WCF service defined as follows:
Imports System.ServiceModel
Imports System.ServiceModel.Web
<ServiceContract()>
[code].....
my problem is that my company does not want to serve up the .json MIME type, so I have to use ASP.NET to fetch the JSON file from the file server. Currently I have jQuery that does a getJSON and traverses the JSON object to build certain elements of the page. Is there a way I can use ASP.NET (VB) to give the object to my jQuery script after I fetch it?
View 1 Replies[URL] Using this I have managed to use Server Side Web Methods to perform actions with AJAX.In most instances, I just need it to do stuff (save things to a database for example) so don't need to do anything with the response, but now I've come across a situation where I do, and I can't work it out!The Web Method returns a JSON object, which looks like this:
{"d":"[{"validDetails":"True","lateAlert":"","LoginResponse":"Logging in Jamie at 16:53 please wait"}]"}
This is the output shown from Firebug. I am not sure what the 's are, but bear with it...The AJAX call and attempt at outputting this response is:
$("form").on("submit", function () {
var LogonObject = new Object;
LogonObject.password = $('#password').val();
[code]....
And several other variations from info I have found on Google and SO, but it seems to treat the results variable as a string, not an array, and the output I get on the alerts is each individual character, ie;
[, {, ", v, a, l, i, d, D... etc
So I wondered if results needed to be converted to JSON again (though I don't know why) so I tried
results = $.parseJSON(data.d)
But that didn't work either.
EDIT, the code which generates the response (missing out tons of logic, but this is the important bit):
Public Class OutputObject
Public validDetails, lateAlert, LoginResponse As String 'content of JSON output'
End Class
[code].....
I am having a heck of a time with some very simple json. I have a very basic VB.NET webform which which writes out the contents of a datatable serizlized with JavaScriptSerializer.
CODE:
On the jquery side I am doing this.
CODE:
This is returning "invalid json"
Here is the output
CODE:
i have the following code, please let me know where m goin' wrong..
VB
For Each dr As DataRow In dvItems.Table.Rows
strItems &= "'" & dr("ItemTitle") & "',"
Next
[code]....
while debugging in firefox with firebug data is showing null...What i'm doin' here ?
Edit :Autocomplete.js needs data in this format 'mouse','keyboard','led'Before i was doin' this without JSON, it was working fine.
I am been stuck on this for 3 days now...I have been accessing the twitter api to pull a user_timeline for a list of users and the json that comes back is impossible to work with. I tried to deserialize it using javascriptserializer and get an error:invalid object passed in , ':' or '}'
Now this is frustrating since I expect the json being returned to be error free. Then I tried json.net and split the posts using string.split and tried to convert each post to Jobject or jarray. for Jarray I get
'unexpected end of content while loading jArray
[Code]...
Now I have formatted the code here and not pasted the whole file but it does look like valid json to me and I do not alter anything after receiving the stream from the twitter api. Can someone please point me in the right direction? I really need to get this stuff parsed?
I'm strugling the whole day with the next JSON string
{
"0":{"link":"afbeeldingenplaatje1.jpg"},
"1":{"link":"afbeeldingenplaatje2.jpg"},
"2":{"link":"afbeeldingenplaatje3.jpg"}
}
How can i deserialize this? What's wrong with the next code (vb.net)
Public Class DataString
Private m_link As String
Public Property link() As String
Get
[CODE]...
It returns always an empty result.
how to receive and send back json. Hope someone can help me on this. I understand by examples.
On my clientside, I am sending a ajax json string "name":"theName" to the server side and would like the server side to return a string saying "welcome &name ".
Client-side code
<!DOCTYPE html>
<html>
[Code]....
Below is my JSON formated String
{"AliasName": "ysiCountryInfo", "DataClass": {"Description":"United States 111","Code":"usa","WriteOffTaxPointAdjustment":0,"IndexationRounding":6}}
I would like to deserialize object into below class
[code].....
I have a JSON response from a web service that I need to be converted to an object then to an array. My response is similar to the one below:
{"status":{"error":"NO","code":"200","description":"none","message":"Request ok"},"geolocation":{"lat":"38.89515","lng":"-77.0310"},"stations":[{"country":"United States","regPrice":"0.00","midPrice":"0.00","prePrice":"0.00","streetAddress":"1401, I St[code]....
I am doing this is VB.NET within a console for now. Basically I am trying to create a simple way to test my API calls and output the information. What I am trying to accomplish is having to loop through the JSON array and list the stations.
How can I convert a JSON string to an array OR a JSON string to XML in VB.NET? I know how to do this in C#, as I have read dozens of articles on it, however, I am unable to figure out how to achieve the same result in VB.NET.
I'm using the System.Web.Script namespace via System.Web.Extensions.dll (from Microsoft).
I'm willing to use an additional DLL file if needed.
I'm sure this has been asked before but I'm not finding quite the information I'm needing so I thought I'd post this.
I've written a PHP script that returns a simple JSON object that looks like this:
{"status":"success","level":"admin"}
I'm doing a standard web request that submits the required data to the script over the internet and that's working fine.
Now, I want to use JSON.NET to pull out the individual variables so I can know what the values of "status" and "level" are. The problem is, I have no idea where to start.
I'm doing this in VB.NET (on the .NET Compact Framework).
this is my class:
Public Class Employeeclass
Public Property Fname As String
Public Property Lname As String
Public Property Bdate As Date
End Class
[Code]...
I am accessing the facebook api and using the json.net library (newtonsoft.json.net)I declare a Jobject to parse the content and look for the specific elements and get their values. Everything works fine for the first few but then I get this unexplained nullexception error " (Object reference not set to an instance of an object)Now I took a look at the declaration but cannot see how to change it. Dim jobj as JObject = JObject.Parse(responseData) message = jobj("message").tostring
The error occurs at the last line above.I check to see if message is null and then look for the next desired field as follows
[Code]...
This is one example where "message" does not appear in the first few lines but appears later. So what I do is look for position of message and description and which ever is first go and get that and if I get an error or the fields do not return anything, I try and parse by regex and even that is not working right.
I have two experimental web services. One is an asmx contained within a .net web application. The other is a WCF service library being invoked from the web application.The asmx basically does everything I need, but I think WCF would be better, except that it doesn't do anything as I would expect after fiddling with the asmx service.For example, the same method behaves differently in each:
' ASMX
<WebMethod(BufferResponse:=True, EnableSession:=False)>
Function Test(aObject as Object) as Object
' object will have been successfully serializaed into a dictionary
[code]...
I have to send a request to Webservice and I have a working PHP solution, that I have to translate in VB.net
Here's the code working in PHP
//fill in the details of the contacts.userId is obtained from loginResult.
$contactData = array('lastname'=>'Valiant', 'assigned_user_id'=>$userId);
//encode the object in JSON format to communicate with the server.
[code]....
Naturally I imported a reference to a Json library and Imported (Imports Newtonsoft.Json)?
What libraries are available to handle JSON in .Net? I've seen this: [URL]..but would prefer a native library, if possible.
View 3 RepliesI'm trying to understand how to actually use, and create JSON data.
StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
using (JsonWriter jsonWriter = new JsonTextWriter(sw))
[code]....
and I am sure it does... but how do I view it? How do I turn that into an object that the browser can output.It seems to me that the first stage I need to resolve is "how to create" JSON files/strings, next stage will be how to actually use them. If it helps answer the question, what I'm aiming for initially is to be able to use AJAX Autocomplete from a search page generated from my MySQL database, I was hoping I could write a simple SQL query and have that returned using something similar to the above?
[Code]...
I always get {} as answer. What's wrong?
Alright I have been trying to figure this out and I read the MSDN page on the JavaScriptSerializer. However, I still can't figure out how to get this to work on an asp.net page. I want to convert my dataset into a json string so I can graph it using FLOT(graphing tool) imports System.Web.Script.Serialization
dim myObject = dataset.getxml()dim jsonString = new JavaScriptSerializer().Serialize(myObject)
I'm trying to figure out how to do SQL queries towards an SQL 2005 Express server and format the return value to JSON. I got the queries working using this (perhaps very newbie-like) code;
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Web.UI
[code]....
I am trying to call a rest service..that service returns json object...I am able to send the request but unable to serialize the json...here is the code i am trying
[Code]...
How can I read JSON with ASP.NET 2.0? Unfortunately we are unable to upgrade the application because of backward compatibility issues.
View 2 RepliesI am trying to deserialize a JSON string using VB.net and cannot seem to pull the values out of the finished List.[code]I am told "Index was out of range. Must be non-negative and less than the size of the collection."
View 1 RepliesI'm having an issue with getting some of the values from with this json string:
{
"kind": "shopping#products",
"etag": ""YZWJaKE3MHROIW8rCIlu9mAACLM/6qxBB-GwuSPy5L3_zVS6sS2NYFI"",
"id": "tag:google.com,2010:shopping/products",
"selfLink": "https://www.googleapis.com/shopping/search/v1/public/products?country=US&
[code]....
I have the following jquery which is invalid:
{
"id": 12,
"heading": "heading goes here 3",
"content": "<p><span style="color: #ff0000;">content</span> <u><strong>goes </strong></u><span style="color: #ffffff;"><span style="background-color: #ff0000;">here</span></span> 3.</p>"
}
I am generating this with asp.net (vb.net) from data stored in a database. I think I need to somehow escape the double quotes within the content section of the json data. How do I do this?
I'm new to VB and trying to write a webservice that exports and imports JSON.I'm using JSON.NET 3.5 and can serialize fine:My Token class is:
<DataContract()> _
Public Class Token
<DataMember()> _
Public TokenID As String
<DataMember()> _
Public Issued As Date
[Code]...