如何搜索值Ndb? [英] How Do I Search The Values Ndb?
本文介绍了如何搜索值Ndb?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的aspx包含如下:
来自日期:至今:
名称:
客户ID:
提交
即使我只输入一个字段值,它也会搜索数据库中的值并获取表格中的所有值。
i像这样编写SP
创建 procedure credits_search
(
@ date1 date , @ date2 date , @ client_id varchar (< span class =code-digit> 50 ), @ name varchar ( 50 )
)
as
开始
选择 * 来自 credits 其中 date < span class =code-sdkkeyword> @ date1 和 @ date2 或 client_id 喜欢 @ client_id 或名称喜欢 @ name
结束
请帮助我......
解决方案
可能需要查看@name和@client_id值,只有在非空或空字符串时才使用它们。
查看IS NOT NULL http://www.w3schools.com/sql/sql_null_values.asp [ ^ ]它可能会有帮助。
我想你想在所有文本字段与数据库值匹配时得到结果。
用以下方法更改程序。
创建 procedure credits_search
(
@ date1 date , @ date2 date , @ client_id varchar ( 50 ), @name varchar ( 50 )
)
< span class =code-keyword> as
begin
select * 来自 credits 其中 date @ date1 和 @ date2 和 client_id like @ client_id 和 name 喜欢 @ name
end
试试这样希望这会对你有所帮助。
创建 过程 credits_search
(
@ date1 < span class =code-keyword>日期,
@ date2 日期 ,
@ client_id varc har ( 50 ),
@ name varchar ( 50 )
)
As
BEGIN
SELECT * FROM
credit
WHERE date 介于 @ date1 和 @ date2
AND client_id 喜欢 ' %' + @ client_id
AND name like ' %' + @ name
END 跨度>
my aspx contains like this:
from Date: To Date:
Name:
Client Id:
Submit
even i enter only one field values also it searches the value in DB and get the all values in table.
i write the SP as like this
create procedure credits_search
(
@date1 date,@date2 date,@client_id varchar(50),@name varchar(50)
)
as
begin
select * from credits where date between @date1 and @date2 or client_id like @client_id or name like @name
end
pls help me......
解决方案
Probably, you need to look at the @name and @client_id values and only use them if they are non null or empty strings.
Look at IS NOT NULL http://www.w3schools.com/sql/sql_null_values.asp[^] and it may help.
I guess you want to get the result when all text fields matches with database value.
Change the procedure with below.
create procedure credits_search ( @date1 date,@date2 date,@client_id varchar(50),@name varchar(50) ) as begin select * from credits where date between @date1 and @date2 and client_id like @client_id and name like @name end
Try like this hope this will help you.
create procedure credits_search ( @date1 Date, @date2 Date, @client_id varchar(50), @name varchar(50) ) As BEGIN SELECT * FROM credits WHERE date between @date1 and @date2 AND client_id like '%' + @client_id AND name like '%' + @name END
这篇关于如何搜索值Ndb?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文