Naveed Akhtar - All Comments

Working with ASP.Net Webservice on Vista / Windows Server 2008 (IIS 7)

DotNetKicks.com — Sat, 04 Apr 2009 22:15:52 GMT

You've been kicked (a good thing) - Trackback from DotNetKicks.com

re: Converting Data Table / Dataset Into JSON String

NavaidAkhtar — Sat, 04 Apr 2009 22:12:24 GMT

Danny117, Basically, I am using just a simple technique to convert the dataset to JSON string.

Actually on the code behind i am serializing the data into a format, that is known as JSON format, and with the single line on client side (Javascript)

var JObject = eval('(' + JSONString + ')');

I am deserializing to a JSon Object and then Iterating over the object.

re: Converting Data Table / Dataset Into JSON String

NavaidAkhtar — Sat, 04 Apr 2009 22:08:37 GMT

CRajkumar.ece, Please see your table data, as it contains some illegle chracters like " ' ", try these by using the technique of javascript error free chracter replacement. I will work fine.

If you still have an issue, just shoot me a mail including the code, the resuly set data. I will try to solve your issue.

re: Converting Data Table / Dataset Into JSON String

CRajkumar.ece — Thu, 26 Mar 2009 06:52:00 GMT

Hi,

var JObject = eval('(' + JSONString + ')');

I am New to this concept of json, the above tatement is retunring a error for me. It throws error as "Excepted '('". Can you help me out.

re: Converting Data Table / Dataset Into JSON String

Danny117 — Mon, 12 Jan 2009 02:44:05 GMT

Just what I was looking for. Bookmarked! Simple expanation of how to deserialize table.

re: Converting Data Table / Dataset Into JSON String

Ron — Wed, 26 Nov 2008 03:58:43 GMT

>> This looks like a very fragile method

RichardD, what I think is fragile is whatever the latest Microsoft .NET fad is. Apparently that's LINQ now, so I guess you think that everyone should keep up with the latest thing. I personally prefer timeless and simple solutions like the one Navid posted here. I think it's rude for you to use a term like "fragile" to describe someone else's code. Who do you think you are, Bill Gates, Jr.?

re: Converting Data Table / Dataset Into JSON String

NavaidAkhtar — Thu, 10 Jul 2008 10:56:03 GMT

Hi RichardD

Thanks for your feedback and a wonderful suggestions, but your answer also contradicts your answer beceause, you stated that your solution works on .Net 3.5 or above then .Net 2.0. But My solution is for developers having .Net 2.0 or may be prior to that.

LINQ, JSonSerializer, are not supporting in Net 2.0 or prior versions.

re: Converting Data Table / Dataset Into JSON String

RichardD — Wed, 09 Jul 2008 20:10:35 GMT

This looks like a very fragile method. If you're using .NET 3.5 (or the MS AJAX 1.0 library), you already have the JavaScriptSerializer which does most of the work.

Unfortunately, the DataTable and DataSet objects aren't suitable for JSON serialization directly; you'll need to convert them first. To duplicate your results, you need to convert the DataSet to an IDictionary<string, IEnumerable<IDictionary<string, object>>>.

With LINQ, the code is fairly simple:

static object RowsToDictionary(this DataTable table)

{

var columns = table.Columns.Cast<DataColumn>().ToArray();

return table.Rows.Cast<DataRow>().Select(r => columns.ToDictionary(c => c.ColumnName, c => r[c]));

}

static Dictionary<string, object> ToDictionary(this DataTable table)

{

return new Dictionary<string, object>

{

{ table.TableName, table.RowsToDictionary() }

};

}

static Dictionary<string, object> ToDictionary(this DataSet data)

{

return data.Tables.Cast<DataTable>().ToDictionary(t => t.TableName, t => t.RowsToDictionary());

}

public static string GetJSONString(DataTable table)

{

JavaScriptSerializer serializer = new JavaScriptSerializer();

return serializer.Serialize(table.ToDictionary());

}

public static string GetJSONString(DataSet data)

{

JavaScriptSerializer serializer = new JavaScriptSerializer();

return serializer.Serialize(data.ToDictionary());

}

re: ASP.Net Compilation and Merge Tool (Part 2 of 2)

NavaidAkhtar — Tue, 08 Jul 2008 10:31:30 GMT

Hi Tony

ASP.NET Merge tool can be used in three options:

Merge all outputs into a single assembly.

"Merge each folder's Web UI content (Web pages, skins, and so on) into its own assembly."

Merge all Web UI content in the site into a single assembly.

Answer to your question is in " ".

Any Questions / Queries?

Regards,

Naveed Akhtar

re: ASP.Net Compilation and Merge Tool (Part 2 of 2)

Tony — Tue, 08 Jul 2008 09:13:42 GMT

Do you know if it is possible to add/compile new controls and pages to an existing precompiled (updateable) ASP.NET website ?