SqlCommand cmd5 = new SqlCommand("Select * from StuInfo where stuXueyuan like '%" + txt_select.Text + "%' or stuName like '%"
+ txt_select.Text + "%' or stuID like '%" + txt_select.Text + "%' or stuMajor like '%" + txt_select.Text + "%' or stuSex like '%" + txt_select.Text + "%' or stuPhone like '%" + txt_select.Text + "%'", conn);SQL关键间注意空格
+ txt_select.Text + "%' or stuID like '%" + txt_select.Text + "%' or stuMajor like '%" + txt_select.Text + "%' or stuSex like '%" + txt_select.Text + "%' or stuPhone like '%" + txt_select.Text + "%'", conn);SQL关键间注意空格
解决方案 »
- ObjectStateManager 中已存在具有同一键的对象。现有对象处于 Modified 状态。只有在该对象处于 added 状态后,才能再次将它添加到
- OA系统 如果用户10分钟不刷新页面就让他掉线
- clientscript.getwebresouce中CSS中含有图片引用
- 同一网站下多个项目共用Session的情况(两个项目不是统一解决方案),有没有可能,应该怎么做
- return 之后的语句还会不会执行?
- 刚学asp.net的初级问题。
- QQ菜单实现!要求菜单项从数据库里面读出来!谢谢!
- 咨询:企业建立自己的门户网站要做哪些工作?
- 大家帮我看看我这样写一个连数据库得类有问题吗?
- 请看看这种功能如何实现?
- 急! 报表中嵌套子报表,如何传递参数到子报表中
- asp.net
1. 先把 sql查询语句 写到一个临时的text中
2. 看看有没有问题
3. 看不出来的话 最好用sqlServer执行看看行不行
String keyWord=txt_select.Text;
String sql="select count(*) from StuInfo where stuXueyuan like '%" +keyWord+ "%' or stuName like '%"+keyWord+"%';
stuXueyuan,这种变量最好不要有,换成stuDepart
给你个存储过程set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go--[gjss] 10,20,'a','','','','','',''ALTER procedure [dbo].[gjss]
(
@startIndex int=1,
@endIndex int=3286,
@ProductName varchar(100)=NULL,
@Inputer varchar(50)=NULL,
@ProductStandard varchar(100)=NULL,
@PriceOriginal varchar(20)=NULL,
@ISBN varchar(20)=NULL,
@CreateTimeStart varchar(20)=NULL,
@CreateTimeEnd varchar(20)=NULL,
@PrintNO varchar(20)=NULL,
@VersionNO varchar(20)=NULL
)
as
SET NOCOUNT ON
begin
declare @start int
declare @end int
declare @SqlWhere varchar(500)
declare @strSql varchar(1000)
declare @strSql1 varchar(1000)set @start= @startIndex * @endIndex
set @end =@start+@endIndex
set @SqlWhere=' where 1=1 '
if @PrintNO<>''
begin
set @SqlWhere=@SqlWhere+' and PrintNO = '''+@PrintNO+''''
end
if @VersionNO<>''
begin
set @SqlWhere=@SqlWhere+' and VersionNO = '''+@VersionNO+''''
end
if @ProductName<>''
begin
set @SqlWhere=@SqlWhere+' and ProductName like ''%'+@ProductName+'%'''
end
if @Inputer<>''
begin
set @SqlWhere=@SqlWhere+' and Inputer like ''%'+@Inputer+'%'''
end
if @ProductStandard<>''
begin
set @SqlWhere=@SqlWhere+' and ProductStandard like ''%'+@ProductStandard+'%'''
end
if @PriceOriginal<>''
begin
set @SqlWhere=@SqlWhere+' and PriceOriginal like ''%'+@PriceOriginal+'%'''
end
if @ISBN<>''
begin
set @SqlWhere=@SqlWhere+' and ISBN = '''+@ISBN+''''
end
if @CreateTimeStart <>''
begin
set @SqlWhere=@SqlWhere+' and CreateTime >= '''+@CreateTimeStart+''''
end
if @CreateTimeEnd <>''
begin
set @SqlWhere=@SqlWhere+' and CreateTime <= '''+@CreateTimeStart+''''
end
set @strSql='select temptbl.* from ( SELECT ROW_NUMBER() OVER (ORDER BY productId asc)AS Row,*
from My_Products '
set @strSql1=') as temptbl where temptbl.Row > '+cast(@start as varchar(10)) +' and temptbl.Row<='+cast(@end as varchar(10))
set @strSql=@strSql+@SqlWhere+@strSql1
exec(@strSql)
print @strSqlset @strSql='select count(productId) from My_Products '+@SqlWhere
exec(@strSql)
print @strSql
end
public DataTable GetShuji(string text)
{ string sql = "select * from dbo.View_1 where Title like @title";
List<SqlParameter> list = new List<SqlParameter>();
SqlParameter sp = new SqlParameter("@title",SqlDbType.VarChar);
sp.Value = "%" + text + "%";
list.Add(sp);
DataSet ds = server.GetResult(sql, list);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
return ds.Tables[0];
}
else
{
return null;
}
}