110,536
社区成员
发帖
与我相关
我的任务
分享如何在程序中使用聚合函数，比如MAX等。
我用的是 DataSet,SqlDataAdapter,DataTable
adapter.selectcommand.commandtext = "select max(userid) from sysuser";
adapter.fill(userDS,"sysuser");
userTable = userDS.Tables["sysuser"]
DataRow row = userTable.Rows[0];
int ret = (int)row["userid"];
无法取到值。
高手说话！！！
adapter.selectcommand.commandtext = "select max(userid) from sysuser";
adapter.fill(userDS,"sysuser");
userTable = userDS.Tables["sysuser"]
DataRow row = userTable.Rows[0];
int ret = (int)row["userid"];
无法取到值。
高手说话！！！
...全文
请发表友善的回复…
发表回复
zuolm1977 2003-08-19
- 打赏
- 举报
可是我用这个都实现了，怎么说不行呢
it's ok
it's ok
jjcccc 2003-08-19
- 打赏
- 举报
yes,i'm wrong.
saucer 2003-08-19
- 打赏
- 举报
adapter.selectcommand.commandtext = "select max(userid) as userid from sysuser";
adapter.fill(userDS,"sysuser");
userTable = userDS.Tables["sysuser"]
DataRow row = userTable.Rows[0];
int ret = (int)row["userid"];
it is bad, you should do
int ret = (int)command.ExecuteScalar();
adapter.fill(userDS,"sysuser");
userTable = userDS.Tables["sysuser"]
DataRow row = userTable.Rows[0];
int ret = (int)row["userid"];
it is bad, you should do
int ret = (int)command.ExecuteScalar();
saucer 2003-08-19
- 打赏
- 举报
adapter.selectcommand.commandtext = "select max(userid) as userid from sysuser";
adapter.fill(userDS,"sysuser");
userTable = userDS.Tables["sysuser"]
DataRow row = userTable.Rows[0];
int ret = (int)row["userid"];
it is bad, you should do
int ret = (int)command.ExecuteScalar();
adapter.fill(userDS,"sysuser");
userTable = userDS.Tables["sysuser"]
DataRow row = userTable.Rows[0];
int ret = (int)row["userid"];
it is bad, you should do
int ret = (int)command.ExecuteScalar();
jjcccc 2003-08-19
- 打赏
- 举报
like this:
adapter.selectcommand.commandtext = "select max(userid) as userid from sysuser";
adapter.fill(userDS,"sysuser");
userTable = userDS.Tables["sysuser"]
DataRow row = userTable.Rows[0];
int ret = (int)row["userid"];
ok?
adapter.selectcommand.commandtext = "select max(userid) as userid from sysuser";
adapter.fill(userDS,"sysuser");
userTable = userDS.Tables["sysuser"]
DataRow row = userTable.Rows[0];
int ret = (int)row["userid"];
ok?
saucer 2003-08-19
- 打赏
- 举报
adapter.selectcommand.commandtext = "select max(userid) as userid from sysuser";
adapter.fill(userDS,"sysuser");
userTable = userDS.Tables["sysuser"]
DataRow row = userTable.Rows[0];
int ret = (int)row["userid"];
it is bad, you should do
int ret = (int)command.ExecuteScalar();
adapter.fill(userDS,"sysuser");
userTable = userDS.Tables["sysuser"]
DataRow row = userTable.Rows[0];
int ret = (int)row["userid"];
it is bad, you should do
int ret = (int)command.ExecuteScalar();
