知识在于积累(.NET之路……)

导航

(C#)将DataTable转为二维数组

       /// <summary>
        /// 将DataTable转为二维数组
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        private string[,] DataTableToArray(DataTable dt)
        {
            int i = 0;
            int rowsCount = dt.Rows.Count;
            int colsCount = dt.Columns.Count;
            string[,] arrReturn = new string[rowsCount, colsCount];
            foreach (System.Data.DataRow row in dt.Rows)
            {
                int j = 0;
                foreach (System.Data.DataColumn column in dt.Columns)
                {
                    arrReturn[i, j] = row[column.ColumnName].ToString();
                    j = j + 1;
                }
                i = i + 1;
            }
            return arrReturn;
        }

 

posted on 2012-05-29 10:28  汤尼  阅读(2329)  评论(0编辑  收藏  举报