如何编写过滤查询? [英] How to write the query for filtration ?

问题描述

我需要一些帮助

我有这个查询

I need some help

I have this query

SELECT AdvertiseNames.AdvertiseName, AdvertiseNames.Salary, AdvertiseNames.Telephone, EstateTypes.EstateName
FROM  AdvertiseNames INNER JOIN
               EstateTypes ON AdvertiseNames.EstateId = EstateTypes.EstateId

它显示所有行，但我不想显示所有行，因为我有下拉列表，我只想显示与我从下拉列表中选择的值相关的行
看起来像过滤将是什么代码????

and it shows all the rows but I don''t want to show all rows ,,,as I have dropdownlist I want to show only the rows which related to what the value I selected from dropdownlist
it looks like filtration what the code will be ????

推荐答案

例如，要过滤带有AdvertiseNames.AdvertiseName的数据，您可以使用以下代码:

To filter the data for example with AdvertiseNames.AdvertiseName you could have something like:

SELECT AdvertiseNames.AdvertiseName, AdvertiseNames.Salary, AdvertiseNames.Telephone, EstateTypes.EstateName
FROM  AdvertiseNames INNER JOIN
               EstateTypes ON AdvertiseNames.EstateId = EstateTypes.EstateId
WHERE AdvertiseNames.AdvertiseName = @advertisename

@advertisename在您的应用程序中定义为SqlParameter，请参见: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlparameter.aspx [

The @advertisename is defined as a SqlParameter in your application, see: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlparameter.aspx[^]

您可以使用像这样的简单查询

SELECT Ad.AdvertiseName，Ad.Salary，Ad.Telephone，Es.EstateName
FROM AdvertiseNames广告，EstateType Es
WHERE Ad.EstateId = Es.EstateId

you can use simple query like this

SELECT Ad.AdvertiseName, Ad.Salary, Ad.Telephone, Es.EstateName
FROM AdvertiseNames Ad, EstateType Es
WHERE Ad.EstateId = Es.EstateId

这篇关于如何编写过滤查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！