title: How to convert datatable to json string using json.net?
body: <p>How to convert datatable to json using json.net? Any suggestion... I ve downloaded the necessary binaries... Which class should i use to get the conversion of my datatable to json?
  Thus far used this method to get json string by passing my datatable...</p>
  
  <pre><code>public string GetJSONString(DataTable table)
      {
          StringBuilder headStrBuilder = new StringBuilder(table.Columns.Count * 5); //pre-allocate some space, default is 16 bytes
          for (int i = 0; i &lt; table.Columns.Count; i++)
          {
              headStrBuilder.AppendFormat("\"{0}\" : \"{0}{1}¾\",", table.Columns[i].Caption, i);
          }
          headStrBuilder.Remove(headStrBuilder.Length - 1, 1); // trim away last ,
  
          StringBuilder sb = new StringBuilder(table.Rows.Count * 5); //pre-allocate some space
          sb.Append("{\"");
          sb.Append(table.TableName);
          sb.Append("\" : [");
          for (int i = 0; i &lt; table.Rows.Count; i++)
          {
              string tempStr = headStrBuilder.ToString();
              sb.Append("{");
              for (int j = 0; j &lt; table.Columns.Count; j++)
              {
                  table.Rows[i][j] = table.Rows[i][j].ToString().Replace("'", "");
                  tempStr = tempStr.Replace(table.Columns[j] + j.ToString() + "¾", table.Rows[i][j].ToString());
              }
              sb.Append(tempStr + "},");
          }
          sb.Remove(sb.Length - 1, 1); // trim last ,
          sb.Append("]}");
          return sb.ToString();
      }
  </code></pre>
  
  <p>Now i thought of using json.net but dont know where to get started....</p>