winform中怎样通过DataGridView读取整列数据(高手请进)
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();
请问有没有好的办法实现从数据库中读取整列的值存进数组里面呀,这个读取的和实际数据库里面的数据不一样,总会有重复的
各位提建议可以完全抛开上面的这个思路
先多谢啦!
------解决方案--------------------在查的时候把重复的去掉
string strselect = "select distinct Name from Document";
------解决方案--------------------读取整列 hashtable 吧 hashtable[列名] = 值 用foreach 读
------解决方案--------------------this.dataGridView2.SelectedCells[5].Value.ToString();
这样就可以读取了啊
------解决方案--------------------DataRowView row = this.m_DataSet.Tables[0].DefaultView[this.dataGridView.CurrentRow.Index];
------解决方案--------------------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();
------解决方案--------------------string strselect = "select distinct Name from Document";
datagridview 的话只有循环了