Visual Studio预览数据不显示任何数据 [英] Visual Studio Preview Data shows no data

问题描述

我正在使用数据集而我有几个数据表，它们工作正常。并决定添加一个新的。我添加了它并在vs中的查询构建器中运行了sql查询，它运行良好的返回数据。但是它没有在我的网页中返回数据。所以我试着运行"预览数据" vs中的工具，它也没有返回数据，也没有错误（它只是空的）。这是代码：

SELECT DISTINCT c.Computer_Idn，c.DeviceName，c.LoginName，c.FullName，osu.UpdateName，osu.Publisher，osu.InstallDate
FROM dbo.OSUpdates AS osu INNER JOIN
dbo.Computer AS c ON osu.Computer_Idn = c.Computer_Idn
WHERE（osu.UpdateName LIKE @Patch）

I am using a dataset in vs. I have several datatables, which are working fine. And had decided to add a new one. I added it and ran the sql query in the query builder in vs and it ran fine returning data. However it was not returning data in my web page. So I tried running the "Preview Data" tool within vs and it also returns no data there and no error either (its just empty). Here's the code:

SELECT DISTINCT c.Computer_Idn, c.DeviceName, c.LoginName, c.FullName, osu.UpdateName, osu.Publisher, osu.InstallDate
FROM         dbo.OSUpdates AS osu INNER JOIN
                      dbo.Computer AS c ON osu.Computer_Idn = c.Computer_Idn
WHERE     (osu.UpdateName LIKE @Patch)

推荐答案

您是否为参数提供了价值？
您能否发布调用sql语法的代码？

感谢

Are you supplying value for the parameter?
Can you please post the code that calls the sql syntax?

Thanks

这篇关于Visual Studio预览数据不显示任何数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！