如何使用wpf从ms访问/数据库中获取特定列值？ [英] how to get a particular column values from ms access/database using wpf?

问题描述

你好朋友，



这里我在我的项目REMAINDER活动中做了，所以如果剩余日期是今天意味着它应该显示在我写的标签中在下面的代码中。



请帮我解决如何在今天的日期与特定用户名的剩余日期之间进行检索和匹配。

hello friends,

here i did in my project "REMAINDER" event, so if the remainder date is today means it should display in a label which i wrote in below code.

please help me out how to retrive and match the todays date with remainders date on a particular username.

public void rdisplay()
            {
               
                cmdd = new OleDbCommand("select * from Remainder where [rusername]='" + loginusername + "'", conn);
                conn.Open();
                cmdd.ExecuteNonQuery();
                OleDbDataAdapter da = new OleDbDataAdapter(cmdd);

                da.Fill(ds); 
                

                conn.Close();


   [here its getting error in below var rrow and string remdate  please help me !]
   
             var rrow = ds.Tables[0].Select("[date]");
                string remdate = dt.Rows[0]["date"].ToString();


                DateTime now = DateTime.Now;
                string rnow = "dd/MM/yyyy";
                var rvar = (now.ToString(rnow));

                string rnow2 = "MM/dd/yyyy";
                var rvar2 = (now.ToString(rnow2));
                if (remdate == rvar)
                {
                    lblremdisplay.Content = "Remainder :-" + dt.Rows[0]["your remainder"].ToString() + "";
                }
                else if (remdate == rvar2)
                {
                    lblremdisplay.Content = "Remainder :-" + dt.Rows[0]["your remainder"].ToString() + "";
                }
                else
                {
                    lblremdisplay.Content = "";
                }

谢谢你。

thank u .

推荐答案

如果你想要从任何特定日期的数据库中获取值，您的 OleDbCommand 应如下所示：

If you would like to fetch values from database for any particular day, your OleDbCommand should looks like:

cmdd = new OleDbCommand("select * from Remainder where [remainderdate]=#" + @yourdate + "#", conn);

其中 @yourdate 今天是iso格式： MM / dd / yyyy



今天使用：

Where @yourdate is today in iso format: MM/dd/yyyy

For today, use:

select *
from Remainder
where [remainderdate]=#Date()#

Date（）函数 [ ^ ]



日期：

Date() function[^]

For set of dates:

select *
from Remainder
where [remainderdate] BETWEEN #03/01/2014# AND #04/01/2014#

BETWEEN ... AND ... [ ^ ]

这篇关于如何使用wpf从ms访问/数据库中获取特定列值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！