DataSet 转换为string

[stevenhzj]

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']

[chen2319]

循环拼字符串呗

[hernmmy]

MARK下

[qiume]

用两个循环就搞定......

[yagebu1983]

循环操作。。。

[ZJ159]

顶顶啊

[yingzhilian2008]

大体就是 字符串的拼接了

[CutBug]

#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);

[stevenhzj]

楼上的，我试了好像不行 Regex.Replace 这里返回为空

[CutBug]

晕，上面自动在<前面多加了空格

#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);

[stevenhzj]

还有问题，如果遇到DataSet 中有空值，那种情况怎么处理呢？
我试了，有空值的话，就不会往下了

[CutBug]

 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[] { DBNull.Value, 71.72, 0.02, DBNull.Value, "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);
       

        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);

[CutBug]

DataSet.getXml() 然后通过正则替换处理一下

[wuyq11]

循环DATASET，把数据导入到叔祖。
或转化为xml

[Jack2013tong]

循环dataset里的数据拼成字符串

[HDNGO]

拼串儿。。循环之~

[readfuture]

用两个循环，先循环DataSet的DataTable，再循环DataTable的数据行就能得到你想要的字符串了

[sunshine_anycall]

自定义函数处理