无法从查询中获取记录 [英] Not getting the records from query

问题描述

亲爱的所有人，

我正在尝试将日期从数据表导出到Excel.但是我没有记录.

这是我传递值的地方:

Dear all,

I am trying to export the date from datatable to excel. But i am not getting the records.

This is where i am passing the values:

Dim cons As String = My.Settings.DBRestroConnectionString

Dim rdate As String = Format(DateTimePicker1.Value, "dd-MM-yyyy")

st = "SELECT BillMaster_1.Date, BillMaster_1.BillNo, BillMaster_1.TableNo, BillMaster_1.WaiterNo,  BillMaster_1.CoverNo, BillMaster_1.BillAmount, PayModeMaster.PayMode, (SELECT SUM(BillAmount) AS TotalAmount FROM BillMaster) AS 'Total' FROM BillMaster AS BillMaster_1 LEFT OUTER JOIN PayModeMaster ON BillMaster_1.PaidMode = PayModeMaster.PayModeId"

FN = "BillSummary"

moh = valq.excelexport(cons, st, FN, "BillMaster_1.Date", rdate)

功能:

function:

Dim Xlapp As New Microsoft.Office.Interop.Excel.Application
       Dim TOTALcount As Integer
       ' Dim DT As Date
       Dim sqlcon As New SqlConnection(constr)
       Dim sqlcommd As New SqlCommand
       sqlcommd.Connection = sqlcon
       sqlcommd.CommandText = sqlstr + " where " + filter >= +"@x"
       sqlcommd.Parameters.AddWithValue("@x", para)
       'sqlcommd.Parameters.AddWithValue("Date", DT)
       Dim sqlda As New SqlDataAdapter(sqlcommd)
       Dim sqldt As New DataTable
       sqlda.Fill(sqldt)
       TOTALcount = sqldt.Rows.Count
       If sqldt.Rows.Count > 0 Then

我每次都得到零记录.

问候，
Mohinder Singh

I am getting zero records everytime.

Regards,
Mohinder Singh

推荐答案

删除联接并查看会发生什么.

p.s.您的查询包含一些不需要的字符.在点击发布之前，使用预览按钮.

问候
塞巴斯蒂安

Remove the join and see what happens.

p.s. Your query has some unwanted characters. Use Preview button before hit Post.

Regards
Sebastian

这篇关于无法从查询中获取记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！