如何从msaccess db获取最后一行值? [英] how to get the last row values from msaccess db ?
本文介绍了如何从msaccess db获取最后一行值?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
你好朋友,
这里我在msaccess表中插入了多行,所以我需要检索列的最后一行详情请帮帮我。
这里我完成了这个代码
即将重新访问最后一次登录详细信息。
在我的表格中:
col 1 = ID ,
col 2 =用户名,
col 3 =登录,
col 4 = logut。
这里应该获得登录和注销,最后一栏的详细信息在用户名的帮助下。
cmdd = new OleDbCommand(select * from logindetails where [lusername] ='+ loginusername +',conn);
conn.Open();
cmdd.ExecuteNonQuery();
OleDbDataAdapter da = new OleDbDataAdapter(cmdd);
da.Fill(dt);
lbllogin.Content = dt.Rows [0] [login]。ToString();
lbllogout.Content = dt.Rows [0] [logout]。ToString();
请帮帮我。
谢谢你提前。
解决方案
这是一个基本的想法,请继续努力。 />
选择 top ( 1 )*,max(登录) as LastLogintime from logindetails 其中 [lusername] = ' + loginusername +'
从logindetails中选择top(1)*,其中[lusername] ='+ loginusername +'按ID排序desc
NBwhere ID是你的PK。选择最后一条记录作为前1,降序
谢谢各位朋友,建议我..
i解决了我的自我
i在第二排获得了计数-2;
这里是代码:
cmdd =新的OleDbCommand(select * from logindetails where [lusername] ='+ loginusername +',conn);
conn.Open();
cmdd.ExecuteNonQuery();
OleDbDataAdapter da = new OleDbDataAdapter(cmdd);
da.Fill(dt);
da.Fill(ds);
int i;
for(i = 0; i< = dt.Rows.Count-2; i ++)
{
lbllogin.Content = dt.Rows [i] [login ]的ToString();
lbllogout.Content = dt.Rows [i] [logout]。ToString();
}
conn.Close();
:)
hello friends ,
here i inserted the multiple rows in msaccess table, so i need to retrive the last rows of column details , please help me out .
here i done with this code
which im retriving the last logindetails.
in my table :
col 1= ID,
col 2= username,
col 3=login,
col 4=logut.
here is should get the login and logout ,last column details with the help of username.
cmdd = new OleDbCommand("select * from logindetails where [lusername]='" + loginusername + "'", conn); conn.Open(); cmdd.ExecuteNonQuery(); OleDbDataAdapter da = new OleDbDataAdapter(cmdd); da.Fill(dt); lbllogin.Content=dt.Rows[0]["login"].ToString(); lbllogout.Content = dt.Rows[0]["logout"].ToString();
please help me out.
thank u in advance.
解决方案
Hi,
This is a basic idea please work on it.
select top(1) *,max(login) as LastLogintime from logindetails where [lusername]='" + loginusername + "'"
select top(1) * from logindetails where [lusername]='" + loginusername + "'" order by ID desc N.B.where ID is your PK. Select last record as top 1 with descending order
thank you friends , for suggesting me ..
i solved my self
i retrived last second row by taking count-2;
here is the code :
cmdd = new OleDbCommand("select * from logindetails where [lusername]='" + loginusername + "'", conn); conn.Open(); cmdd.ExecuteNonQuery(); OleDbDataAdapter da = new OleDbDataAdapter(cmdd); da.Fill(dt); da.Fill(ds); int i; for ( i = 0; i <= dt.Rows.Count-2;i++ ) { lbllogin.Content = dt.Rows[i]["login"].ToString(); lbllogout.Content = dt.Rows[i]["logout"].ToString(); } conn.Close();
:)
这篇关于如何从msaccess db获取最后一行值?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文