Convert JSON To DataTable C#

Background

I have a json from text file and want to convert it into data table in C#. Here, I used dynamic object to get Deserialize Object from Newtonsoft.Json and processed accordingly to convert it into DataTable.

Using the Code

The json.txt contains:

{"offers":[{"rule_id":"3","name":"B2G1",
"description":null},{"rule_id":"5",
"name":"Free Delivery for Orders above Rs 599",
"description":null}],"coupons":[{"rule_id":"1",
"name":" 5% off ","description":" 5% off ",
"coupon_code":"COUPON5"},{"rule_id":"2",
"name":"50% Discount","description":null,
"coupon_code":"pradeep"},{"rule_id":"4",
"name":"50% off","description":null,
"coupon_code":"123456"}]}

Refer --> http://www.jsoneditoronline.org/# to validate json

Download --> Newtonsoft.Json.dll

Use the below method to convert JSON into DataTable.

 private void ConvertJsonToDataTable()
        {
            try
            {
                string jsonString = File.ReadAllText("E:\\json.txt");

                if (!String.IsNullOrWhiteSpace(jsonString))
                {
                    dynamic dynObj = JsonConvert.DeserializeObject(jsonString);
                    var sOffers = dynObj.offers;
                    var sCoupons = dynObj.coupons;

                    DataTable dtPromotions = new DataTable();
                    dtPromotions.Columns.Add("rule_id", typeof(string));
                    dtPromotions.Columns.Add("name", typeof(string));
                    dtPromotions.Columns.Add("coupon_code", typeof(string));
                    dtPromotions.Columns.Add("description", typeof(string));

                    foreach (var cou in sCoupons)
                    {
                        string cou1 = Convert.ToString(cou);
                        string[] RowData = Regex.Split(cou1.Replace
                        ("{", "").Replace("}", ""), ",");
                        DataRow nr = dtPromotions.NewRow();
                        foreach (string rowData in RowData)
                        {
                            try
                            {
                                int idx = rowData.IndexOf(":");
                                string RowColumns = rowData.Substring
                                (0, idx - 1).Replace("\"", "").Trim();
                                string RowDataString = rowData.Substring
                                (idx + 1).Replace("\"", "");
                                nr[RowColumns] = RowDataString;
                            }
                            catch (Exception ex)
                            {
                                continue;
                            }
                        }
                        dtPromotions.Rows.Add(nr);
                    }

                    foreach (var off in sOffers)
                    {
                        string off1 = Convert.ToString(off);
                        string[] RowData = Regex.Split(off1.Replace
                        ("{", "").Replace("}", ""), ",");
                        DataRow nr = dtPromotions.NewRow();
                        foreach (string rowData in RowData)
                        {
                            try
                            {
                                int idx = rowData.IndexOf(":");
                                string RowColumns = rowData.Substring
                                (0, idx - 1).Replace("\"", "").Trim();
                                string RowDataString = rowData.Substring
                                (idx + 1).Replace("\"", "");
                                nr[RowColumns] = RowDataString;
                            }
                            catch (Exception ex)
                            {
                                continue;
                            }
                        }
                        dtPromotions.Rows.Add(nr);
                    }

                    if (dtPromotions.Rows.Count > 0)
                    {
                        dgvPromotions.DataSource = dtPromotions;
                        dgvPromotions.Columns["rule_id"].Visible = false;
                        dgvPromotions.Columns["name"].HeaderText = "Name";
                        dgvPromotions.Columns["coupon_code"].HeaderText = "Coupon Code";
                        dgvPromotions.Columns["description"].HeaderText = "Description";
                        dgvPromotions.ClearSelection();
                    }
                }
            }
            catch (Exception ex)
            {
                    MessageBox.Show(ex.Message, "ERROR", 
			MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }