I am using control parameters to filter my gridview, but they do not
work properly.  What I am trying to do is filter the gridview based upon
4 variables, and if any of the variables is not entered by the user, I
want it to default to 'all', so that all records for that variable will
show.

Here are my control parameters :

<SelectParameters>

<asp:ControlParameter Name="UserKey" ControlID="ddlUsers"
PropertyName="SelectedValue" Type="Int32" DefaultValue="All" />

<asp:ControlParameter Name="CompanyName" ControlID="txtCompanyName"
PropertyName="Text" Type="String" DefaultValue="" />

<asp:ControlParameter Name="PhoneNumber" ControlID="txtPhoneNumber"
PropertyName="Text" Type="String" DefaultValue="" />

<asp:ControlParameter Name="PostCode" ControlID="txtPostCode"
PropertyName="Text" Type="String" DefaultValue="" />

</SelectParameters>



And my stored procedure :

CREATE    PROCEDURE dbo.ViewCompanyList

@UserKey int ,
@CompanyName varchar(200),
@PhoneNumber varchar(20),
@PostCode varchar(20)

AS

select c.companysitekey as 'CompanySiteKey', isnull(c.sitename,'') as
sitename, isnull(c.[Name],'') as [name] ,
sum (case a.activitytypekey when 2 then 1 else 0 end) as
activity,isnull( u.username, '') as username ,
isnull(s.sectordescription,'') as sectordescription,
isnull(c.assigneduserkey,0) as
assigneduserkey,isnull(cast(c.lastammendeddate as varchar(20)), '') as
lastammendeddate
from companysite c with (nolock)

left join activity a with (nolock) on c.companysitekey = a.companykey
left join userlogin u with (nolock)on c.assigneduserkey = u.userkey
left join Sector s with(nolock) on c.sectorCode = s.sectorCode 
where
case @UserKey  when '0'  then @UserKey  else c.assigneduserkey  end =
@UserKey and
case @CompanyName  when '' then @CompanyName  else c.[name]   end like
'%' + @CompanyName + '%' and
case @PhoneNumber  when '' then @PhoneNumber  else c.tel   end like '%'
+ @PhoneNumber + '%' and
case @PostCode when '' then @PostCode else c.PostCode end like '%' +
@PostCode + '%'

group by  c.companysitekey , c.sitename  , c.[Name] ,  u.username,
s.sectorDescription, c.assigneduserkey, c.lastAmmendeddate
order by c.[name]



Any help would be much appreciated.



Regards,

Mike




*** Sent via Developersdex http://www.developersdex.com ***

.Net 2 SerialPort Class Questions
How should a Windows Service stop itself?
Message based approach
FileShare parameter in filestream creation
Can you verify AppDomain when assemly loads?