存储过程代码是这样的
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[Queryuserinfo]
as
---通过ip或者最后登录日期查询用户登录所有信息
Declare @Filter varchar(max)
set @Filter='select a.UserID,a.RegAccounts,b.Score,b.InsureScore,(Score+InsureScore) as resut,a.LastLogonDate,a.LastLogonIP from
QPWapDB.[dbo].[My_Logon_Logoned] as a, QPTreasureDB.dbo.GameScoreInfo as bwhere 1=1 and ' + @where + '' Exec(@Filter)
里面只需要传入LastLogonIP ,LastLogonDate值就可以进行用户登录信息查询。
如何在页面里调用写代码实现查询功能列。页面有两个文本。一个GridView
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[Queryuserinfo]
as
---通过ip或者最后登录日期查询用户登录所有信息
Declare @Filter varchar(max)
set @Filter='select a.UserID,a.RegAccounts,b.Score,b.InsureScore,(Score+InsureScore) as resut,a.LastLogonDate,a.LastLogonIP from
QPWapDB.[dbo].[My_Logon_Logoned] as a, QPTreasureDB.dbo.GameScoreInfo as bwhere 1=1 and ' + @where + '' Exec(@Filter)
里面只需要传入LastLogonIP ,LastLogonDate值就可以进行用户登录信息查询。
如何在页面里调用写代码实现查询功能列。页面有两个文本。一个GridView
SqlCommand cmd=new SqlCommand("存储过程名",cn);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add("参数名","值");
SqlDataAdapter da=new SqlDataAdapter(cmd);
DataSet ds=new DataSet();
da.Fill(ds);类似这样子的,你自己看看吧
ALTER PROCEDURE [dbo].[Queryuserinfo]
@LastLogonIP nvarchar(20),
@LastLogonDate datetime
as
--构造查询语句,使用局部变量不用说吧
Declare @Filter varchar(max)
set @Filter='select a.UserID,a.RegAccounts,b.Score,b.InsureScore,(Score+InsureScore) as resut,a.LastLogonDate,a.LastLogonIP from
QPWapDB.[dbo].[My_Logon_Logoned] as a, QPTreasureDB.dbo.GameScoreInfo as bwhere 1=1 and ' + @where + ''Exec(@Filter)这一块能给我解说一下吧。 我觉得这Declare @Filter varchar(max)
没多大的意义
当然也可以不定义,直接exec('select .....')这里的代码构造的是select语句字符串,需要使用exec函数执行查询