DataList to json Conversion.

I have convert my Datalist to json formate like this--

System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
            List> rows = new List>();
            Dictionary row;
            foreach (DataRow dr in dtTable.Rows)
            {
                row = new Dictionary();
                foreach (DataColumn col in dtTable.Columns)
                {
                    row.Add(col.ColumnName, dr[col]);
                }
                rows.Add(row);
            }
            string json = serializer.Serialize(rows);

o/p-

---------
[{"BusinessEntityID":1,"PersonType":"EM","NameStyle":false,"Title":null,"FirstName":"Ken","MiddleName":"J","LastName":"Sánchez","Suffix":null,"EmailPromotion":0,"AdditionalContactInfo":null,"Demographics":"\u003cIndividualSurvey xmlns=\"http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey\"\u003e\u003cTotalPurchaseYTD\u003e0\u003c/TotalPurchaseYTD\u003e\u003c/IndividualSurvey\u003e","rowguid":"92c4279f-1207-48a3-8448-4636514eb7e2","ModifiedDate":"\/Date(1044642600000)\/"},{"BusinessEntityID":2,"PersonType":"EM","NameStyle":false,"Title":null,"FirstName":"Terri","MiddleName":"Lee","LastName":"Duffy","Suffix":null,"EmailPromotion":1,"AdditionalContactInfo":null,"Demographics":"\u003cIndividualSurvey xmlns=\"http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey\"\u003e\u003cTotalPurchaseYTD\u003e0\u003c/TotalPurchaseYTD\u003e\u003c/IndividualSurvey\u003e","rowguid":"d8763459-8aa8-47cc-aff7-c9079af79033","ModifiedDate":"\/Date(1014489000000)\/"},{"BusinessEntityID":3,"PersonType":"EM","NameStyle":false,"Title":null,"FirstName":"Roberto","MiddleName":null,"LastName":"Tamburello","Suffix":null,"EmailPromotion":0,"AdditionalContactInfo":null,"Demographics":"\u003cIndividualSurvey xmlns=\"http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey\"\u003e\u003cTotalPurchaseYTD\u003e0\u003c/TotalPurchaseYTD\u003e\u003c/IndividualSurvey\u003e","rowguid":"e1a2555e-0828-434b-a33b-6f38136a37de","ModifiedDate":"\/Date(1007490600000)\/"},{"BusinessEntityID":4,"PersonType":"EM","NameStyle":false,"Title":null,"FirstName":"Rob","MiddleName":null,"LastName":"Walters","Suffix":null,"EmailPromotion":0,"AdditionalContactInfo":null,"Demographics":"\u003cIndividualSurvey xmlns=\"http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey\"\u003e\u003cTotalPurchaseYTD\u003e0\u003c/TotalPurchaseYTD\u003e\u003c/IndividualSurvey\u003e","rowguid":"f2d7ce06-38b3-4357-805b-f4b6b71c01ff","ModifiedDate":"\/Date(1009564200000)\/"},{"BusinessEntityID":5,"PersonType":"EM","NameStyle":false,"Title":"Ms.","FirstName":"Gail","MiddleName":"A","LastName":"Erickson","Suffix":null,"EmailPromotion":0,"AdditionalContactInfo":null,"Demographics":"\u003cIndividualSurvey xmlns=\"http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey\"\u003e\u003cTotalPurchaseYTD\u003e0\u003c/TotalPurchaseYTD\u003e\u003c/IndividualSurvey\u003e","rowguid":"f3a3f6b4-ae3b-430c-a754-9f2231ba6fef","ModifiedDate":"\/Date(1012329000000)\/"},{"BusinessEntityID":6,"PersonType":"EM","NameStyle":false,"Title":"Mr.","FirstName":"Jossef","MiddleName":"H","LastName":"Goldberg","Suffix":null,"EmailPromotion":0,"AdditionalContactInfo":null,"Demographics":"\u003cIndividualSurvey xmlns=\"http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey\"\u003e\u003cTotalPurchaseYTD\u003e0\u003c/TotalPurchaseYTD\u003e\u003c/IndividualSurvey\u003e","rowguid":"0dea28fd-effe-482a-afd3-b7e8f199d56f","ModifiedDate":"\/Date(1013884200000)\/"},{"BusinessEntityID":7,"PersonType":"EM","NameStyle":false,"Title":null,"FirstName":"Dylan","MiddleName":"A","LastName":"Miller","Suffix":null,"EmailPromotion":2,"AdditionalContactInfo":null,"Demographics":"\u003cIndividualSurvey xmlns=\"http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey\"\u003e\u003cTotalPurchaseYTD\u003e0\u003c/TotalPurchaseYTD\u003e\u003c/IndividualSurvey\u003e","rowguid":"c45e8ab8-01be-4b76-b215-820c8368181a","ModifiedDate":"\/Date(1046802600000)\/"},{"BusinessEntityID":8,"PersonType":"EM","NameStyle":false,"Title":null,"FirstName":"Diane","MiddleName":"L","LastName":"Margheim","Suffix":null,"EmailPromotion":0,"AdditionalContactInfo":null,"Demographics":"\u003cIndividualSurvey xmlns=\"http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey\"\u003e\u003cTotalPurchaseYTD\u003e0\u003c/TotalPurchaseYTD\u003e\u003c/IndividualSurvey\u003e","rowguid":"a948e590-4a56-45a9-bc9a-160a1cc9d990","ModifiedDate":"\/Date(1043260200000)\/"},{"BusinessEntityID":9,"PersonType":"EM","NameStyle":false,"Title":null,"FirstName":"Gigi","MiddleName":"N","LastName":"Matthew","Suffix":null,"EmailPromotion":0,"AdditionalContactInfo":null,"Demographics":"\u003cIndividualSurvey xmlns=\"http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey\"\u003e\u003cTotalPurchaseYTD\u003e0\u003c/TotalPurchaseYTD\u003e\u003c/IndividualSurvey\u003e","rowguid":"5fc28c0e-6d36-4252-9846-05caa0b1f6c5","ModifiedDate":"\/Date(1044815400000)\/"},{"BusinessEntityID":10,"PersonType":"EM","NameStyle":false,"Title":null,"FirstName":"Michael","MiddleName":null,"LastName":"Raheem","Suffix":null,"EmailPromotion":2,"AdditionalContactInfo":null,"Demographics":"\u003cIndividualSurvey xmlns=\"http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey\"\u003e\u003cTotalPurchaseYTD\u003e0\u003c/TotalPurchaseYTD\u003e\u003c/IndividualSurvey\u003e","rowguid":"ca2c740e-75b2-420c-9d4b-e3cbc6609604","ModifiedDate":"\/Date(1054060200000)\/"},{
---------------------------------------------------------------------------

But i need nly firstname,Lastname,Middle name only..

Kindly help!

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Accepted answer
here it is

foreach (DataRow dr in dtTable.Rows)
{
row = new Dictionary();
foreach (DataColumn col in dtTable.Columns)
{
if(col.ColumnName=="FirstName" || col.ColumnName=="LastName" || col.ColumnName=="MiddleName")
{
row.Add(col.ColumnName, dr[col]);
}

}
rows.Add(row);
}

Regards,
Iftikar
Iftikar Hussain13y ago
please refer the below link

http://www.codeproject.com/Articles/43317/Saving-ASP-NET-Form-Data-with-jQuery-AJAX-and-JSON

Regards,
Iftikar
Abhineet Srivastava13y ago
ok

but how will we get our json data in client side?
Iftikar Hussain13y ago
please refer the below link

https://code.google.com/p/jquery-load-json/

Regards,
Iftikar
Abhineet Srivastava13y ago
No server control...

I have to display only in jquery templates :(
Iftikar Hussain13y ago
you want to display in a grid?
Abhineet Srivastava13y ago
Webapplication
Iftikar Hussain13y ago
are you want to display the output in web application or windows application?

Regards,
Iftikar
Abhineet Srivastava13y ago
I means Jquery templates who display json record(first,middle,last name)?
Abhineet Srivastava13y ago
in any version. I am new in this so don't have much idea about it :(
Iftikar Hussain13y ago
you welcome. What jquey template you want to display it?

Regards,
Iftikar
Abhineet Srivastava13y ago
Thanks you very much :)

Well, Do u have any idea to how to show this json to jquery templates?

Cheers
Abhineet Srivastava13y ago
Can you please give me some code?

Cheers
Iftikar Hussain13y ago
Hi,
While looping check the column name and depend on your condition you just add those column to rows.

Regards,
Iftikar