将字符串生成器转换为json [英] Convert string builder to json
问题描述
嗨
我使用字符串构建器创建了json字符串,现在我想使用json.net将其转换为json而不使用类。我在下面给出了示例。
提前致谢。
SqlCommand cmd = new SqlCommand(SELECT tcjc_ID,tcjc_JobCode,tcjc_Name,tcjc_JobDesc1 + tcjc_JobDesc2 + tcjc_JobDesc3,tco_Company_Name,tsi_Site_Name FROM tbl_CreateJobCosting LEFT JOT tbl_Companies ON tcjc_CompanyId = tco_CompanyId LEFT JOIN tbl_Sites ON tcjc_SiteId = tsi_SiteID WHERE tcjc_ID =+ jobId,con);
sb.Append({\jobId \:\) ;
sb.Append(jobId);
sb.Append(\,);
尝试
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
if(reader.Read() )
{
sb.Append(\jobcode \:\);
sb.Append(读者) .GetInt32(1));
sb.Append(\,\name \:\);
sb.Append( reader.GetString(2));
sb.Append(\,\desc\:\);
sb.Append(reader.GetString(3));
sb.Append(\,\company \:\);
sb.Append(reader.GetString(4));
sb.Append(\,\site \:\);
sb.Append(reader.GetString(5));
}
是的,我知道为时已晚,但每当下一个人找到他的解决方案时,它会有所帮助。我的解决方案是以json字符串格式转换您的数据,如:
字典<字符串, > myValues = new 字典< string,> ();
myValues.Add( one, 1);
myValues.Add( two, 2);
myValues.Add( three, 3);
StringBuilder sb = new StringBuilder();
sb.Append( {);
bool first = true ;
foreach ( string k in myValues.Keys)
{
if (!first)
{
sb.Append( ,);
}
sb.AppendFormat( \{0} \:\ {1} \,k,myValues [k]);
first = false ;
}
sb.Append( });
Hi
I have created json string using string builder and now i want to convert it to json using json.net without the use of classes.I have given example below.
Thanks in advance.
SqlCommand cmd = new SqlCommand("SELECT tcjc_ID, tcjc_JobCode, tcjc_Name, tcjc_JobDesc1 + tcjc_JobDesc2 + tcjc_JobDesc3, tco_Company_Name, tsi_Site_Name FROM tbl_CreateJobCosting LEFT JOIN tbl_Companies ON tcjc_CompanyId = tco_CompanyId LEFT JOIN tbl_Sites ON tcjc_SiteId = tsi_SiteID WHERE tcjc_ID = " + jobId, con);
sb.Append("{ \"jobId\":\"");
sb.Append(jobId);
sb.Append("\",");
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
sb.Append("\"jobcode\":\"");
sb.Append(reader.GetInt32(1));
sb.Append("\", \"name\":\"");
sb.Append(reader.GetString(2));
sb.Append("\", \"desc\":\"");
sb.Append(reader.GetString(3));
sb.Append("\", \"company\":\"");
sb.Append(reader.GetString(4));
sb.Append("\", \"site\":\"");
sb.Append(reader.GetString(5));
}
Yes, I know its too late, but it would be helpful whenever next one come to find his solution. My solution is convert your data in json string format like:
Dictionary<string,> myValues = new Dictionary<string,>(); myValues.Add("one", "1"); myValues.Add("two", "2"); myValues.Add("three", "3"); StringBuilder sb = new StringBuilder(); sb.Append("{"); bool first = true; foreach (string k in myValues.Keys) { if (!first) { sb.Append(","); } sb.AppendFormat("\"{0}\":\"{1}\"", k, myValues[k]); first = false; } sb.Append("}");
这篇关于将字符串生成器转换为json的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!