Click here to Skip to main content
15,881,559 members
Home / Discussions / C#
   

C#

 
QuestionHow can we delegate an array Pin
Fred 3413-Apr-12 2:06
Fred 3413-Apr-12 2:06 
AnswerRe: How can we delegate an array Pin
V.13-Apr-12 2:31
professionalV.13-Apr-12 2:31 
GeneralRe: How can we delegate an array Pin
Fred 3413-Apr-12 3:44
Fred 3413-Apr-12 3:44 
GeneralRe: How can we delegate an array Pin
V.13-Apr-12 3:46
professionalV.13-Apr-12 3:46 
QuestionCorrectly Disposing of MDI Child Forms. Pin
cjb11013-Apr-12 0:29
cjb11013-Apr-12 0:29 
AnswerRe: Correctly Disposing of MDI Child Forms. Pin
BobJanova13-Apr-12 2:37
BobJanova13-Apr-12 2:37 
GeneralRe: Correctly Disposing of MDI Child Forms. Pin
cjb11015-Apr-12 21:51
cjb11015-Apr-12 21:51 
QuestionPaging in SQL Pin
Billa212-Apr-12 20:41
Billa212-Apr-12 20:41 
This is my Stored Procedure i want to implement paging where i will get the page size as a parameter from UI..How do i implement paging in this query


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go



-- =============================================
-- Author: <ragesh nair="">
-- Create date: <11/04/2012>
-- Description: <search>
-- =============================================
--exec iSRPDb_Sp_Search_WO 1,0,'0','T',10,1
--select * from tblProject where ProjectID=13849
--select * from tblProject where ProjectID=22412
--select * from tblProject where ProjectCode='B20904'
--select * from tblSubContractor where SubContractorID=88420
--select top 10* from tblWorkOrderHeader where ProjectID=22412

ALTER PROCEDURE [dbo].[iSRPDb_Sp_Search_WO]
@pBusinessUnitID as int=0,
@pProjectID as int,
@pSubcontractorID as int,
@pWONumber as varchar(10),
@PageSize as int

AS
BEGIN
SET NOCOUNT ON;

DECLARE @BusinessUnitFilter Varchar(255)
DECLARE @NameFilter Varchar(255)
DECLARE @SubConNameFilter Varchar(255)
DECLARE @WONumFilter Varchar(255)
DECLARE @Filter Varchar(2000)
DECLARE @StatusFilter VARCHAR(255)
DECLARE @PageNumber int
DECLARE @RowStart int
DECLARE @RowEnd int
DECLARE @condition varchar(255)
SET @StatusFilter=''


--if @PageNumber > 0
--
-- SET @PageNumber = @PageNumber -1
-- SET @RowStart = @PageSize * @PageNumber + 1;
-- SET @RowEnd = @RowStart + @PageSize - 1 ;

IF @pBusinessUnitID > 0
SET @BusinessUnitFilter = 'TWO. BusinessUnitID=' + Convert(Varchar(10),@pBusinessUnitID)
ELSE
SET @BusinessUnitFilter = ''

IF LTRIM(RTRIM(@pProjectID)) > 0
SET @NameFilter = ' AND TP.ProjectID =' + Convert(Varchar(255),@pProjectID)
ELSE
SET @NameFilter = ''
IF LTRIM(RTRIM(@pSubcontractorID)) > 0
SET @SubConNameFilter = ' AND TS.SubcontractorID =' + Convert(Varchar(255),@pSubcontractorID)
ELSE
SET @SubConNameFilter = ''

If ltrim(rtrim(@pWONumber))<> ''
Set @WONumFilter = 'AND TWO.WONumber LIKE ''%' + @pWONumber + '%'''
Else
Set @WONumFilter = ''

SET @FILTER =@StatusFilter + @BusinessUnitFilter + @NameFilter + @SubConNameFilter + @WONumFilter







exec('select
TWO.WONumber,
TS.Name AS SubcontractorName,
TP.ProjectCode,
TP.Description as ProjectName ,
TP.StartDate,
TP.EndDate,
ROW_NUMBER() OVER(order by TP.Description) as RowNO



from tblWorkOrderHeader TWO inner join
tblWorkOrderDetail TWOD on TWO.WONumber= TWOD.WONumber
inner join tblSubContractor TS on TWO.SubContractorID= TS.SubContractorID
inner join tblProject TP on TWO.ProjectID=TP.ProjectID
where ' + @FILTER)

end

--select * from tblProject where ProjectID=20101
--select * from tblSubContractor where SubContractorID=110244
--where (@subconid = 0 or @subconid = aa.subcontractorid)
AnswerCross posted from Database forum Pin
Pete O'Hanlon12-Apr-12 22:18
mvePete O'Hanlon12-Apr-12 22:18 
QuestionProjectProblem Pin
Madhavsingh12-Apr-12 19:26
Madhavsingh12-Apr-12 19:26 
AnswerRe: ProjectProblem Pin
egenis12-Apr-12 20:01
egenis12-Apr-12 20:01 
QuestionAlwaysOnTop behavior - Windows Forms vs. Win32? Pin
Ravi Bhavnani12-Apr-12 18:59
professionalRavi Bhavnani12-Apr-12 18:59 
AnswerRe: AlwaysOnTop behavior - Windows Forms vs. Win32? Pin
Alan N12-Apr-12 23:21
Alan N12-Apr-12 23:21 
GeneralRe: AlwaysOnTop behavior - Windows Forms vs. Win32? Pin
Ravi Bhavnani13-Apr-12 5:19
professionalRavi Bhavnani13-Apr-12 5:19 
QuestionXml Serilization / Deserilization Array quesiton Pin
Jason McBurney12-Apr-12 14:09
Jason McBurney12-Apr-12 14:09 
GeneralRe: Xml Serilization / Deserilization Array quesiton Pin
BobJanova13-Apr-12 2:34
BobJanova13-Apr-12 2:34 
GeneralRe: Xml Serilization / Deserilization Array quesiton Pin
Jason McBurney13-Apr-12 5:36
Jason McBurney13-Apr-12 5:36 
QuestionDrawing to Picturebox problem. Help needed badly Pin
aquahoya12-Apr-12 13:53
aquahoya12-Apr-12 13:53 
SuggestionRe: Drawing to Picturebox problem. Help needed badly Pin
Richard MacCutchan12-Apr-12 21:25
mveRichard MacCutchan12-Apr-12 21:25 
QuestionLearning C# through exercises Pin
jeramyRR12-Apr-12 12:44
jeramyRR12-Apr-12 12:44 
AnswerRe: Learning C# through exercises Pin
Kevin Marois12-Apr-12 13:45
professionalKevin Marois12-Apr-12 13:45 
AnswerRe: Learning C# through exercises Pin
Roger Wright12-Apr-12 19:42
professionalRoger Wright12-Apr-12 19:42 
GeneralRe: Learning C# through exercises Pin
jeramyRR12-Apr-12 19:48
jeramyRR12-Apr-12 19:48 
GeneralRe: Learning C# through exercises Pin
Roger Wright19-Apr-12 8:21
professionalRoger Wright19-Apr-12 8:21 
GeneralRe: Learning C# through exercises Pin
jeramyRR19-Apr-12 8:33
jeramyRR19-Apr-12 8:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.