sql = "select * from address where (name like = '%" + txtName.Text + "%' or '" + txtName.Text + "' = '' ) and (unit like = '%" + txtUnit.Text + "%' or '" + txtUnit.Text + "' = '' )"
解决方案 »
- WebPartZone中的verb小按钮为什么在浏览器里不显示?
- 论坛中点击回复后自动在标题文本框中显示回复****如何实现的?
- 如何简单得知datagridview当前单元格的行号与列号
- 150分求助,帮我改下以下CSS样式,希望能同时兼容IE6 IE7 FF浏览器的
- 对数据库进行写操作后 该返回bool还是void?
- ASP.NET基于角色的验证
- 请问DataSet能不能互相赋值?
- 调用图片局部内容
- 请问各位高手,如何在ASP.NET中捕捉页面关闭。
- DataGrid问题,点击Checkbox,选择该行(以其他颜色演示该行),一定给分
- 高分求 C#做的文件上传到WEB服务器下指定文件夹中源程序。(不够加分)
- 用户控件的状态维持问题,高手请进!
{
string sqlStr = "Select name,unit from address where name like '%" + txtName.Text + "%' and unit like '%" + txtUnit.Text + "%'";
}
else
{
string sqlStr = "Select name,unit from address where name like '%" + txtName.Text + "%' or unit like '%" + txtUnit.Text + "%'";
set @txtunit=txtUnit.text
select * from address where (name like '%' + @txtname + '%' and unit like +'%' + @txtunit+ '%'+ ) or (unit like +'%' + @txtunit+ '%'+ and @txtname = '' ) or (name like + '%' + @txtname+ '%'+ and @txtunit= '' )
你在数据库中没办法执行吧,因为你用了两个textbox了,库里没有:)
admire to death...
(
@Name varchar(50),
@Unit varchar(200)
)
as
select * from T_AddressList
where (([Name] like '@Name%' or [Name] is null) and (Unit like '@Unit%' or Unit is null))
GO