list Item to json Formate

Abhineet Srivastava

13y2.2k.NET

how can we convert our list item to Json formate?

Cheers

9 Replies

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

Abhishek Jain13y ago
Accepted answer
I have used linq for the Filter and not for retrieving records, try this:

if (!IsPostBack)
{
DataTable dtTable = new DataTable();
string conn_String = ConfigurationManager.ConnectionStrings["myDb"].ConnectionString;

using (SqlConnection conn = new SqlConnection(conn_String))
{
string sql = "SELECT Top 20 * FROM Person.Person";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
using (SqlDataAdapter ad = new SqlDataAdapter(cmd))
{

ad.Fill(dtTable);
}

}
}
List list = new List();
foreach (DataRow dr in dtTable.Rows)
{
list.Add(dr);
}

Func<List, object> filter =
new Func, object>(list => list .Select(row=> new { }));

string json = new JavaScriptSerializer().Serialize(filter(list ));
}
}

Regards
AJ
Abhineet Srivastava13y ago
hello

Can you correct my linq query--

Func, object> filter =
new Func, object>(list1 => list .Select(row=> new {FirstName="list.FirstName",LastName="list.LastName"}))
Abhineet Srivastava13y ago
Thanks Abhishek :)
Abhishek Jain13y ago
using System.Web.Script.Serialization;

Regards
AJ
Abhineet Srivastava13y ago
very thanks....

What will the namespace for JavaScriptSerializer?
Abhishek Jain13y ago
yes it is perfectly right, even you should not flow the data in form of DataTable across layers, it is advisable to create some Data Transfer Objects for this.

Regards
AJ
Abhineet Srivastava13y ago
Well Abhishek,

is it right way to convert datatable to list?
Abhineet Srivastava13y ago
Thanks Abhishek, i am not linq to retrive data from database. My code is like that--

if (!IsPostBack)
{
DataTable dtTable = new DataTable();
string conn_String = ConfigurationManager.ConnectionStrings["myDb"].ConnectionString;

using (SqlConnection conn = new SqlConnection(conn_String))
{
string sql = "SELECT Top 20 * FROM Person.Person";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
using (SqlDataAdapter ad = new SqlDataAdapter(cmd))
{

ad.Fill(dtTable);
}

}
}
List list = new List();
foreach (DataRow dr in dtTable.Rows)
{
list.Add(dr);
}

}
}
Abhishek Jain13y ago
For his you can create a Extension method for converting it to JSON:

public static string ToJson(this T objectToBeConverted, Func filter)
{
return new JavaScriptSerializer().Serialize(filter(objectToBeConverted));
}

Now for converting a List to JSON, you need a list and a filter which you need to create, so do something like this:

public class User
{
public string Id { get; set; }
public string Name { get; set; }
}

Suppose you have a list of users which you want to convert to JSON:

public IList users = new List();

Creating Filter:

Func, object> userListFilter =
new Func, object>(users => users.Select(user => new { user.Id, user.Name }));

Converting it to JSON:

users.ToJson>(userListFilter));

Hope it helps.

Regards
AJ