How to convert ExecuteReader to Json object in C#

Question

SqlCommand command = new SqlCommand(queryString, connection);
command.ExecuteReader();

I want to get json object which has "PackageID","PackageNumber","StatusName" from this sqlCommand.How can I do it?

Possible duplicate of http://stackoverflow.com/questions/5083709/convert-from-sqldatareader-to-json — Varun K, Aug 11 '13 at 13:46

score 0 · Answer 1 · edited Apr 11 '18 at 20:16

0

You can create an class that has the properties that you required. E.g.

class Package{
    public string PackageID{get;set;}
    public int PackageNumber{get;set;}
    public string StatusName{get;set;}
}

Assign this object with reader, then use some JSON library to serialize the object to JSON object.

edited Apr 11 '18 at 20:16

Patrick

answered Aug 11 '13 at 13:58

Eric

1 Answers1