Loading

How to select only those rows from access database table with date from the current year

Nel

Hello,

Can anybody help me please how to select only those rows from the table which have current yera for date.year?

oleDbAd2.SelectCommand.CommandText = "SELECT Brdog, Datadog, Bravtobusi, VkiznosbezDDVDen,Vaznost from Dogovor where Datadog=?";

oleDbAd2.SelectCommand.Parameters.Add("@Datadog", DateTime.Now.Year ); //I don't know how to write thic line

Thanks in advance.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
Try:

oleDbAd2.SelectCommand.CommandText = "SELECT Brdog, Datadog, Bravtobusi, VkiznosbezDDVDen,Vaznost from Dogovor where Year(Datadog) = ?";

oleDbAd2.SelectCommand.Parameters.Add("@Datadog", OleDbType.Int).Value = DateTime.Now.Year;

EDIT: Pravin beat me to it - but basically same answer :)
0
Nel14y ago
Thank you:)
0
Pravin Ghadge14y ago
hi,

oleDbAd2.SelectCommand.CommandText = "SELECT Brdog, Datadog, Bravtobusi, VkiznosbezDDVDen,Vaznost from Dogovor where Year(Datadog)=?";

oleDbAd2.SelectCommand.Parameters.Add("@Datadog", DateTime.Now.Year ); //I
0