ASP.NET

Re: Is the Unload event fired when Page Caching is enabled?

25-Aug-08 16:22

Why dont you handle that event on a page with/without caching enabled and set a breakpoint and see if the breakpoint is hit

Then you could post your results
It would be good to know it Smile | :)

Alexei Rodriguez

jrhea25-Aug-08 17:46

jrhea

25-Aug-08 17:46

Oh sure, make me do the work. Wink | ;)

I went ahead and tried it and the unload event did not fire if cached on the server side. I had a feeling it wouldn't, which is partly why I made the post. What techniques do others use to capture stats on cached pages? I was thinking of creating a 1x1 image file served by a generic handler to log page hits.

Are there any other/better ways to do it?

Visit My Site - http://www.jacerhea.com/blog

Re: Is the Unload event fired when Page Caching is enabled?

AlexeiXX325-Aug-08 17:59

Re: Is the Unload event fired when Page Caching is enabled?

25-Aug-08 17:59

Just handle the beginrequest in the global.asax
I dont think a call to a stored procedure will take too much time
If you only want to count requests you can save a temp variable in the application object and save it on application end or every n minutes

Protected Sub Application_BeginRequest(ByVal sender As Object, ByVal e As System.EventArgs)
   'Do your stuff
End Sub

jrhea wrote:
I was thinking of creating a 1x1 image file served by a generic handler

Wouldnt this image be cached on client side and you would only count the first request??

Alexei Rodriguez

jrhea25-Aug-08 18:13

jrhea

25-Aug-08 18:13

AlexeiXX3 wrote:
Just handle the beginrequest in the global.asax

Thanks, I'll give that a try. I'm sure the performance difference wouldn't be that noticeable, but I wanted to avoid it if possible.

AlexeiXX3 wrote:
Wouldnt this image be cached on client side and you would only count the first request??

It shouldn't be as long as the response headers are set appropriately.

Visit My Site - http://www.jacerhea.com/blog

Treeview

Steve R Adams25-Aug-08 10:48

25-Aug-08 10:48

I really hope that somebody out there reads this and responds. I'm having a real nightmare here and just to top it off Im not even a seasoned developer!

I am trying to create a treeview that will display multiple levels of users (a network marketing program).

I have an MS-Access table containing:

memberid (unique)
membersponsor
membername
imagetodisplay (contains a url to an image of the level of the user in the program ie junior, senior etc)

At some stage (before .net) it was possible to use this structure because you simply told the application the node id where to wanted to insert the record but now it seems this is not the case. I am firstly told that this is not hierachical data (which, if you take the sponsor / memberid into account, it actually is).

Some sponsors have no members under them while some have hundreds. How do I get this into a form that a treeview will recognise? All I want to do is display the membername and the image.

I am using vb.net on visual studio 2005. The treeview is residing on an .aspx page (if that makes any difference)

I have found various references on this site about first writing to a dataset and then using various classes to do this but even if I download the code and just change the dataset it doesn't work. I think this has something to do with the fact that the sample was written for only two levels whilst mine may have numerous levels deep.

PLEASE can somebody help.
Thanks
Steve

AlexeiXX325-Aug-08 16:18

25-Aug-08 16:18

If you may have many levels, you need to do it recursivelly

Alexei Rodriguez

Steve R Adams28-Aug-08 10:24

28-Aug-08 10:24

Thanks Alexei

Can I ask you a favor. I am anyway going to post this message in another forum but maybe you can have a look and see if you see something wrong with it.

Thanks
Steve

Imports System.Data
Imports System.Web.UI.WebControls
Partial Class members_organization_mysampletreeview
Inherits System.Web.UI.Page
Dim memberid As Long
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

' THIS IS THE ID OF THE LOGGED IN USER WHICH IS BASICALLY THE ROOT NODE OF THE TREE
memberid = 3

If IsPostBack = False Then
populaterootlevel()
End If

End Sub

Public Sub populaterootlevel()
Dim mycon As New OleDb.OleDbConnection(ConfigurationManager.ConnectionStrings("trafficbobbyconstringaccess").ToString())
Dim mycmd As New OleDb.OleDbCommand
Dim strsql As String
Dim dr As OleDb.OleDbDataReader
Dim NoOfDownline As Integer

'Find out how many child nodes this parent is supposed to have
strsql = "SELECT members.RisingEagleSponsor AS ID, Count(members.RisingEagleID) AS Parent"
strsql = strsql & " FROM(members)"
strsql = strsql & " GROUP BY members.RisingEagleSponsor"
strsql = strsql & " HAVING (((members.RisingEagleSponsor)=" & memberid & " ));"

mycmd.Connection = mycon
mycmd.CommandText = strsql
If mycon.State <> ConnectionState.Open Then
mycon.Open()
End If
dr = mycmd.ExecuteReader
dr.Read()
If dr.HasRows = True Then
NoOfDownline = dr.Item("Parent")
End If
dr.Close()

