winform中怎样通过DataGridView读取整列数据（高手请进）

[bianchenglangzi_110]

string strselect = "select Name from Document";
OleDbConnection conn = null;
OleDbCommand cmd = null;
try
{
conn = DB.Createconnection();
conn.Open();
cmd = new OleDbCommand(strselect, conn);
OleDbDataReader sdr = cmd.ExecuteReader();
System.Collections.ArrayList list = new System.Collections.ArrayList();
while (sdr.Read())
{
if (!sdr.IsDBNull(sdr.GetOrdinal("Name")))
{
list.Add(sdr.GetValue(sdr.GetOrdinal("Name")));
}
}
sdr.Close();
请问有没有好的办法实现从数据库中读取整列的值存进数组里面呀，这个读取的和实际数据库里面的数据不一样，总会有重复的
各位提建议可以完全抛开上面的这个思路
先多谢啦！

[bianchenglangzi_110]

string strselect = "select DocID,Name,CarID,JoinDate from Document";
OleDbConnection conn = DB.Createconnection();
OleDbDataAdapter ada = new OleDbDataAdapter(strselect, conn);
DataSet ds = new DataSet();
ada.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count;i++ )
{
System.Collections.ArrayList list = new System.Collections.ArrayList();
list.Add(ds.Tables[0].Rows[i]["JoinDate"].ToString());
}
为方便后来者自己贴出来吧

[TZB天天]

在查的时候把重复的去掉
string strselect = "select distinct Name from Document";

[SlaughtChen]

读取整列 hashtable 吧 hashtable[列名] = 值 用foreach 读

[tanxiaolin520]

this.dataGridView2.SelectedCells[5].Value.ToString();

这样就可以读取了啊

[david_anwei]

DataRowView row = this.m_DataSet.Tables[0].DefaultView[this.dataGridView.CurrentRow.Index];

[路人乙e]

string strselect = "select distinct Name from Document";
OleDbConnection conn = null;
OleDbCommand cmd = null;
try
{
conn = DB.Createconnection();
conn.Open();
cmd = new OleDbCommand(strselect, conn);
OleDbDataReader sdr = cmd.ExecuteReader();
System.Collections.ArrayList list = new System.Collections.ArrayList();
while (sdr.Read())
{
list.Add(sdr["Name"]);
}
sdr.Close();

[Cherishny]

string strselect = "select distinct Name from Document";
datagridview 的话只有循环了