Click here to Skip to main content
15,891,757 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Counter Website C# Pin
<<Tash18>>11-Jan-10 20:08
<<Tash18>>11-Jan-10 20:08 
GeneralRe: Counter Website C# Pin
sashidhar11-Jan-10 20:11
sashidhar11-Jan-10 20:11 
QuestionRe: Counter Website C# Pin
jojoba201011-Jan-10 20:13
jojoba201011-Jan-10 20:13 
GeneralRe: Counter Website C# Pin
<<Tash18>>11-Jan-10 21:15
<<Tash18>>11-Jan-10 21:15 
QuestionRe: Counter Website C# Pin
jojoba201011-Jan-10 22:17
jojoba201011-Jan-10 22:17 
AnswerRe: Counter Website C# Pin
Abhishek Sur11-Jan-10 23:40
professionalAbhishek Sur11-Jan-10 23:40 
QuestionRe: Counter Website C# Pin
jojoba201011-Jan-10 23:52
jojoba201011-Jan-10 23:52 
AnswerRe: Counter Website C# Pin
Shivendra Pandey12-Jan-10 0:58
Shivendra Pandey12-Jan-10 0:58 
create table in database

CREATE TABLE [ApplicationCount1] (
[HitID] [bigint] IDENTITY (1, 1) NOT NULL ,
[AddedDate] [datetime] NULL ,
[HitCount] [bigint] NULL ,

) ON [PRIMARY]
GO


Create Procedure to Add Hit
alter procedure usp_Hit1
as
declare @CurrentID bigint
declare @AddedDate datetime
set @CurrentID=0
set @AddedDate=CONVERT(char(12), GETDATE(), 101)
Select @CurrentID=HitID from ApplicationCount1 where Addeddate=@AddedDate
if @CurrentID>0
update ApplicationCount1 Set HitCount=HitCount+1 where HitId=@CurrentID
else
insert into ApplicationCount1 values(CONVERT(char(12), GETDATE(), 101),1)


Now on Session Start Call This Procedure now in database u have datewise count now u can use it to display number of hit for any day
QuestionRe: Counter Website C# Pin
jojoba201012-Jan-10 3:19
jojoba201012-Jan-10 3:19 
QuestionHow to get DateTime Pin
jojoba201011-Jan-10 18:40
jojoba201011-Jan-10 18:40 
AnswerRe: How to get DateTime Pin
sashidhar11-Jan-10 18:43
sashidhar11-Jan-10 18:43 
AnswerRe: How to get DateTime Pin
Abhishek Sur11-Jan-10 23:42
professionalAbhishek Sur11-Jan-10 23:42 
AnswerRe: How to get DateTime Pin
April Fans12-Jan-10 19:18
April Fans12-Jan-10 19:18 
AnswerRe: How to get DateTime Pin
carlecomm19-Jan-10 17:43
carlecomm19-Jan-10 17:43 
QuestionClose session in While closing browser Pin
Amit Patel198511-Jan-10 18:22
Amit Patel198511-Jan-10 18:22 
AnswerRe: Close session in While closing browser [modified] Pin
Pranay Rana11-Jan-10 19:43
professionalPranay Rana11-Jan-10 19:43 
AnswerRe: Close session in While closing browser Pin
Venkatesh Mookkan11-Jan-10 22:50
Venkatesh Mookkan11-Jan-10 22:50 
Questiongrab contacts from Social network Pin
kokilaB11-Jan-10 17:28
kokilaB11-Jan-10 17:28 
AnswerRe: grab contacts from Social network Pin
sashidhar11-Jan-10 17:44
sashidhar11-Jan-10 17:44 
GeneralRe: grab contacts from Social network Pin
kokilaB11-Jan-10 18:43
kokilaB11-Jan-10 18:43 
GeneralRe: grab contacts from Social network Pin
sashidhar11-Jan-10 18:51
sashidhar11-Jan-10 18:51 
GeneralRe: grab contacts from Social network Pin
kokilaB11-Jan-10 18:44
kokilaB11-Jan-10 18:44 
GeneralRe: grab contacts from Social network Pin
kokilaB11-Jan-10 19:22
kokilaB11-Jan-10 19:22 
GeneralRe: grab contacts from Social network Pin
Vasudevan Deepak Kumar12-Jan-10 4:08
Vasudevan Deepak Kumar12-Jan-10 4:08 
QuestionManupulating Columns of datatable Pin
kris_viswa11-Jan-10 17:27
kris_viswa11-Jan-10 17:27 

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.