如何获取当前日期。 [英] How to fetch current date.

问题描述

我尝试但是这个错误显示

i try but this error show

Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

我尝试过：

What I have tried:

cmd = new OleDbCommand("SELECT InvoiceNo,p_custname,payment_date,FinalTotal,P_totalpayment,P_paymentdue,Reminder_Date from Payment where Reminder_Date ='" + System.DateTime.Now + "'", con);

推荐答案

不要连接字符串来构建SQL命令。它让您对意外或故意的SQL注入攻击持开放态度，这可能会破坏您的整个数据库。请改用参数化查询。

Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead.

using (cmd = new OleDbCommand("SELECT InvoiceNo,p_custname,payment_date,FinalTotal,P_totalpayment,P_paymentdue,Reminder_Date from Payment where Reminder_Date = @DT, con))
   {
   cmd.Parameters.AddWithValue("@DT", System.DateTime.Now);
   ...
   }

你的问题也会消失...

And you problem will also disappear...

这篇关于如何获取当前日期。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！