打印DataSet内容

2015-06-16 09:31:31 访问(2596) 赞(0) 踩(0)


        /// <summary>
        /// 打印DataSet
        /// </summary>
        /// <param name="ds"></param>
        /// <param name="splitChar"></param>
        /// <returns></returns>
        public string PrintDataSet(DataSet ds,string splitChar)
        {
            StringBuilder theResult = new StringBuilder();

            DataTable dt = ds.Tables[0];

            bool isFirst = true;
            foreach (DataColumn dc in dt.Columns)
            {
                if (isFirst)
                    isFirst = false;
                else
                    theResult.Append(splitChar);

                theResult.Append(dc.ColumnName);
            }

            theResult.AppendLine();

            foreach (DataRow dr in dt.Rows)
            {
                isFirst = true;
                foreach (DataColumn dc in dt.Columns)
                {
                    if (isFirst)
                        isFirst = false;
                    else
                        theResult.Append(splitChar);

                    theResult.Append(dr[dc.ColumnName]);
                }
                theResult.AppendLine();

            }

            return theResult.ToString();
        }