First of all you need to create an "ASP.NET Empty Web Site". Then use the following procedure.

Step 1

Create a ConvertJsonStringToDataTable class in the App_Code folder and provide the following:

  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data;
  4. using System.Text.RegularExpressions;

  6. public class ConvertJsonStringToDataTable
  7. {
  8. public DataTable JsonStringToDataTable(string jsonString)
  9. {
  10. DataTable dt = new DataTable();
  11. string[] jsonStringArray = Regex.Split(jsonString.Replace("[", "").Replace("]", ""), "},{");
  12. List<string> ColumnsName = new List<string>();
  13. foreach (string jSA in jsonStringArray)
  14. {
  15. string[] jsonStringData = Regex.Split(jSA.Replace("{", "").Replace("}", ""), ",");
  16. foreach (string ColumnsNameData in jsonStringData)
  17. {
  18. try
  19. {
  20. int idx = ColumnsNameData.IndexOf(":");
  21. string ColumnsNameString = ColumnsNameData.Substring(0, idx - 1).Replace("\"", "");
  22. if (!ColumnsName.Contains(ColumnsNameString))
  23. {
  24. ColumnsName.Add(ColumnsNameString);
  25. }
  26. }
  27. catch (Exception ex)
  28. {
  29. throw new Exception(string.Format("Error Parsing Column Name : {0}", ColumnsNameData));
  30. }
  31. }
  32. break;
  33. }
  34. foreach (string AddColumnName in ColumnsName)
  35. {
  36. dt.Columns.Add(AddColumnName);
  37. }
  38. foreach (string jSA in jsonStringArray)
  39. {
  40. string[] RowData = Regex.Split(jSA.Replace("{", "").Replace("}", ""), ",");
  41. DataRow nr = dt.NewRow();
  42. foreach (string rowData in RowData)
  43. {
  44. try
  45. {
  46. int idx = rowData.IndexOf(":");
  47. string RowColumns = rowData.Substring(0, idx - 1).Replace("\"", "");
  48. string RowDataString = rowData.Substring(idx + 1).Replace("\"", "");
  49. nr[RowColumns] = RowDataString;
  50. }
  51. catch (Exception ex)
  52. {
  53. continue;
  54. }
  55. }
  56. dt.Rows.Add(nr);
  57. }
  58. return dt;
  59. }
  60. }

Step 2

Write the following design code:

  1. <asp:Label ID="ui_lbl_JsonString" runat="server"></asp:Label>
  2. <br />
  3. <br />
  4. <asp:Button ID="ui_btn_Convert1" runat="server" Text="Manually Convert into DataTable" OnClick="ui_btn_Convert1_Click" />
  5. <asp:Button ID="ui_btn_Reload" runat="server" Text="Reload" OnClick="ui_btn_Reload_Click" />
  6. <br />
  7. <br />
  8. <asp:GridView ID="ui_grdVw_EmployeeDetail1" runat="server" Width="50%" HeaderStyle-CssClass="pageheading"></asp:GridView>

Step 3

Now, open the Deafult.asps.cs then write the following code:

  1. using System;
  2. using System.Data;
  3. using System.IO;

  5. public partial class _Default : System.Web.UI.Page
  6. {
  7. #region Global Variable
  8. DataTable dt;
  9. string JsonString = string.Empty;
  10. ConvertJsonStringToDataTable jDt = new ConvertJsonStringToDataTable();
  11. #endregion

  13. protected void Page_Load(object sender, EventArgs e)
  14. {
  15. if (!IsPostBack)
  16. {
  17. string FileName = "JSONString.txt";
  18. var stream = File.OpenText(Server.MapPath(FileName));
  19. JsonString = stream.ReadToEnd();
  20. ui_lbl_JsonString.Text = JsonString;
  21. }

  23. protected void ui_btn_Convert1_Click(object sender, EventArgs e)
  24. {
  25. JsonString = ui_lbl_JsonString.Text;
  26. dt = jDt.JsonStringToDataTable(JsonString);
  27. ui_grdVw_EmployeeDetail1.DataSource = dt;
  28. ui_grdVw_EmployeeDetail1.DataBind();
  29. }

  31. protected void ui_btn_Reload_Click(object sender, EventArgs e)
  32. {
  33. Response.Redirect(Request.RawUrl);
  34. }
  35. }

Step 4

Press F5, run the

Now, convert the JSON string to DataTable using the newtonsoft DLL.

Step 1

Download the Newtonsoft DLL and move it to the ASP.Net project's bin folder.

Step 2

Then, Open the Deafult.aspx page and write the following design code:

  1. <asp:Button ID="ui_btn_Convert2" runat="server" Text="Newtonsoft Convert into DataTable" OnClick="ui_btn_Convert2_Click" />
  2. <br />
  3. <br />
  4. <asp:GridView ID="ui_grdVw_EmployeeDetail2" runat="server" Width="50%" HeaderStyle-CssClass="pageheading"></asp:GridView>

Step 3

Now, write the following code in Default.aspx.cs:

using this namespace.

  1. using Newtonsoft.Json;
And then:
  1. protected void ui_btn_Convert2_Click(object sender, EventArgs e)
  2. {
  3. JsonString = ui_lbl_JsonString.Text;
  4. dt = (DataTable)JsonConvert.DeserializeObject(JsonString, (typeof(DataTable)));
  5. ui_grdVw_EmployeeDetail2.DataSource = dt;
  6. ui_grdVw_EmployeeDetail2.DataBind();
  7. }
Run the project and click on the Newtonsoft Convert to DataTable.

In the preceding code, I convert the JSON String to DataTable.

I have attached the sample project for this, download and see how it works.

Thank you.