«

Well there's another place where I am getting stuck. The stored
procedure that gets the no. of orders a user has placed (please have a
look at the VB class file in post #4 in this thread) also gets the
OrderID of each order. In other words, the stored procedure retrieves 2
columns. I did like to set the OrderID as the CommandArgument of each
LinkButton but as shown in post #4, I am creating the LinkButtons
dynamically OUTSIDE the While(sqlReader.Read) loop since creating the
LinkButtons inside the While loop would mean looping the For...Next
loop (to create the dynamic LinkButtons) within the While loop. Under
such circumstances, a user who has placed, say, 4 orders would see the
LinkButtons 1 2 3 4 thrice which is something which I don't want.

But how do I get the OrderID of each order OUTSIDE the While
(sqlReader.Read) loop?


r...@rediffmail.com wrote:
> Gozirra, that's EXACTLY what I was looking out for (the AddHandler
> lnkDynamic.Command, AddressOf lnkDynamic_Command line). Thanks a lot.
>
> You as well as Mark have repeatedly stressed on fetching the cart (if I
> am not mistaken, by "fetching the cart", you & Mark mean getting the
> no. of orders a user has placed & the details of each & every order) in
> the Page_Init sub & NOT in the Page_Load sub. But what I find is even
> if I place the ASPX code I have shown in post #4 in this thread in the
> Page_Load sub & NOT in the Page_Init sub, then not only do the
> LinkButtons get recreated after each PostBack but also the events
> associated with the LinkButtons (in this case, the Command event) fire
> correctly after every PostBack. So why have you (& Mark) stressed on
> fetching the cart in the Page_Init sub & NOT in the Page_Load sub?
>
> Could you please clarify this point?
>
>
> Gozirra wrote:
> > lets take everything that was already suggested and VB'ify it. That
> > will hopefully make things a little more clear. Take note of #1 below.
> > Your dynamic buttons' events will not fire if they are not recreated
> > during page_init. Thats why it is so important that you fetch the cart
> > during this page event instead of during load. Best I can do. Hope it
> > helps.
> >
> > 1) In Page_Init, not Page_Load, fetch your cart
> >
> > 2) For each element in the cart (order, product, whatever), create a
> > new button.
> >
> > Dim lnkDynamic As LinkButton
> >
> > foreach(<whatever> in <cart>)
> > lnkDynamic = new LinkButton()
> > lnkDynamic.EnableViewState = true
> > lnkDynamic.ID = "lnkDynamic_" + <identifier> 'Identifier can be
> > your order# or whatever your want
> > lnkDynamic.Text = "SomeText"
> > AddHandler lnkDynamic.Command, AddressOf lnkDynamic_Command
> > lnkDynamic.CommandName = "AnyTextYouWant"
> > lnkDynamic.Visible = false
> > Me.Controls.Add(lnkDynamic)
> > Next
> >
> > That will have created as many individual buttons as there are elements
> > in
> > your cart.
> >
> > 3) Create the event handler
> >
> >
> > Public Sub lnkDynamic_Command(sender As object, e As CommandEventArgs)
> > ' your code to process the individual elements goes here
> > ' use e.CommandName to work out which button was clicked
> > ' You could put the order number into the command name
> > ' you could also cast sender to a LinkButton and check its ID if
> > you want. many different ways.
> > If e.CommandName = "1" Then
> > 'Do stuff for 1
> > End If
> >
> > or maybe
> >
> > Dim lb As LinkButton
> > lb = DirectCast(sender, LinkButton) 'or whatever your favorite
> > method is
> > If lb.ID == "1" Then 'or whatever the heck you want to do
> > 'Some stuff
> > End If
> > End Sub
> >
> >
> > 4) Place the individual dynamic buttons on your form wherever they need
> > to
> > be e.g. in the cells of a GridView, Repeater etc and make them visible.

Why build the list outside of the while loop then? Try something like
this. Since I do not know exactly what data is coming back, its kind
of hard to determine exactly what all of the possibilities are. But
hopefully it'll give you an idea if you haven't already gotten
everything fixed.

While (sqlReader.Read)
If (sqlReader.GetValue(0) > 1) Then
iTotalOrder = sqlReader.GetValue(0)

lnkDynamic = new LinkButton()
lnkDynamic.EnableViewState = true
lnkDynamic.ID = "lnkDynamic_" + <identifier> 'Identifier
can be your order# or whatever your want
lnkDynamic.Text = "SomeText"
AddHandler lnkDynamic.Command, AddressOf lnkDynamic_Command

lnkDynamic.CommandName = "AnyTextYouWant"
'sqlReader.GetValue(1) perhaps
lnkDynamic.Visible = false
Me.Controls.Add(lnkDynamic)
Else
pnlLinks.Visible = False
End If
End While

Gozirra, the main reason why I want to get the OrderID of each order
outside the While(sqlReader.Read) loop is because I want to pass the
OrderID to another sub named 'GetAddress' which expects 2 parameters -
the UserID & the OrderID. Depending upon the OrderID (& of course, the
UserID), the 'GetAddress' sub will retrieve the billing address &
shipping address pertaining to that OrderID. So even if I create the
dynamic links inside the While(sqlReader.Read) loop as you have
suggested, I still can't access the OrderID outside the While loop. In
order to access the OrderID outside the While loop, I will have to use
Session variables something like this:

Sub Page_Init(....)
iUserID = Request.Cookies("UserID").Value

