谁给看看这个foreach()语句该如何改？

Question

foreach (DataRow row in ds.Tables[0].Rows)
        {
            string hwbh = Convert.ToString(row["hwbh"].ToString());
            string cmd2 = "select hwbh,jydxx.sxhh,sdzmc,shrxm,hwmc,hwzjs,hwztj,hwzzl,hwyf,hwzt from hwxx,jydxx where jydxx.jydbh = hwxx.jydbh and  hwxx.hwbh ='" + hwbh + "'";
            DataSet ds_hwxx = sqlHelp.GetDataSet(cmd2);            string s =  "[['" + ds_hwxx.Tables[0].Rows[0][0].ToString() + "','" + ds_hwxx.Tables[0].Rows[0][1].ToString() + "','" + ds_hwxx.Tables[0].Rows[0][2].ToString() + "','" + ds_hwxx.Tables[0].Rows[0][3].ToString() +
                     "','" + ds_hwxx.Tables[0].Rows[0][4].ToString() + "'," + ds_hwxx.Tables[0].Rows[0][5].ToString() + "," + ds_hwxx.Tables[0].Rows[0][6].ToString() + "," + ds_hwxx.Tables[0].Rows[0][7].ToString() +
                     "," + ds_hwxx.Tables[0].Rows[0][8].ToString() + "" + "," + ds_hwxx.Tables[0].Rows[0][9] + "]" +","+
                     "]";            result.Append(s);
            Response.Write(result.ToString());        }我的意思是根据hwbh 查询数据库 将查询到的记录以s的格式放入grid中如果是一条的话 格式为
[['10020101019000501 ','7777888','漳州','羽泉','花卉',1,0.000,3.265,1143.00,2 ]]
如果为两条的话 格式为
[
['10020101019000501 ','7777888','漳州','羽泉','花卉',1,0.000,3.265,1143.00,2 ],
['10020101019000502 ','7777888','漳州','羽泉','花卉',1,0.000,3.265,1143.00,2 ]
]
如果为三条的话 格式为
[
['10020101019000501 ','7777888','漳州','羽泉','花卉',1,0.000,3.265,1143.00,2 ],
['10020101019000502 ','7777888','漳州','羽泉','花卉',1,0.000,3.265,1143.00,2 ],
['10020101019000503 ','7777888','漳州','羽泉','花卉',1,0.000,3.265,1143.00,2 ]]以此类推
现在 result.Append(s); Response.Write(result.ToString());  这两条语句执行后 result的格式为
[['10020101019000501  ','7777888','漳州','羽泉','花卉',1,0.000,3.265,1143.00,2 ]][['10020101102000101  ','5555','漳州','吴孟达','鞋子',1,0.000,2.636,949.00,2 ]]如何将以上格式改为
[
['10020101019000501 ','7777888','漳州','羽泉','花卉',1,0.000,3.265,1143.00,2 ],
['10020101019000502 ','7777888','漳州','羽泉','花卉',1,0.000,3.265,1143.00,2 ]
]此种格式输出呢？

Answer 1

加上换行符\r\n如果是网页，加上“<br />”

Answer 2

kao 都不看题目乱讲
s是这种格式
[['10020101019000501 ','7777888','漳州','羽泉','花卉',1,0.000,3.265,1143.00,2 ]][['10020101102000101 ','5555','漳州','吴孟达','鞋子',1,0.000,2.636,949.00,2 ]]
要改为这种格式
[
['10020101019000501 ','7777888','漳州','羽泉','花卉',1,0.000,3.265,1143.00,2 ],
['10020101019000502 ','7777888','漳州','羽泉','花卉',1,0.000,3.265,1143.00,2 ]
]
需要去掉中间的]]和多加个, 

Answer 3

给你提个建议：调试程序时要把程序简化，也就是说，程序一步一步写，写一步调一步。针对你的例子，应该先调最外层循环的那一块
foreach (DataRow row in ds.Tables[0].Rows)
  {
  string hwbh = Convert.ToString(row["hwbh"].ToString());
//显示结果
}如果没问题了，再进一步调另一个DataSet。但调试的时候先读一个字段试(最好把SQL语句也写简单一点)，
foreach (DataRow row in ds.Tables[0].Rows)
  {
  string hwbh = Convert.ToString(row["hwbh"].ToString());
  string cmd2 = "select hwbh from hwxx,jydxx where jydxx.jydbh = hwxx.jydbh and hwxx.hwbh ='" + hwbh + "'";
  DataSet ds_hwxx = sqlHelp.GetDataSet(cmd2);  string s = "[['" + ds_hwxx.Tables[0].Rows[0][0].ToString()；
//显示结果
}
最后再把所有条件写全了测试。你一下子全写出来，调试很麻烦。

Answer 4

数据都是正确的 我一条一条查看过了  就是格式错了
要输出的结果为
就是这种格式 
一行[[1,a,b,c,]]
二行[[1,a,b,c,],[2,a,b,c]]
三行[[1,a,b,c,],[2,a,b,c],[3,a,b,c]]象这样该怎么组织s呢 

Answer 5

输出json数据？
直接用下面这个，很好用，也非常著名。
http://james.newtonking.com/projects/json-net.aspx