How To Create JSON From Database In C#

Add a new Web Form named “Default.aspx”, in this page accepting user Id and password as well as creating cookies.

Step 4

Right click on the project and select Add-->Add New Item and select [Linq To SQL Class].

Select LINQ to SQL Class named “FriendListDataClass.dbml”

As you click on ADD button in the screen given above, you will see the dialog box.

Simply press YES.

Now, switch to Server Explorer and select Data Connections.

Step 5 - Connection establishment

Right click on Data Connections and select ADD CONNECTION option.

Double click your DBML file, which is located inside APP_CODE folder.

Drag and drop the table named “ tblMyFriends” on DBML canvas.

Understanding code for JSON creation

To achieve the task, we require the namespace given below.

System.IO;  
System.Runtime.Serialization.Json;  
  
//this line very important which make ready program to make JSON  
//GetType giving idea about you are going to create json for "System.Collections.Generic.List`1[tblMyFriend]"  
DataContractJsonSerializer ser = new DataContractJsonSerializer(FriendList.GetType());  
          
//Writing the JSON  
ser.WriteObject(str, FriendList);   

CODE Default.aspx.cs

using System;  
using System.Collections.Generic;  
using System.IO;  
using System.Linq;  
using System.Runtime.Serialization.Json;  
using System.Web;  
using System.Web.UI;  
using System.Web.UI.WebControls;  
  
public partial class _Default : System.Web.UI.Page  
{  
    protected void Page_Load(object sender, EventArgs e)  
    {  
        string JsonStr = null;  
       
        FriendListDataClassDataContext db = new FriendListDataClassDataContext();  
        var FriendList = db.tblMyFriends.ToList();  
  
        MemoryStream str = new MemoryStream();  
  
        //this line very important which make ready program to make JSON  
        //GetType giving idea about you are going to create json for "System.Collections.Generic.List`1[tblMyFriend]"  
        DataContractJsonSerializer ser = new DataContractJsonSerializer(FriendList.GetType());  
          
        //Writing the JSON  
        ser.WriteObject(str, FriendList);  
  
        str.Position = 0;  
        StreamReader sr = new StreamReader(str);  
        JsonStr = sr.ReadToEnd();  
  
        //Writing the JSON on browswer   
        Response.Write(JsonStr);  
          
    }  
}

OUTPUT - JSON DATA

[{"FriendID":1,"FriendMobile":"999999786","FriendName":"Shree Sai","FriendPlace":"Shirdi"},
{"FriendID":2,"FriendMobile":"777777777","FriendName":"Ashish Kalla","FriendPlace":"Malad"},
{"FriendID":3,"FriendMobile":"666666666","FriendName":"Suhana Kalla","FriendPlace":"Phalodi"},
{"FriendID":4,"FriendMobile":"555555555","FriendName":"Aakash Kalla","FriendPlace":"Malar"},
{"FriendID":5,"FriendMobile":"111111111","FriendName":"Mahesh Sir","FriendPlace":"US"},
{"FriendID":6,"FriendMobile":"222222222","FriendName":"Praveen Sir","FriendPlace":"Singapore"},
{"FriendID":7,"FriendMobile":"333333333","FriendName":"Dinesh Sir","FriendPlace":"Dubai"}]