如何在visual basic中添加date（）参数作为aceess数据库 [英] How to add parameters of date() as aceess data base in visual basic

问题描述

我试图在日期参数上选择数据，但他通过空例外

plz。建议我从我的访问数据库中选择日期



我尝试过：

i am trying to select data on date parameters but he through empty exception
plz. suggest me to select date from my access database

What I have tried:

Private Sub MOD_SUB_DATa1()
      grp_invwise.Visible = False
      grp_datewise.Visible = False
      grp_partywise.Visible = False
      If MOD_SUB = 1 Then
          access.addparam("@INVNO", txt_mod_inv_start.Text)
            access.Execquery(" select INVOICE_NO,INVOICE_DATE,PARTY_NAME,INVOICE_AMOUNT_tax,IGST_TAX,CGST_TAX,SGST_TAX,sl_trancode,ID from invoice WHERE INVOICE_NO=@INVNO ")
          If noerrors(True) = False Then MsgBox(access.Exception) : Exit Sub
          dgv_sl.DataSource = access.dbdt

      End If
      If MOD_SUB = 2 Then
          access.addparam1("@INVNO", DateTimePicker1.Value)
          access.Execquery("select INVOICE_NO,INVOICE_DATE,PARTY_NAME,INVOICE_AMOUNT_tax,IGST_TAX,CGST_TAX,SGST_TAX,sl_trancode,ID from invoice WHERE INVOICE_DATE=@INVNO ")
          If noerrors(True) = False Then MsgBox(access.Exception) : Exit Sub
          dgv_sl.DataSource = access.dbdt
      End If
  End Sub

推荐答案

日期值不是 text ，所以：

Date values are not text, so:

access.addparam("@INVNO", txt_mod_inv_start.Value)

这篇关于如何在visual basic中添加date（）参数作为aceess数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！