While(sqlReader.Read)
If (sqlReader.GetValue(0) > 1) Then
iTotalOrders = sqlReader.GetValue(0)
'get the OrderID in Session variable
Session("OrderID") = sqlReader.GetValue(1)
lnkCount = New LinkButton
lnkCount.ID = "lnkCount" & iCount
lnkCount.Text = iCount.ToString
lnkCount.CommandName = iCount
lnkCount.CommandArgument = Session("OrderID")
AddHandler lnkCount.Command, AddressOf CommandCount
pnlLinks.Controls.Add(lnkCount)
iCount = iCount + 1
Session("TotalOrders") = iTotalOrders
Else
pnlLinks.Visible = False
End If
End While

GetAddress(iUserID, CInt(Session("OrderID")))
End Sub

This does serve my purpose & gets the correct billing & shipping
address corresponding to the UserID & OrderID but I did like to avoid
using Session variables.

Can you suggest some way by which I can avoid using Session variables
to store the OrderID?

Gozirra wrote:
> Why build the list outside of the while loop then? Try something like
> this. Since I do not know exactly what data is coming back, its kind
> of hard to determine exactly what all of the possibilities are. But
> hopefully it'll give you an idea if you haven't already gotten
> everything fixed.
>
> While (sqlReader.Read)
> If (sqlReader.GetValue(0) > 1) Then
> iTotalOrder = sqlReader.GetValue(0)
>
> lnkDynamic = new LinkButton()
> lnkDynamic.EnableViewState = true
> lnkDynamic.ID = "lnkDynamic_" + <identifier> 'Identifier
> can be your order# or whatever your want
> lnkDynamic.Text = "SomeText"
> AddHandler lnkDynamic.Command, AddressOf lnkDynamic_Command
>
> lnkDynamic.CommandName = "AnyTextYouWant"
> 'sqlReader.GetValue(1) perhaps
> lnkDynamic.Visible = false
> Me.Controls.Add(lnkDynamic)
> Else
> pnlLinks.Visible = False
> End If
> End While

Sorry I got really busy at work and wasn't able to check back in. Is
this still an issue for you? If not, everyone just ignore me.

Given the code example you have below, you want to pass the last
orderid retrieved to a subroutine when the loop has completed. So just
pull the last orderid from the commandargument of lnkCount. The last
time through the loop you will have the same value as you have in your
session variable in the code below. This way you do not have to use a
session variable. You could also create a local variable and assign
the value as you iterate the records. That may be a little cleaner and
easier to understand if someone has to come back and look at this
routine later.

wrote:
> Gozirra, the main reason why I want to get the OrderID of each order
> outside the While(sqlReader.Read) loop is because I want to pass the
> OrderID to another sub named 'GetAddress' which expects 2 parameters -
> the UserID & the OrderID. Depending upon the OrderID (& of course, the
> UserID), the 'GetAddress' sub will retrieve the billing address &
> shipping address pertaining to that OrderID. So even if I create the
> dynamic links inside the While(sqlReader.Read) loop as you have
> suggested, I still can't access the OrderID outside the While loop. In
> order to access the OrderID outside the While loop, I will have to use
> Session variables something like this:
>
> Sub Page_Init(....)
> iUserID = Request.Cookies("UserID").Value
>
> While(sqlReader.Read)
> If (sqlReader.GetValue(0) > 1) Then
> iTotalOrders = sqlReader.GetValue(0)
> 'get the OrderID in Session variable
> Session("OrderID") = sqlReader.GetValue(1)
> lnkCount = New LinkButton
> lnkCount.ID = "lnkCount" & iCount
> lnkCount.Text = iCount.ToString
> lnkCount.CommandName = iCount
> lnkCount.CommandArgument = Session("OrderID")
> AddHandler lnkCount.Command, AddressOf CommandCount
> pnlLinks.Controls.Add(lnkCount)
> iCount = iCount + 1
> Session("TotalOrders") = iTotalOrders
> Else
> pnlLinks.Visible = False
> End If
> End While
>
> GetAddress(iUserID, CInt(Session("OrderID")))
> End Sub
>
> This does serve my purpose & gets the correct billing & shipping
> address corresponding to the UserID & OrderID but I did like to avoid
> using Session variables.
>
> Can you suggest some way by which I can avoid using Session variables
> to store the OrderID?
>
> Gozirra wrote:
> > Why build the list outside of the while loop then? Try something like
> > this. Since I do not know exactly what data is coming back, its kind
> > of hard to determine exactly what all of the possibilities are. But
> > hopefully it'll give you an idea if you haven't already gotten
> > everything fixed.
> >
> > While (sqlReader.Read)
> > If (sqlReader.GetValue(0) > 1) Then
> > iTotalOrder = sqlReader.GetValue(0)
> >
> > lnkDynamic = new LinkButton()
> > lnkDynamic.EnableViewState = true
> > lnkDynamic.ID = "lnkDynamic_" + <identifier> 'Identifier
> > can be your order# or whatever your want
> > lnkDynamic.Text = "SomeText"
> > AddHandler lnkDynamic.Command, AddressOf lnkDynamic_Command
> >
> > lnkDynamic.CommandName = "AnyTextYouWant"
> > 'sqlReader.GetValue(1) perhaps
> > lnkDynamic.Visible = false
> > Me.Controls.Add(lnkDynamic)
> > Else
> > pnlLinks.Visible = False
> > End If
> > End While