code_junkie

Converting A Dataset to JSON using .net 3.5 in C#

Nov 12th, 2011
155
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. public static string GetJSONString(DataTable Dt)
  2. {
  3.  
  4. string[] StrDc = new string[Dt.Columns.Count];
  5. string HeadStr = string.Empty;
  6.  
  7. for (int i = 0; i < Dt.Columns.Count; i++)
  8. {
  9.  
  10. StrDc[i] = Dt.Columns[i].Caption;
  11.  
  12. HeadStr += """ + StrDc[i] + "" : "" + StrDc[i] + i.ToString() + "¾" + "",";
  13. }
  14.  
  15. HeadStr = HeadStr.Substring(0, HeadStr.Length - 1);
  16.  
  17. StringBuilder Sb = new StringBuilder();
  18. Sb.Append("{"" + Dt.TableName + "" : [");
  19.  
  20. for (int i = 0; i < Dt.Rows.Count; i++)
  21. {
  22.  
  23. string TempStr = HeadStr;
  24. Sb.Append("{");
  25.  
  26. for (int j = 0; j < Dt.Columns.Count; j++)
  27. {
  28.  
  29. TempStr = TempStr.Replace(Dt.Columns[j] + j.ToString() + "¾", Dt.Rows[i][j].ToString());
  30. }
  31.  
  32. Sb.Append(TempStr + "},");
  33. }
  34.  
  35. Sb = new StringBuilder(Sb.ToString().Substring(0, Sb.ToString().Length - 1));
  36. Sb.Append("]}");
  37.  
  38. return Sb.ToString();
  39. }
Add Comment
Please, Sign In to add comment