一列
列A
aaa-1
aaa-1
aaa-2
aaa-2
aaa-3
aaa-3 查询总数
select count(A) from (select distinct A from table);总数为3
然后怎样循环查出这三项的值?
列A
aaa-1
aaa-1
aaa-2
aaa-2
aaa-3
aaa-3 查询总数
select count(A) from (select distinct A from table);总数为3
然后怎样循环查出这三项的值?
select distinct A from table
for (int i = 0; i < x; i++)
{
在这里面循环显示出这三项的值
}这样应该怎样做?
group by A
把查出来的结果给DataSet
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string strA=ds.Tables[0].Rows[i]["A"].ToString();
}
for (int i = 0; i < DataTable.Rows.Count; i++)
{
MessageBox.Show(DataTable.Row[i]["A"].ToString())
}
或
for (int i = 0; i < DataSet.Tables[0].Rows.Count; i++)
{
MessageBox.Show(DataSet.Tables[0].Row[i]["A"].ToString())
}