strsql = "SELECT members.RisingEagleID AS ID, 0 AS Parent, members.MemberName AS Title, " & NoOfDownline & " as childnodecount"
strsql = strsql & " FROM(members)"
strsql = strsql & " WHERE (((members.RisingEagleID)=" & memberid & "));"

mycmd.Connection = mycon
mycmd.CommandText = strsql
If mycon.State <> ConnectionState.Open Then
mycon.Open()
End If
Dim da As New OleDb.OleDbDataAdapter(mycmd)
Dim dt As New DataTable
da.Fill(dt)
mycon.Close()
PopulateNodes(dt, Me.TreeView1.Nodes)

End Sub

Public Sub populatesublevel(ByVal parentid As Integer, ByVal parentnode As TreeNode)
Dim mycon As New OleDb.OleDbConnection(ConfigurationManager.ConnectionStrings("trafficbobbyconstringaccess").ToString())
Dim mycmd As New OleDb.OleDbCommand
Dim strsql As String

'Get the final list of all the downline for this member
strsql = "SELECT members.RisingEagleID AS ID, members.RisingEagleSponsor AS Parent, members.MemberName AS Title, AllParents.childnodecount"
strsql = strsql & " FROM members"
strsql = strsql & " INNER JOIN AllParents ON members.RisingEagleSponsor = AllParents.Parent"
strsql = strsql & " WHERE members.RisingEagleSponsor = " & parentid
strsql = strsql & " ORDER BY members.RisingEagleSponsor"

mycmd.Connection = mycon
If mycon.State <> ConnectionState.Open Then
mycon.Open()
End If
mycmd.CommandText = strsql

Dim da As New OleDb.OleDbDataAdapter(mycmd)
Dim dt As New DataTable
da.Fill(dt)
mycon.Close()
PopulateNodes(dt, Me.TreeView1.Nodes)
End Sub

Public Sub TreeView1_TreeNodePopulate(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.TreeNodeEventArgs) Handles TreeView1.TreeNodePopulate
On Error GoTo errhandler

populatesublevel(Int32.Parse(e.Node.Value), e.Node)

Errhandler:
Select Case Err.Number
Case 0
Exit Sub
Case Else
Dim mymsg As String
mymsg = Err.Number & " " & Err.Description
End Select
End Sub

Public Sub PopulateNodes(ByVal dt As DataTable, ByVal nodes As TreeNodeCollection)
On Error GoTo errhandler
Dim mymsg As String
For Each dr As DataRow In dt.Rows
mymsg = dt.Rows.Count
Dim tn As TreeNode = New TreeNode()
tn.Text = dr("Title").ToString()
tn.Value = dr("ID").ToString
nodes.Add(tn)

'If node has child nodes then enable on-demand populating
tn.PopulateOnDemand = CType(dr.Item("childnodecount"), Long) > 0
Next

mymsg = "123"
Errhandler:
Select Case Err.Number
Case 0
Exit Sub
Case Else

mymsg = Err.Number & " " & Err.Description
End Select
End Sub
End Class

AlexeiXX328-Aug-08 10:40

28-Aug-08 10:40

I didnt read your code, you didnt mention if it os working or not, so i dont know what to look for

All i can give you is an example i used:

Public Sub FillNode(ByVal ID As Integer, ByRef RootNode As TreeNode)
    Dim Node As TreeNode
    Dim Rows As DataRow() = Me.tbl.Select("FatherCategoryID=" & ID, "Name")
    For Each R As DataRow In Rows
        Node = New TreeNode(R.Item("Name"), R.Item("CategoryID"))
        Node.SelectAction = Me.SelectAction
        Me.FillNode(R.Item("CategoryID"), Node)
        RootNode.ChildNodes.Add(Node)
    Next
End Sub

For this example, there is a table with all the rows called tbl. The struct for the table is:
CategoryID, FatherCategoryID, Name

And this function is called sending the root node of the treeview and the id of the parent node

I hope this helps you

Alexei Rodriguez

Steve R Adams28-Aug-08 11:47

28-Aug-08 11:47

Thanks - I will give it a try
Steve

Steve R Adams2-Sep-08 11:57

2-Sep-08 11:57

Hi Alexei

Sorry for being a pain in the &%^# but I am still having some difficulty.

I tried the sample you gave me but couldn't get it to work.

Then I tried the following:

While dr_ID.Read
'Find a node matching this node value
Dim Nodx As TreeNode
Dim containernode As New TreeNode

For Each Nodx In Me.TreeView1.Nodes
Nodx.PopulateOnDemand = False
If Nodx.Value.ToString = P.ToString Then
containernode.Value = dr_ID.Item("MembersID").ToString
containernode.Text = dr_ID.Item("MembersName").ToString
Nodx.ChildNodes.Add(containernode)
Nodx.SelectAction = TreeNodeSelectAction.Expand
End If
Next Nodx

End While

It populates the root node as well as the first level of children but it seems that the "For Each Nodx In TreeView" doesn't actually return a reference to the children. Is this true? the "P" that you see is the parentid which the childnode has to be created under whilst the rest is pretty much explanatory.

Can u suggest anything else?

Regards
Steve

AlexeiXX33-Sep-08 6:41