DataTable to nested json in c#

System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TallyWeb"].ToString());

SqlCommand cmd = new SqlCommand();

cmd.CommandText = "select CstCmpCode, Loaded_date, Main_Group, Sub_Group, ClosBal from TlyStkSumm where CstCmpCode = @CstCmpCode";

cmd.Parameters.AddWithValue("@CstCmpCode", CstCmpCode);

DataSet ds = new DataSet();

DataTable dt = new DataTable();

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.SelectCommand.Connection = con;

da.Fill(dt);

con.Close();

 

var main = new Dictionary>();

foreach (DataRow rs in dt.Rows)

{

string Main_Group = rs["Main_Group"].ToString();

Dictionary sub;

if (!main.TryGetValue(Main_Group, out sub))

{

sub = new Dictionary();

main.Add(Main_Group, sub);

}

sub.Add(rs["Sub_Group"].ToString(), (string)rs["ClosBal"]);

}

RootObject root = new RootObject { main = main };