DataSet2JSON 1.0.1

This will convert the DataSet to JSON output as the name suggests.

Let's begin. Its just 1 steps process after adding the reference.

Create object for formatter

Code side changes

DataSet2JSON.Formatter convertToJSON = new DataSet2JSON.Formatter();
convertToJSON.FormatDataSet(ds);  // Your Dataset

This will return the output as JObject

Database side changes

First line of the select query should always be a config file.

select '1:Books';   // This is our configuration which will be explained
select id,booktitle from tbl_books;

Output

{
    "Books":[{
        "id":1,
        "booktitle":"Some text"
    },{
        "id":2,
        "booktitle":"Some text2"
    }]
}

By this you can understand that the config is converted to JSON. Now let us see how to change "id" of the Books to "BookID".

select '1:Books';
select id as BookID,booktitle as Title from tbl_books;

Output

{
    "Books":[{
        "BookID":1,
        "Title":"Some text"
    },{
        "BookID":2,
        "Title":"Some text2"
    }]
}

Now lets get only single book as output. The above Books is a list now I need a single object.

select '1:Books:single';

Output

{
    "Books":{
        "BookID":1,
        "Title":"Some text"
    }
}