查询最小数据所在行

[simen_frankly]

现有一个datatable，有5*5，先查询这25个数据中最小数据所在行，该如何实现？谢谢~

[simen_frankly]

SOS~~~

[lijunfeng]

就把它当成个二维数组然后按行列遍历啊

[Sphonix]

int nCount = datatable.count;
double dNumber = 0.0;
int nIndex = -1;
for( int i=0; i<nCount-1; i++ )
{
dNumber = datatable[i];
nIndex = 0;
for( int j=1; j<nCount; j++ )
{
double dTemp = datatable[i];
if( dNumber < dTemp )
{
dNumber = dTemp;
nIndex = j;
}
}
}
return nIndex;

[yiyiwyy326]

大概意思：

int[] minnum=new int[]{0,0,0,0,0};
            for (int i = 0; i < datatable.Rows.Count; i++)
            {
                for(int j=0;j>datatable.Columns.Count-1;j++)
                {
                    if (Convert.ToInt32(datatable.Rows[i][j]) > Convert.ToInt32(datatable.Rows[i][j + 1]))
                    {
                        minnum[i] = Convert.ToInt32(datatable.Rows[i][j + 1]);
                    }
                    else
                    {
                        minnum[i] = Convert.ToInt32(datatable.Rows[i][j]);
                    }
                }
            }
            int min = 0;
            for (int i = 0; i < minnum.Length-1; i++)
            {
                if (minnum[i] > minnum[i + 1])
                {
                    min = i + 1;
                }
                else
                {
                    min = i;
                }
            }

[claymore1114]

[Quote=引用 2 楼 lijunfeng 的回复:]
就把它当成个二维数组然后按行列遍历啊
[/Quote]
遍历 一下

[chtsir]

分三步:
1.临时表,取出每列的最小值
CREATE TABLE #test(
amount int null

)

2.把每列的最小值插入临时表:
insert into #test
select min(a) from dbo.t_int
union select min(b) from dbo.t_int
union select min(c) from dbo.t_int
union select min(d) from dbo.t_int
union select min(e) from dbo.t_int

3.从临时表里取出最小值
select min(amount) from #test

[chtsir]

错拉,理解错拉,不好意思

[GabrielCNMao]

[Quote=引用 2 楼 lijunfeng 的回复:]
就把它当成个二维数组然后按行列遍历啊
[/Quote]
11111

[bbbbbb888888]

2次循环,遍历.很基础的问题.

[zhoujk]

1次遍历数据即可
1.声明两个变量，int Min = 65536, MinLine = 0;
2.遍历，如果当前值比 Min 小，则 Min = 当前值， MinLine = 当前行

[liningln0]

[Quote=引用 3 楼 Sphonix 的回复:]
int nCount = datatable.count;
double dNumber = 0.0;
int nIndex = -1;
for( int i=0; i <nCount-1; i++ )
{
dNumber = datatable[i];
nIndex = 0;
for( int j=1; j <nCount; j++ )
{
double dTemp = datatable[i];
if( dNumber < dTemp )
{
dNumber = dTemp;
nIndex = j;
}
}
}

正确
return nIndex;
[/Quote]

[Hertz_liu]

[Quote=引用 2 楼 lijunfeng 的回复:]
就把它当成个二维数组然后按行列遍历啊
[/Quote]
二楼正解

[zzyhuian06142]

1：
select 列,identity(int,1,1) as index into #Temp from 表
2：
select index,min(列) from #Temp

[birdlonger]

依旧mark!