問題描述
我正在嘗試在我的網(wǎng)站上創(chuàng)建一個(gè)搜索文本框，而不是在提交時(shí)將字符串關(guān)鍵字"傳遞到我的網(wǎng)格中并提取該關(guān)鍵字的所有匹配記錄.
I'm trying to create a search text-box on my website than when submitted will pass the 'string-keyword' into my grid and pull all matching records for that keyword.
我必須使用 where 語句設(shè)置我的網(wǎng)格，該語句將偵聽"表單通過查詢字符串傳入的參數(shù).
I'm having to setup my grid with a where statement that will "listen" for parameters passed in by the form via query-string.
我不知道如何解決這個(gè)問題.任何見解、提示、示例表示贊賞.
I'm not sure how to approach this. Any insight, tips, examples appreciated.
更新-------這是我的網(wǎng)格用于填充記錄的查詢.除了城市/地區(qū)/國家之外，我還嘗試合并一個(gè)關(guān)鍵字搜索，它只會查看 BND_Listing 表中的公司"字段.
UPDATE------- This is the query my grid is using to populate records. In addition to City/Region/Country I'm trying to incorporate a keyword Search that would only look at my 'Company' Field inside the BND_Listing table.
select * FROM BND_listing right join BND_ListingCategories
on BND_Listing.CatID=BND_ListingCategories.CatID
where
(CategoryName = '[querystring:filter-Category]' or '[querystring:filter- Category]'='All')
and
(City = '[querystring:filter-City]' or '[querystring:filter-City]'='All')
and
(Region= '[querystring:filter-State]' or '[querystring:filter-State]'='All')
and
(Country= '[querystring:filter-Country]' or '[querystring:filter- Country]'='All')
and
isnull(Company,'') <> ''
ORDER by Company ASC
推薦答案
我不知道你說的監(jiān)聽"參數(shù)是什么意思，但因?yàn)槟阒挥?TSQL 標(biāo)記，匹配部分在 SQL Server 中是這樣實(shí)現(xiàn)的:
I don't know what you mean by "listen" for parameters, but since you only have TSQL tagged, the matching part in SQL Server is achieved like so:
DECLARE @param VARCHAR(256) --or what ever size you need
SET @param = 'some text'
SELECT SomeColumns
FROM SomeTable
WHERE aColumn LIKE '%' + @param + '%'
或者在 VB 中使用 SqlCommand 你可以查看:https://stackoverflow.com/a/251311/6167855
Or using SqlCommand in VB you can check out: https://stackoverflow.com/a/251311/6167855
這篇關(guān)于用于搜索“關(guān)鍵字"的表字段的 T-SQL 查詢的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！