C # Converts a column of a DataTable into a JSON-formatted string

Converts a column of a DataTable into a JSON-formatted string (after conversion, it adds {} to the string before and after it is converted)

// <summary>
///datatable loading and changing column data into JSON's current format
// </summary>
/// <param name= "DT" ></param>
/// <param name= "RowIndex" >datatable the first few lines </param>
// <returns></returns>
protected static string Createtabcolumndatajson (System.Data.DataTable dt, int rowIndex)
{
String jsonstr = "";
DateTime Dtime;
for (int i = 0; i < dt. Columns.count; i++)
{
String cName = dt. Columns[i]. ColumnName;
String cvalue = dt. Rows[rowindex][cname]. ToString ();
if (! String.IsNullOrEmpty (Cvalue)) //! String.IsNullOrEmpty (cvalue) edit by Spark 2011-3-30 F_parcel_term1,f_parcel_term1
{
Try
{
//regex r = new Regex (@ "\d{4}-\d{1,2}-\d{1,2} (\s+\d{1,2}:\d{1,2}:\d{1,2})?");
if (dt. Columns[cname]. DataType = = typeof (DateTime))
//if (R.ismatch (cvalue))
{
Dtime = DateTime.Parse (cvalue);
if (dtime. Hour = = 0 && dtime. Minute = = 0 && dtime. Second = = 0)
{
Cvalue = Dtime. ToString ("Yyyy-mm-dd");
}
Else
{
Cvalue = Dtime. ToString ("Yyyy-mm-dd HH:mm:ss");
}
}
}
catch (Exception ex)
{ }
if (Jsonstr = = "")
Jsonstr = CName + ": '" + cvalue + "'";
Else
Jsonstr + = "," + CName + ":" + cvalue + "'";
}
}
return jsonstr;
}

C # Converts a column of a DataTable into a JSON-formatted string