I'm new to asp.net and visual basic.
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
I forgot to mention that this would be a new module in DNN
I wouldn't use an ArrayList, but have a look at the JavaScriptSerializer class.
You can use the JsonSerializer class to do so
Here is an example creating a list of string objects and converting to json
Dim lstString As New List(Of [String])()
lstString.Add("One")
lstString.Add("Two")
Dim serializer As New JavaScriptSerializer()
Return serializer.Serialize(lstString)
Put this method in an ashx handler and you can access that from jQuery using the getJSON method.
http://api.jquery.com/jQuery.getJSON/
JavaScriptSerializerclass is available in the System.Web.Script.Serialization namespace.
http://msdn.microsoft.com/en-us/library/system.web.script.serialization.javascriptserializer.aspx
You may probably convert it to an extension method like this and use it wherever you want
var[0][3] or var.item.name; var.item.color; ???