vuyiswamb 17 Posting Whiz

Run this Script

USE MyDatabasename
        GO
        sp_configure 'allow updates', 1
        GO
        RECONFIGURE WITH OVERRIDE
        GO 
   
        sp_resetstatus 'MyDatabasename'
        GO

        sp_configure 'allow updates', 0
        GO
        RECONFIGURE WITH OVERRIDE
        GO
vuyiswamb 17 Posting Whiz

How many web config do you have in your Project ?

Do something for me, so that i can know what is the problem exactly. go to one of the aspx file and right click -- Open with --> Notepad and Tell me what you see there.

Kind Regards


Vuyiswa Maseko

vuyiswamb 17 Posting Whiz

ok

vuyiswamb 17 Posting Whiz

Most of the Paid domains give this for free in their Control Panels. or you can try this

protected void Page_Load(object sender, EventArgs e)
    {
        Application.Lock();
        if(Application["HitCount"]!=null)
         {
            Application["HitCount"]=(int)Application["HitCount"]+1;
         }
        else
         {
             Application["HitCount"] =1;
         }
         Application.UnLock();
        lblInfo.Text="The page has been accessed ("+Application["HitCount"].ToString()+") times";
    }

or this might Help

http://www.stardeveloper.com/articles/display.html?article=2002102501&page=1

Kind Regards

Vuyiswa Maseko

sknake commented: neat, i didn't know about that +17
vuyiswamb 17 Posting Whiz

sknake it seems as if they have done a pre-complilation and now he is trying to open those aspx page , but let us make sure.

Vampdee in the File that you have do you have a Solution file(.sln) and do you have a (.cs) or (.vb) files for each aspx page ?

Vampdee commented: .sln is what I was missing +0
vuyiswamb 17 Posting Whiz

You are Welcome. You can Mark the Thread as "Resolved" or Add Reputation"

Thank you

Vuyiswa Maseko

vuyiswamb 17 Posting Whiz

i have Resolved the Problem. Thank you. i did the Following

i created a UDF like this

CREATE FUNCTION GetCycle (@Descr Varchar(50))  
RETURNS Varchar(500)
AS  
BEGIN
Declare @RetStr as varchar(500),@Cycle Int  --<-- Assuming Cycle field  is of Type Integer

Declare TmpCur Cursor For select CyCle From YourTblName Where Descr=@Descr
Open TmpCur
Set @RetStr=''
Fetch Next From TmpCur Into @Cycle
While @@Fetch_status=0
Begin
		Set @RetStr = @RetStr + Case when @RetStr='' then '' else ' ' End + Cast(@Cycle as varchar)
	Fetch Next From TmpCur Into @Cycle
End
Close TmpCur 
Deallocate TmpCur 
return (@RetStr)
END

and Called the Function like this

Select Descr,.dbo.GetCycle(Descr) As Cycle From YourTableName Where Descr 
          in ( select Distinct Descr From YourTableName)

Thank you

vuyiswamb 17 Posting Whiz

hi

its My birthday today, am not Writting code :);) :D :D :twisted: :cool: :icon_lol: