Analysis of datatable serialization and deserialization instances in C
- 2020-10-31 21:57:51
- OfStack
This article illustrates datatable serialization and deserialization in C# and shares it with you for your reference. The specific methods are as follows:
1. datatable serialization
public string getSendDetailQuery(DateTime timeS, DateTime timeE, string sccount)
{
try
{
SmsOperate so = new SmsOperate();
// get dt
DataTable dtt = so.getSendDetailQuery(timeS, timeE, sccount);
JavaScriptSerializer serializer = new JavaScriptSerializer();
string aaa = Serialize(dtt, false);//datatable Cannot be serialized directly. This is a serialization method
return "0:" + aaa;
}
catch (Exception e)
{
return "-1" + e.Message;
}
}
/// <summary> Serialization method
/// You don't need pagination
/// </summary>
/// <param name="dt"></param>
/// <param name="flag">false</param>
/// <returns></returns>
public string Serialize(DataTable dt, bool flag)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
foreach (DataRow dr in dt.Rows)
{
Dictionary<string, object> result = new Dictionary<string, object>();
foreach (DataColumn dc in dt.Columns)
{
result.Add(dc.ColumnName, dr[dc].ToString());
}
list.Add(result);
}
return serializer.Serialize(list); ;
}
datatable deserialization
public DataTable getSendDetailTest()
{
DataTable dtb = new DataTable();
// Get the serialization result aaa
string aaa = getSendDetailQuery(Convert.ToDateTime("2012-01-01 00:00:00"), Convert.ToDateTime("2012-05-01 23:59:59"), "wangsub1");
if (aaa.Substring(0, 1) == "0")
{
try
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
// var obj = serializer.DeserializeObject(aaa);// deserialization
aaa=aaa.substring(2,aaa.length-2);
ArrayList dic = serializer.Deserialize<ArrayList>(aaa);// deserialization ArrayList type
if (dic.Count > 0)
{
foreach (Dictionary<string, object> drow in dic)
{
if (dtb.Columns.Count == 0)
{
foreach (string key in drow.Keys)
{
dtb.Columns.Add(key, drow[key].GetType());// add dt The column
}
}
DataRow row = dtb.NewRow();
foreach (string key in drow.Keys)
{
row[key] = drow[key];// Add the column value
}
dtb.Rows.Add(row);// add 1 line
}
}
}
catch (Exception e)
{
//
}
}
else
{
//
}
return dtb;
}
I hope this article has helped you with your C# programming.