Click here to Skip to main content
16,005,389 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionOnLine Shopping Problem. Pin
ajau17-Aug-07 22:29
ajau17-Aug-07 22:29 
AnswerRe: OnLine Shopping Problem. Pin
pmarfleet17-Aug-07 22:39
pmarfleet17-Aug-07 22:39 
Questionis there any method/Class in asp.net to support... Pin
koolprasad200317-Aug-07 21:37
professionalkoolprasad200317-Aug-07 21:37 
AnswerRe: is there any method/Class in asp.net to support... Pin
pmarfleet17-Aug-07 22:49
pmarfleet17-Aug-07 22:49 
GeneralRe: is there any method/Class in asp.net to support... Pin
Mark Churchill18-Aug-07 6:00
Mark Churchill18-Aug-07 6:00 
QuestionShow count in repeater Pin
Vipin.d17-Aug-07 20:20
Vipin.d17-Aug-07 20:20 
AnswerRe: Show count in repeater Pin
pmarfleet17-Aug-07 22:47
pmarfleet17-Aug-07 22:47 
AnswerRe: Show count in repeater Pin
Vipin.d18-Aug-07 2:08
Vipin.d18-Aug-07 2:08 
hi frndz,
I got is solution...

creat a UD function
<br />
CREATE FUNCTION GetCount (@Request CHAR(1), @CatID VARCHAR(5)) <br />
RETURNS INT AS <br />
BEGIN <br />
<br />
Declare @Count INT<br />
<br />
IF @Request = 'W'  --Waiting for approval<br />
        SELECT @Count = count(RemitterRefNo) from TblRemittanceTxn<br />
       WHERE Category='O' AND  status=0 AND Catid=@CatID<br />
<br />
ELSE IF @Request = 'I' ---Incoming <br />
       SELECT @Count = count(RemitterRefNo) from TblRemittanceTxn<br />
       WHERE Category='I' AND  status=1 AND Catid=@CatID<br />
<br />
ELSE IF @Request = 'O' --OutGoing<br />
       SELECT @Count = count(RemitterRefNo) from TblRemittanceTxn<br />
       WHERE Category='O' AND  status=1 AND Catid=@CatID<br />
RETURN @Count<br />
<br />
END<br />


and use a query like this

<br />
Select distinct catname, <br />
dbo.GetCount('w',catid) as waiting_count,<br />
dbo.GetCount('i',catid) as incoming_count,<br />
dbo.GetCount('o',catid) as outgoing_count,<br />
from Category  




All I ever wanted is what others have....
CrazySanker





Questionposting data opens new window on Modal and modelless window Pin
Rizwan Bashir17-Aug-07 20:06
Rizwan Bashir17-Aug-07 20:06 
AnswerRe: posting data opens new window on Modal and modelless window Pin
Imran Khan Pathan17-Aug-07 20:15
Imran Khan Pathan17-Aug-07 20:15 
GeneralRe: posting data opens new window on Modal and modelless window Pin
Rizwan Bashir17-Aug-07 20:25
Rizwan Bashir17-Aug-07 20:25 
QuestionGetting Runtime Error on hosted site? Pin
chand1017-Aug-07 19:35
chand1017-Aug-07 19:35 
AnswerRe: Getting Runtime Error on hosted site? Pin
Imran Khan Pathan17-Aug-07 20:10
Imran Khan Pathan17-Aug-07 20:10 
GeneralRe: Getting Runtime Error on hosted site? Pin
chand1017-Aug-07 20:38
chand1017-Aug-07 20:38 
AnswerRe: Getting Runtime Error on hosted site? Pin
jithbiz003318-Aug-07 0:52
jithbiz003318-Aug-07 0:52 
QuestionProblem With Sql Money DataType Pin
N a r e s h P a t e l17-Aug-07 19:33
N a r e s h P a t e l17-Aug-07 19:33 
AnswerRe: Problem With Sql Money DataType Pin
pmarfleet17-Aug-07 22:55
pmarfleet17-Aug-07 22:55 
QuestionAsp.net textbox validation using javascript like regularexpression validator.., Pin
Member 387988117-Aug-07 18:51
Member 387988117-Aug-07 18:51 
QuestionCan I get the control in the control Pin
hurrem17-Aug-07 18:24
hurrem17-Aug-07 18:24 
AnswerRe: Can I get the control in the control Pin
Imran Khan Pathan17-Aug-07 18:42
Imran Khan Pathan17-Aug-07 18:42 
GeneralRe: Can I get the control in the control Pin
hurrem17-Aug-07 18:47
hurrem17-Aug-07 18:47 
GeneralRe: Can I get the control in the control Pin
Imran Khan Pathan17-Aug-07 19:19
Imran Khan Pathan17-Aug-07 19:19 
GeneralRe: Can I get the control in the control Pin
hurrem17-Aug-07 19:24
hurrem17-Aug-07 19:24 
QuestionAdd menu like winApplication Menu.... Pin
mostafa_h17-Aug-07 17:03
mostafa_h17-Aug-07 17:03 
QuestionSpecifying the master page in the Web.config file Pin
md_refay17-Aug-07 16:47
md_refay17-Aug-07 16:47 

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.