如何将SQL查询结果存放到数组里面？

Question

定义一个数组  string[] name = {}; SQL 语句是  select name from Student 我想将查询结果一一赋值给数组  name  该如何操作呢？谢谢了

Answer 1

查询到datatable，自己写到数组

Answer 2

OleDbConnection Conn = new OleDbConnection(Xls_ConnStr);
dataset ds =new dataset();    
        try
            {
                Conn.Open();
                string sql_str = "select * from [Sheet1$]";
                OleDbDataAdapter da = new OleDbDataAdapter(sql_str, Conn);
                da.Fill(ds, "excel_data");
                Conn.Close();
            }
            catch
            {
                
                return null;
            }
            finally
            {
if (Conn.State == ConnectionState.Open)
                {
                    Conn.Close();
                }
                Conn.Dispose();
            }                                  return ds.Tables[0];
        }string [] arr=new string  [ds.Table[0].Count];for (int i=0;i<arr.Length;i++)
{arr[i]=“ds中某行的某列”
}

Answer 3

//数据表DataTable转数组  
       public static string[] TableTostrArray(DataTable dt, string columnname)  
      {  
           string[] arrayA = new string[dt.Rows.Count];  
            for (int i = 0; i < dt.Rows.Count; i++)  
           {  
               DataRow dr2 = dt.Rows[i];  
               arrayA[i] = Convert.ToString(dr2[columnname]);  
           }  
 
            return arrayA;  
        }  

Answer 4

先查询到DataTable，再转换为数组http://archive.cnblogs.com/a/1347753/