Comments on: How To Create A JSON Web Service In ASP.NET

By: TG

TG — Fri, 05 Feb 2010 11:30:18 +0000

hehe… Another free tool: http://jsonviewer.stack.hu

By: Andre

Andre — Fri, 13 Nov 2009 12:05:05 +0000

can i call this service from a different domain or must the service and consuming application be within the same domain?

By: Nick Tulett

Nick Tulett — Wed, 21 Oct 2009 13:06:31 +0000

Well, I got to work and my code broke spectacularly Seems my bodged VM at home has an old version of ASP.NET and returning Dictionary isn’t allowed now.

I don’t know whether JaggedArray or Dictionary has any performance implications, but I’m now using:

public string DataTable2JSON(DataTable dt)
{
List RowList = new List();
foreach (DataRow dr in dt.Rows)
{
Dictionary ColList = new Dictionary();
foreach (DataColumn dc in dt.Columns)
{
ColList.Add(dc.ColumnName,
(string.Empty == dr[dc].ToString()) ? null : dr[dc]);
}
RowList.Add(ColList);
}
JavaScriptSerializer js = new JavaScriptSerializer();
string JSON = js.Serialize(RowList);
return JSON;
}

By: Nick Tulett

Nick Tulett — Tue, 20 Oct 2009 21:59:47 +0000

I don’t think the jagged array or serializer are necessary if you return a List, rather than a string:
[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public List getSQLRowByValue(string strTable, string strCol, string strValue)
{
DataTable dt = getSQLrow(strTable, strCol, strValue);//returns a DataTable – could be from MySQL ODBC in your case
List RowList = new List();
foreach (DataRow dr in dt.Rows)
{
Dictionary ColList = new Dictionary();
foreach (DataColumn dc in dt.Columns)
{
ColList.Add(dc.ColumnName,
(string.Empty == dr[dc].ToString()) ? null : dr[dc]); ;
}
RowList.Add(ColList);
}
return RowList;
}

By: ContinousLearner: Links (7/30/2009) | Astha

ContinousLearner: Links (7/30/2009) | Astha — Wed, 09 Sep 2009 05:28:12 +0000

[...] How To Create A JSON Web Service In ASP.NET [...]

By: Brothel Locator Web Service In COBOL – Williamsport Web Developer Weblog

Brothel Locator Web Service In COBOL – Williamsport Web Developer Weblog — Wed, 29 Jul 2009 22:28:43 +0000

[...] Yahoo! Maps – Twitter « How To Create A JSON Web Service In ASP.NET [...]

By: Robert S. Robbins

Robert S. Robbins — Tue, 28 Jul 2009 23:58:00 +0000

Sandra Dee, I use a free JSON Viewer available at: http://www.codeplex.com/JsonViewer I even made a minor improvement to it.

By: Sandra Dee

Sandra Dee — Tue, 28 Jul 2009 09:10:54 +0000

I prefer JSON when communicating with my web services as well. One difficulty that I encountered is that when the JSON came across the wire it was very difficult to read because it was compressed unlike the XML which was well-formatted. I found a tool called JSON Pro Viewer which helps drastically to view and edit large/deeply nested JSON documents:
http://www.jsonpro.com

By: You are now listed on FAQPAL

You are now listed on FAQPAL — Tue, 28 Jul 2009 00:47:56 +0000

How To Create A JSON Web Service In ASP.NET…

This article and sample code will show you how to get your web service to return data in the JSON format….