DataSet 转换为string,该如何处理

DataSet 转换为string
string 格式:
 ['3m Co',71.72,0.02,0.03,'9/1 12:00am'],
  ['Alcoa Inc',29.01,0.42,1.47,'9/1 12:00am'],
  ['Altria Group Inc',83.81,0.28,0.34,'9/1 12:00am'],
  ['American Express Company',52.55,0.01,0.02,'9/1 12:00am'],
  ['American International Group, Inc.',64.13,0.31,0.49,'9/1 12:00am'],
  ['AT&T Inc.',31.61,-0.48,-1.54,'9/1 12:00am']

[解决办法]
DataSet.getXml() 然后通过正则替换处理一下
[解决办法]
循环DATASET，把数据导入到叔祖。
或转化为xml
[解决办法]
循环dataset里的数据拼成字符串
[解决办法]
拼串儿。。循环之~
[解决办法]
用两个循环，先循环DataSet的DataTable，再循环DataTable的数据行就能得到你想要的字符串了
[解决办法]
自定义函数处理
[解决办法]
循环拼字符串呗
[解决办法]
MARK下
[解决办法]
用两个循环就搞定......
[解决办法]
循环操作。。。
[解决办法]
顶顶啊
[解决办法]
大体就是 字符串的拼接了
[解决办法]
#region test data
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt.Columns.Add("col1", typeof(string));
dt.Columns.Add("col2", typeof(decimal));
dt.Columns.Add("col3", typeof(decimal));
dt.Columns.Add("col4", typeof(decimal));
dt.Columns.Add("col5", typeof(string));
dt.Rows.Add(new object[] {"3m Co",71.72,0.02,0.03,"9/1 12:00am" });
dt.Rows.Add(new object[] { "Alcoa Inc", 29.01, 0.42, 1.47, "9/1 12:00am" });
dt.Rows.Add(new object[] { "Altria Group Inc", 83.81, 0.28, 0.34, "9/1 12:00am" });
ds.Tables.Add(dt);
#endregion 

string strTbl = ds.Tables[0].TableName;
StringBuilder sBld = new StringBuilder();
sBld.AppendFormat("<{0}>[^<]*", strTbl);
for (int i = 0; i < dt.Columns.Count; i++)
{
sBld.AppendFormat("<{0}>([^<]+)</{0}>[^<]*", dt.Columns[i].ColumnName);
}
sBld.AppendFormat("[^<]*</{0}>", strTbl);
string reg = sBld.ToString();

string s = ds.GetXml();
s = Regex.Replace(s, reg, "['${1}',${2},${3},${4},${5}],",RegexOptions.IgnoreCase);
s = Regex.Replace(s, @"[^]]*</?\w+>[^[]*", "");
Response.Write(s);
[解决办法]
晕，上面自动在<前面多加了空格
 

C# code

#region test data        DataSet ds = new DataSet();        DataTable dt = new DataTable();        dt.Columns.Add("col1", typeof(string));        dt.Columns.Add("col2", typeof(decimal));        dt.Columns.Add("col3", typeof(decimal));        dt.Columns.Add("col4", typeof(decimal));        dt.Columns.Add("col5", typeof(string));        dt.Rows.Add(new object[] { "3m Co", 71.72, 0.02, 0.03, "9/1 12:00am" });        dt.Rows.Add(new object[] { "Alcoa Inc", 29.01, 0.42, 1.47, "9/1 12:00am" });        dt.Rows.Add(new object[] { "Altria Group Inc", 83.81, 0.28, 0.34, "9/1 12:00am" });        ds.Tables.Add(dt);        #endregion        string strTbl = ds.Tables[0].TableName;        StringBuilder sBld = new StringBuilder();        sBld.AppendFormat(" <{0}>[^<]*", strTbl);        for (int i = 0; i < dt.Columns.Count; i++)        {            sBld.AppendFormat("<{0}>([^<]*)</{0}>[^<]*", dt.Columns[i].ColumnName);        }        sBld.AppendFormat("[^<]* </{0}>", strTbl);        string reg = sBld.ToString();        string s = ds.GetXml();        s = Regex.Replace(s, reg, "['${1}',${2},${3},${4},${5}],", RegexOptions.IgnoreCase);        s = Regex.Replace(s, @"[^]]*</?\w+>[^[]*", "");        Response.Write(s);