Ejemplo n.º 1
0
        /// <summary>
        /// requested this through an ajax call, you can call a => [{name:{name1:"ab",name2:"cd"},id:9}]
        /// var jsondatastructure = eval (yourResponseText);
        /// </summary>
        public string makejsonoftable(DataTable table, makejson e)
        {
            StringBuilder sb = new StringBuilder();
            foreach (DataRow dr in table.Rows)
            {
                if (sb.Length != 0)
                    sb.Append(",");
                sb.Append("{");
                StringBuilder sb2 = new StringBuilder();
                foreach (DataColumn col in table.Columns)
                {
                    string fieldname = col.ColumnName;
                    string fieldvalue = dr[fieldname].ToString();
                    if (sb2.Length != 0)
                        sb2.Append(",");
                    sb2.Append(string.Format("\"{0}\":\"{1}\"", fieldname, fieldvalue));


                }
                sb.Append(sb2.ToString());
                sb.Append("}");


            }
            if (e == makejson.e_with_square_brackets)
            {
                sb.Insert(0, "[");
                sb.Append("]");
            }
            return sb.ToString();
        }
Ejemplo n.º 2
0
        /// <summary>
        /// requested this through an ajax call, you can call a => [{name:{name1:"ab",name2:"cd"},id:9}]
        /// var jsondatastructure = eval (yourResponseText);
        /// </summary>
        public string makejsonoftable(DataTable table, makejson e)
        {
            StringBuilder sb = new StringBuilder();

            foreach (DataRow dr in table.Rows)
            {
                if (sb.Length != 0)
                {
                    sb.Append(",");
                }
                sb.Append("{");
                StringBuilder sb2 = new StringBuilder();
                foreach (DataColumn col in table.Columns)
                {
                    string fieldname  = col.ColumnName;
                    string fieldvalue = dr[fieldname].ToString();
                    if (sb2.Length != 0)
                    {
                        sb2.Append(",");
                    }
                    sb2.Append(string.Format("\"{0}\":\"{1}\"", fieldname, fieldvalue));
                }
                sb.Append(sb2.ToString());
                sb.Append("}");
            }
            if (e == makejson.e_with_square_brackets)
            {
                sb.Insert(0, "[");
                sb.Append("]");
            }
            return(sb.ToString());
        }