select查询内容怎么塞入数组

[a708964454]

定义一个字符串string sql =“select A from B”，例如查询结果是一个列名A，里面有第一行是a、第二行是b、第三行是c、第四行是d等等，然后又定义一个数组string[ ] roles = new string[100]，怎么把字符串sql的a、b、c、d等等依此塞入数组roles啊

[insus]

Like this? http://www.cnblogs.com/insus/archive/2012/03/28/2421230.html

[insus]

反之： http://www.cnblogs.com/insus/archive/2012/02/26/2368283.html

[一个大猴子]

用这个 DataTable dt = 你用SQL语句查询出来的结果。 string[ ] roles = new string[dt.rows.count]; for(int i=0;i<dt .rows.count;i++) { roles [i]=dt.rows[i]["A"].tostring(); }

[祥子爱游戏]

for呗，想什么呢

[zdczdccccc]

linq，要不就是foreach迭代DataTable.Rows

[以专业开发人员为伍]

ADO.NET 和 LINQ 大致是这样使用的

List<string> result;
using(var conn = CreateSqlConnection(ConnctString))
{
    conn.Open();
     var comm = conn.CreateCommand();
     comm.CommandText = "select A from B";
     comm.CommandType = System.Data.CommandType.Text;
     result = ( from DbDataRecord record in comm.ExecuteReader()
                     let name = (string)record["TheName"]
                     select (string)record[0]
                  ).ToList();
}    

[以专业开发人员为伍]

List<string> result;
using(var conn = CreateSqlConnection(ConnctString))
{
    conn.Open();
     var comm = conn.CreateCommand();
     comm.CommandText = "select A from B";
     comm.CommandType = System.Data.CommandType.Text;
     result = ( from DbDataRecord record in comm.ExecuteReader()
                     let name = (string)record["A"]
                     select (string)record[0]
                  ).ToList();
}   

[by_封爱]

datatable dt=你的类库.查询("select a from xxoo");
string [] xxoo=dt.asenumerable().select(d=>d.files<string>("a")).toarray();

就是这个意思了 手写的可能有错误...反正就是一句话就可以实现了