DENSMA
|
| Posted: 01/24/2005, 7:10 AM |
|
is there anyway to use SP With CCS. search page to pass in parameter and get result back on grid page?
i can do this with DW but dunno how to with CCS..
here my sp sample
i get this working with DW and not sure how to do it with CCS...
im using asp or asp.net
CREATE Procedure [R search]
(
@AgentID varchar(50) = Null,
@Supervisor varchar(50) = Null,
@Manager varchar(50) = Null
)
As
Select
* from reportas
Where
(@AgentID Is Null Or AgentID = @AgentID)
And (@Supervisor Is Null Or Supervisor = @Supervisor)
And (@Manager Is Null Or Manager = @Manager )
Order By AgentID Asc,Supervisor Asc
Return(@@RowCount)
GO
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 01/24/2005, 12:33 PM |
|
Yes, you can open the Data Source property of your grid and change "Table" to "Procedure" and enter your procedure name, then create a parameter for each of your SP/search parameters.
There is no need to modify the search form.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
|
