public System.Data.DataTable ReturnCleanSemanticResults(string QueryResults)
{
string[] QuerySeparatorLeftBracket = { "]" };
string[] QuerySeparatorRightBracket = { "[" };
string[] QuerySeparatorComma = { "," };
string[] QuerySeparatorSubString = { "[\"" };
string[] Individuals = QueryResults.Split(QuerySeparatorLeftBracket,StringSplitOptions.None);
string[] substrings = Individuals[0].Split(QuerySeparatorRightBracket, StringSplitOptions.None);
DataColumn dc = new DataColumn();
DataTable dt = new DataTable();
// build the data columns from the json array
string[] stringToUse = substrings[1].Split(QuerySeparatorComma,StringSplitOptions.None);
string[] stringToUse2;
for (int i2 = 0; i2 <= stringToUse.Length - 1; i2++)
{
string columnName = stringToUse[i2].Replace("\"", "");
dc = new DataColumn(columnName.Replace("\"", ""), System.Type.GetType("System.String"));
dt.Columns.Add(dc);
}
string[] delimiter1 = {('"' + (",\\" + '"'))};
// now start handling the actual values
if ((Individuals.Length > 1))
{
string[] subStrings2 = Individuals[1].Split(QuerySeparatorSubString,StringSplitOptions.None);
string[] tempstring2 = subStrings2[subStrings2.Count()-1].Split(delimiter1, 4, StringSplitOptions.RemoveEmptyEntries);
stringToUse2 = tempstring2[tempstring2.Count() - 1].Split(QuerySeparatorComma, StringSplitOptions.RemoveEmptyEntries);
DataRow dr;
dr = dt.NewRow();
for (int i3 = 1; (i3 <= stringToUse.Length); i3++)
{
string tempstring;
tempstring = stringToUse2[(i3 - 1)].Replace("^^<http://www.w3.org/2001/XMLSchema#string>\"", "").Replace("\\\"", "").Replace("\"", "");
dr[(i3 - 1)] = tempstring.Replace("value:", "");
}
dt.Rows.Add(dr);
/// go until you finish reading the 3rd item from the end of the json array
/// since the last two items are useless
for (int i = 2; (i <= (Individuals.Length - 3)); i++)
{
string[] subStrings3 = Individuals[i].Split(QuerySeparatorSubString,StringSplitOptions.None);
string[] tempstring3 = subStrings3[subStrings3.Count() - 1].Split(delimiter1, 4, StringSplitOptions.RemoveEmptyEntries);
stringToUse = tempstring3[tempstring3.Count() - 1].Split(QuerySeparatorComma, 4, StringSplitOptions.RemoveEmptyEntries);
dr = dt.NewRow();
for (int i3 = 0; (i3
<= (dt.Columns.Count - 1)); i3++)
{
dr[i3] = stringToUse[i3].Replace("^^<http://www.w3.org/2001/XMLSchema#string>\"", "").Replace("\\\"", "").Replace("\"", "");
}
dt.Rows.Add(dr);
}
}
return dt;
}
