如何将查询结果填入数据表 [英] how to fill query result into data table

问题描述

我有这个查询，我想在数据表中填写结果

i have this query that i want to fill its result in a data table

Dim datenow As Date = Date.Now.Date

        Dim sql As String = "SELECT DISTINCT cmp_user_id FROM tbl_campaign WHERE cmp_date =#" & datenow & "#"

i使用此方法将其填入数据表：

i use this method to fill it in a data table :

Public Shared Function ExecuteSelect(ByVal query As String) As DataTable
      Dim xx As DataTable = New DataTable()
      Using a1 As New OleDbDataAdapter(query, ConnectionString)
          a1.Fill(xx)
      End Using
      Return xx
  End Function

我怎么能修复查询或方法来填充数据表所以我可以使用单独返回的每个数据谢谢

how could i fix the query or the method to fill the datatable so i could use each data returned alone thanks

推荐答案

您好



您的查询字符串有问题请更改您的查询：

Hi

You have a problem in your query string please change your query:

Dim datenow As Date = Date.Now.Date
 
        Dim sql As String = "SELECT DISTINCT cmp_user_id FROM tbl_campaign WHERE cmp_date =#" & datenow.ToString() & "#"

但我建议您检查数据库中的cmp_date数据类型，并确保在检查此字段的格式后是否为DateTime，例如，如果数据库中的cmp_date字段格式为dd / mm / yyyy 你也应该在你的datenow变量上设置这种格式;）





最好的问候。

But I suggestion to you check the cmp_date data type from your database and be sure it is a DateTime after you should check the format of this field, for example if your cmp_date fields format at database is "dd/mm/yyyy" you should set this format on your datenow variable too ;)


Best Regards.

这篇关于如何将查询结果填入数据表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！