如何将SQL查询结果存放到数组里面？
定义一个数组 string[] name = {}; 

SQL 语句是 select name from Student 

我想将查询结果一一赋值给数组 name 该如何操作呢？

谢谢了

------解决方案--------------------
查询到datatable，自己写到数组
------解决方案--------------------
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中某行的某列”
}
------解决方案--------------------
//数据表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;
}