从datatable中查询

[SL0413]

怎么从DATATABLE中查询ID最小长度



例如ID的值为 1001,1002,100101,10010101

那么就返回４即１００１的长度

[zhiguo2008]

学习

[marvelstack]

看这里，
http://topic.csdn.net/u/20080408/22/5c0909df-1502-4ebe-9f97-f9398372affa.html

[chinaicm]

string minValue = dt.Compute("min(ID)","");

[xhlin]

select min(length(FNumber)) from T_GL_USER
cong shu ju ku zhi jie cha

[SL0413]

只有个DataTable，不能从数据库查，可以吗？

[lovefootball]

加个计算列，然后按照计算列排序

DataColumn dc2 = new DataColumn();
dc2.DataType = System.Type.GetType("System.Int32");
dc2.Caption = "LengthColumn";
dc2.ColumnName = "LengthColumn";
dc2.Expression = "len(id)";

[suyiming]

good

mark

[zzyhuian06142]

[Quote=引用 5 楼 lovefootball 的回复:]
加个计算列，然后按照计算列排序


C# code
DataColumn dc2 = new DataColumn();
dc2.DataType = System.Type.GetType("System.Int32");
dc2.Caption = "LengthColumn";
dc2.ColumnName = "LengthColumn";
dc2.Expression = "len(id)";
[/Quote]

[new_Stone]

DataTable中有个过滤器

[mainbaby]

     Dim len As Integer = dt.Compute("Min(Len(ID))", "")
     Dim minID As String = dt.Compute("Min(ID)", "Len(ID)=" & len)

没测试过,不行勿怪。

[fayxue]

[Quote=引用 2 楼 xhlin 的回复:]
select min(length(FNumber)) from T_GL_USER
cong shu ju ku zhi jie cha
[/Quote]

[qjlsharp]

还帮不了你,帮顶,学习

[ZGZice]

[Quote=引用 5 楼 lovefootball 的回复:]
加个计算列，然后按照计算列排序


C# code
DataColumn dc2 = new DataColumn();
dc2.DataType = System.Type.GetType("System.Int32");
dc2.Caption = "LengthColumn";
dc2.ColumnName = "LengthColumn";
dc2.Expression = "len(id)";
[/Quote]

[ZGZice]

学习

[lf44785170]

把分给我吧,我刚研究出来,也是刚学不久,没分用了,我使用的是 VS2008

var rr =datatable1.AsEnumerable().Min(tt => tt.Field<string>("ID").Length);
MessageBox.Show(rr.ToString());