记录DataSet转换数组方法

 1，

object[][]   str=null;
for(int   i=0;i <ds.Tables[0].Rows.Count;i++)
{
      for(int   j=0;j <ds.Tables[0].Columns.Count;j++)
      {
str[i][j]=ds.Tables[0].Rows[i][j].ToString();
      }
}

 

2，可用于execl读取后转换

public   ArrayList   ArrayList_Northwind_customers()
{
DataSet   ds=new   DataSet();
ArrayList   al=new   ArrayList();
SqlConnection   conn=new   SqlConnection( "server=localhost;uid=sa;pwd=sa;database=Northwind ");
SqlDataAdapter   da=new   SqlDataAdapter( "select   top   100   CustomerID,CompanyName,ContactName,ContactTitle   from   customers ",conn);
conn.Open();
da.Fill(ds, "Northwind_customers ");
foreach(DataRow   row   in   ds.Tables[ "Northwind_customers "].Rows)
{
foreach(System.Data.DataColumn   col   in   ds.Tables[ "Northwind_customers "].Columns)
{
al.Add(row[col].ToString());
}
}
conn.Close();
return   al;
}