datatable与array相互转换

using System;
using System.Data;
using System.Data.OleDb;

namespace pxkt_datatable
{
    
class pxkt
    
{
        
public pxkt()
        
{
            
string[] g = new string[10];
            
for(int i=0;i<10;i++)
            
{
             g[i]
=i.ToString();
            }


        
//    数组 转 数据表DataTable
                        
            DataTable dt 
= new DataTable();
            dt.Columns.Add(
"name",typeof(string));
            
for (int k=0;k<g.Length;k++)
            
{
                DataRow dr 
= dt.NewRow();
                dr[
"name"]=g[k];
                dt.Rows.Add(dr);
            }

        
//输出数据表

            Console.WriteLine(
"打出数据表!");
            
for(int j= 0;j<dt.Rows.Count;j++)
            
{
                DataRow dr1 
= dt.Rows[j];
                Console.WriteLine(dr1[
"name"].ToString());
            }



        
//数据表DataTable转数组
            string[] arrayA = new string[dt.Rows.Count];
            
for(int x=0;x<dt.Rows.Count;x++)
            
{
                DataRow dr2 
= dt.Rows[x];
                arrayA[x]
=Convert.ToString(dr2["name"]);
            }


        
//输出数组
            Console.WriteLine("打出数组!");
            
for(int y=0;y<arrayA.Length;y++)
            
{
                Console.WriteLine(arrayA[y]);
            }


            
foreach(string printarray in arrayA)
            
{
                Console.WriteLine(printarray);
            }


            
        }


        
static pxkt()
        
{
        
        }

    }


    
class test

    
{
        
static void Main()
        
{
            pxkt p 
= new pxkt();
        }

    }



}
 
posted @ 2007-09-10 17:39  宿远  阅读(1336)  评论(2编辑  收藏  举报