How to bring aspx code (in HTML view) to the aspx.vb code-behind?

Paolo Pignatelli · Feb 19, 2005

I have an aspx code behind page that goes something like this in the HTML
view:

<asp:HyperLink id=HyperLink1 runat="server"

NavigateUrl='<%#"mailto:" &
DataBinder.Eval(Container.DataItem,"StoreEmail") & "&Subject=" &
DataBinder.Eval(Container.DataItem,"ProductName")

....

It works. For each item in the datagrid, it displays the correct
information.

.... here is additional info, if needed ...

Public Function GetItems(ByVal cartID As String) As SqlDataReader

Dim myConnection As SqlConnection = New
SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))

Dim myCommand As SqlCommand = New SqlCommand("ShoppingCartList",
myConnection)

myCommand.CommandType = CommandType.StoredProcedure

Dim parameterCartID As SqlParameter = New SqlParameter("@CartID",
SqlDbType.NVarChar, 50)

parameterCartID.Value = cartID

myCommand.Parameters.Add(parameterCartID)

myConnection.Open()

Dim result As SqlDataReader =
myCommand.ExecuteReader(CommandBehavior.CloseConnection)

' Return the datareader result

Return result

End Function

///////////////

The sproc is here:

CREATE PROCEDURE [dbo].[ShoppingCartList]

@CartID nvarchar (50)

AS

SELECT dbo.Products.ProductID,
dbo.Products.ProductName,
dbo.ShoppingCart.Quantity,
dbo.Products.Price,
....

FROM dbo.Products INNER JOIN
dbo.ShoppingCart ON dbo.Products.ProductID =
dbo.ShoppingCart.ProductID INNER JOIN
...

WHERE
Products.ProductID = ShoppingCart.ProductID
...

GO
_________________________________

Now I would like to bring this HTML code to code-behind page (.vb).

So, I have (the name is different because I had to use a FindControl
construct)

MailHyperLink.NavigateUrl = .... (Do I use the same quote, '<%# .... %>' ..
what do I put here??)

How do I continue?

If you could also explain the "why" for your answer ,that would be even
better.

TIA,

Paolo

Scott Allen · Feb 19, 2005

Hi Paolo:

Are you trying to bring the DataBinding statements into code behind?

This article may provide some insight:
http://odetocode.com/Articles/278.aspx

Let me know if I've misunderstood the question...

Paolo Pignatelli · Feb 19, 2005

Yes, exactly, I am trying to bring the DataBinding statements into code
behind. Is there also a VB version of the article?

TIA,

Paolo

Scott Allen said:
Hi Paolo:

Are you trying to bring the DataBinding statements into code behind?

This article may provide some insight:
http://odetocode.com/Articles/278.aspx

Let me know if I've misunderstood the question...

--
Scott
http://www.OdeToCode.com/blogs/scott/

I have an aspx code behind page that goes something like this in the HTML
view:

<asp:HyperLink id=HyperLink1 runat="server"

NavigateUrl='<%#"mailto:" &
DataBinder.Eval(Container.DataItem,"StoreEmail") & "&Subject=" &
DataBinder.Eval(Container.DataItem,"ProductName")

...

It works. For each item in the datagrid, it displays the correct
information.

... here is additional info, if needed ...

Public Function GetItems(ByVal cartID As String) As SqlDataReader

Dim myConnection As SqlConnection = New
SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))

Dim myCommand As SqlCommand = New SqlCommand("ShoppingCartList",
myConnection)

myCommand.CommandType = CommandType.StoredProcedure

Dim parameterCartID As SqlParameter = New SqlParameter("@CartID",
SqlDbType.NVarChar, 50)

parameterCartID.Value = cartID

myCommand.Parameters.Add(parameterCartID)

myConnection.Open()

Dim result As SqlDataReader =
myCommand.ExecuteReader(CommandBehavior.CloseConnection)

' Return the datareader result

Return result

End Function

///////////////

The sproc is here:

CREATE PROCEDURE [dbo].[ShoppingCartList]

@CartID nvarchar (50)

AS

SELECT dbo.Products.ProductID,
dbo.Products.ProductName,
dbo.ShoppingCart.Quantity,
dbo.Products.Price,
...

FROM dbo.Products INNER JOIN
dbo.ShoppingCart ON dbo.Products.ProductID =
dbo.ShoppingCart.ProductID INNER JOIN
...

WHERE
Products.ProductID = ShoppingCart.ProductID
...

GO
_________________________________

Now I would like to bring this HTML code to code-behind page (.vb).

So, I have (the name is different because I had to use a FindControl
construct)

MailHyperLink.NavigateUrl = .... (Do I use the same quote, '<%# .... %>' ...
what do I put here??)

How do I continue?

If you could also explain the "why" for your answer ,that would be even
better.

TIA,

Paolo

Click to expand...

IPGrunt · Feb 19, 2005

Scott Allen said:
Yes, exactly, I am trying to bring the DataBinding statements into code
behind. Is there also a VB version of the article?

TIA,

Paolo

Scott Allen said:

Hi Paolo:

Are you trying to bring the DataBinding statements into code behind?

This article may provide some insight:
http://odetocode.com/Articles/278.aspx

Let me know if I've misunderstood the question...

Click to expand...

"&Subject="

&

DataBinder.Eval(Container.DataItem,"ProductName")

...

It works. For each item in the datagrid, it displays the correct
information.

... here is additional info, if needed ...

Public Function GetItems(ByVal cartID As String) As SqlDataReader

Dim myConnection As SqlConnection = New
SqlConnection(ConfigurationSettings.AppSettings ("ConnectionString"))

Dim myCommand As SqlCommand = New SqlCommand("ShoppingCartList",
myConnection)

myCommand.CommandType = CommandType.StoredProcedure

Dim parameterCartID As SqlParameter = New SqlParameter("@CartID",
SqlDbType.NVarChar, 50)

parameterCartID.Value = cartID

myCommand.Parameters.Add(parameterCartID)

myConnection.Open()

Dim result As SqlDataReader =
myCommand.ExecuteReader(CommandBehavior.CloseConnection)

' Return the datareader result

Return result

End Function

///////////////

The sproc is here:

CREATE PROCEDURE [dbo].[ShoppingCartList]

@CartID nvarchar (50)

AS

SELECT dbo.Products.ProductID,
dbo.Products.ProductName,
dbo.ShoppingCart.Quantity,
dbo.Products.Price,
...

FROM dbo.Products INNER JOIN
dbo.ShoppingCart ON dbo.Products.ProductID =
dbo.ShoppingCart.ProductID INNER JOIN
...

WHERE
Products.ProductID = ShoppingCart.ProductID
...

GO
_________________________________

Now I would like to bring this HTML code to code-behind page (.vb).

So, I have (the name is different because I had to use a FindControl
construct)

MailHyperLink.NavigateUrl = .... (Do I use the same quote, '<%#

Click to expand...

Click to expand...

..... %>'
..

You don't use the script delimiters in codebehind.

Your codebehind file is pure code. Essentially, the task is to create
a page object that implements your particular task. In this case,
looks like you wish to fill a cart, which is a datagrid?

Looks like you already have the code for creating the sqldatareader.

The datagrid accepts the SqlDataReader as it's DataSource. Given:

Dim grid As DataGrid

You'd assign the reader as:

grid.DataSource = GetItems (someCartID)

then you need to bind the two

grid.DataBind()

Is this what you're talking about? If so, take a look at the .NET
examples for ADO, of which you can see 2 or 3 examples of this kind
of thing, using codebehind with asp.net datalist type controls.

http://samples.gotdotnet.com/quickstart/aspplus/

-- ipgrunt

Paolo Pignatelli · Feb 20, 2005

Hello, and Thank you!

Yes you are correct. What I am trying to do is to be able to access one of the fields of the DataGrid, (the StoreEmail one, which is a hyperlink) and then add the other information about how the hyperlink works, other parameters, so that I can pass it info such as StoreName, ProductName etc... . The hyperlink then opens the email program (mailto

with the address, the subject, the itemnumber, etc... So, let's say that the datagriod has colums Productname and email. The Email link then opens an email, and the Subject address and other stuff filled in. If I just have a DatgaGrid
' Databind Gridcontrol with Shopping Cart Items

dgShoppingCart.DataSource = cart.GetItems(cartId)

dgShoppingCart.DataBind()

'TEST

Session("CartFull") = 1

'TEST

all the colums appear fine. I then add to the HTML page the inline code

<asp:HyperLink id=HyperLink1 runat="server" NavigateUrl='<%#"mailto:" & DataBinder.Eval(Container.DataItem,"StoreEmail") & "&Subject=" & DataBinder.Eval(Container.DataItem,"ProductName") & " ID=" & DataBinder.Eval(Container.DataItem,"ProductID") & "&Body=Test" & DataBinder.Eval(Container.DataItem,"ProductName") & " ID=" & DataBinder.Eval(Container.DataItem,"ProductID") %>'>HyperLink</asp:HyperLink>

I get the hyperlinks the way I want them, everything works fine

BUT.... Just out of an obtuse wish to separate code better, I would like to put all the info in the HTML page in the .vb page.

All and any further help is much appreciated.

Paolo

IPGrunt said:
Yes, exactly, I am trying to bring the DataBinding statements into code
behind. Is there also a VB version of the article?

TIA,

Paolo

Scott Allen said:

Hi Paolo:

Are you trying to bring the DataBinding statements into code behind?

This article may provide some insight:
http://odetocode.com/Articles/278.aspx

Let me know if I've misunderstood the question...

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Sat, 19 Feb 2005 08:23:07 -0500, "Paolo Pignatelli"

I have an aspx code behind page that goes something like this in the HTML
view:

<asp:HyperLink id=HyperLink1 runat="server"

NavigateUrl='<%#"mailto:" &
DataBinder.Eval(Container.DataItem,"StoreEmail") &

Click to expand...

"&Subject="

&
DataBinder.Eval(Container.DataItem,"ProductName")

...

It works. For each item in the datagrid, it displays the correct
information.

... here is additional info, if needed ...

Public Function GetItems(ByVal cartID As String) As SqlDataReader

Dim myConnection As SqlConnection = New
SqlConnection(ConfigurationSettings.AppSettings ("ConnectionString"))

Dim myCommand As SqlCommand = New SqlCommand("ShoppingCartList",
myConnection)

myCommand.CommandType = CommandType.StoredProcedure

Dim parameterCartID As SqlParameter = New SqlParameter("@CartID",
SqlDbType.NVarChar, 50)

parameterCartID.Value = cartID

myCommand.Parameters.Add(parameterCartID)

myConnection.Open()

Dim result As SqlDataReader =
myCommand.ExecuteReader(CommandBehavior.CloseConnection)

' Return the datareader result

Return result

End Function

///////////////

The sproc is here:

CREATE PROCEDURE [dbo].[ShoppingCartList]

@CartID nvarchar (50)

AS

SELECT dbo.Products.ProductID,
dbo.Products.ProductName,
dbo.ShoppingCart.Quantity,
dbo.Products.Price,
...

FROM dbo.Products INNER JOIN
dbo.ShoppingCart ON dbo.Products.ProductID =
dbo.ShoppingCart.ProductID INNER JOIN
...

WHERE
Products.ProductID = ShoppingCart.ProductID
...

GO
_________________________________

Now I would like to bring this HTML code to code-behind page (.vb).

So, I have (the name is different because I had to use a FindControl
construct)

MailHyperLink.NavigateUrl = .... (Do I use the same quote, '<%#

Click to expand...

.... %>'
..

what do I put here??)

How do I continue?

If you could also explain the "why" for your answer ,that would be even
better.

TIA,

Paolo

Click to expand...

Click to expand...

You don't use the script delimiters in codebehind.

Your codebehind file is pure code. Essentially, the task is to create
a page object that implements your particular task. In this case,
looks like you wish to fill a cart, which is a datagrid?

Looks like you already have the code for creating the sqldatareader.

The datagrid accepts the SqlDataReader as it's DataSource. Given:

Dim grid As DataGrid

You'd assign the reader as:

grid.DataSource = GetItems (someCartID)

then you need to bind the two

grid.DataBind()

Is this what you're talking about? If so, take a look at the .NET
examples for ADO, of which you can see 2 or 3 examples of this kind
of thing, using codebehind with asp.net datalist type controls.

http://samples.gotdotnet.com/quickstart/aspplus/

-- ipgrunt

IPGrunt · Feb 20, 2005

Hello, and Thank you!

Yes you are correct. What I am trying to do is to be able to

access one of the fields of the DataGrid, (the StoreEmail one, which
is a hyperlink) and then add the other information about how the
hyperlink works, other parameters, so that I can pass it info such as
StoreName, ProductName etc... . The hyperlink then opens the email
program (mailto

with the address, the subject, the itemnumber,
etc... So, let's say that the datagriod has colums Productname and
email. The Email link then opens an email, and the Subject address
and other stuff filled in. If I just have a DatgaGrid

' Databind Gridcontrol with Shopping Cart Items

dgShoppingCart.DataSource = cart.GetItems(cartId)

dgShoppingCart.DataBind()

'TEST

Session("CartFull") = 1

'TEST

all the colums appear fine. I then add to the HTML page the inline code

<asp:HyperLink id=HyperLink1 runat="server" NavigateUrl='<%

#"mailto:" & DataBinder.Eval(Container.DataItem,"StoreEmail")
& "&Subject=" & DataBinder.Eval
(Container.DataItem,"ProductName") & " ID=" & DataBinder.Eval
(Container.DataItem,"ProductID") & "&Body=Test" &
DataBinder.Eval(Container.DataItem,"ProductName") & " ID=" &
DataBinder.Eval(Container.DataItem,"ProductID") %>'>HyperLink

I get the hyperlinks the way I want them, everything works fine

BUT.... Just out of an obtuse wish to separate code better, I would

like to put all the info in the HTML page in the .vb page.

All and any further help is much appreciated.

Paolo

Yes, exactly, I am trying to bring the DataBinding statements

Click to expand...

into
code

behind. Is there also a VB version of the article?

TIA,

Paolo

Hi Paolo:

Are you trying to bring the DataBinding statements into code behind?

This article may provide some insight:
http://odetocode.com/Articles/278.aspx

Let me know if I've misunderstood the question...

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Sat, 19 Feb 2005 08:23:07 -0500, "Paolo Pignatelli"

I have an aspx code behind page that goes something like this

Click to expand...

in
the HTML

view:

<asp:HyperLink id=HyperLink1 runat="server"

NavigateUrl='<%#"mailto:" &
DataBinder.Eval(Container.DataItem,"StoreEmail") & "&Subject="
&
DataBinder.Eval(Container.DataItem,"ProductName")

...

It works. For each item in the datagrid, it displays the correct
information.

... here is additional info, if needed ...

Public Function GetItems(ByVal cartID As String) As SqlDataReader

Dim myConnection As SqlConnection = New
SqlConnection(ConfigurationSettings.AppSettings ("ConnectionString"))

Dim myCommand As SqlCommand = New SqlCommand ("ShoppingCartList",
myConnection)

myCommand.CommandType = CommandType.StoredProcedure

Dim parameterCartID As SqlParameter = New SqlParameter("@CartID",
SqlDbType.NVarChar, 50)

parameterCartID.Value = cartID

myCommand.Parameters.Add(parameterCartID)

myConnection.Open()

Dim result As SqlDataReader
myCommand.ExecuteReader(CommandBehavior.CloseConnection)

' Return the datareader result

Return result

End Function

///////////////

The sproc is here:

CREATE PROCEDURE [dbo].[ShoppingCartList]

@CartID nvarchar (50)

AS

SELECT dbo.Products.ProductID,
dbo.Products.ProductName,
dbo.ShoppingCart.Quantity,
dbo.Products.Price,
...

FROM dbo.Products INNER JOIN
dbo.ShoppingCart ON

Click to expand...

dbo.Products.ProductID

dbo.ShoppingCart.ProductID INNER JOIN
...

WHERE
Products.ProductID = ShoppingCart.ProductID
...

GO
_________________________________

Now I would like to bring this HTML code to code-behind page (.vb).

So, I have (the name is different because I had to use a FindControl
construct)

MailHyperLink.NavigateUrl = .... (Do I use the same quote, '<%

Click to expand...

#
.... %>'

..
what do I put here??)

How do I continue?

If you could also explain the "why" for your answer ,that

Click to expand...

would
be even

better.

TIA,

Paolo

Click to expand...

You don't use the script delimiters in codebehind.

Your codebehind file is pure code. Essentially, the task is to create
a page object that implements your particular task. In this case,
looks like you wish to fill a cart, which is a datagrid?

Looks like you already have the code for creating the sqldatareader.

The datagrid accepts the SqlDataReader as it's DataSource. Given:

Dim grid As DataGrid

You'd assign the reader as:

grid.DataSource = GetItems (someCartID)

then you need to bind the two

grid.DataBind()

Is this what you're talking about? If so, take a look at the .NET
examples for ADO, of which you can see 2 or 3 examples of this kind
of thing, using codebehind with asp.net datalist type controls.

http://samples.gotdotnet.com/quickstart/aspplus/

-- ipgrunt

Click to expand...

------=_NextPart_000_0008_01C51727.C29BF010
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859- 1">
<META content="MSHTML 6.00.3790.259" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV>Hello, and Thank you!</DIV>
<DIV> </DIV>
<DIV>Yes you are correct.  What I am trying to do
is to be able to access one of the fields of the DataGrid, (the StoreEmail one,
which is a hyperlink) and then add the other information about how the hyperlink
works, other parameters, so that I can pass it info such as StoreName,
ProductName etc... . The hyperlink then opens the email program (mailto with
the address, the subject, the itemnumber, etc... So, let's say that the
datagriod has colums Productname and email.  The Email link then opens an
email, and the Subject address and other stuff filled in.  If I just have a
DatgaGrid </DIV>
<DIV>
' Databind Gridcontrol with Shopping Cart
Items
dgShoppingCart.DataSource =
cart.GetItems(cartId)
dgShoppingCart.DataBind()
'TEST
Session("CartFull") = 1
'TEST
all the colums appear fine. I then add to the HTML
page the inline code
<asp:HyperLink id=HyperLink1 runat="server"
NavigateUrl='<%#"mailto:" &amp;
DataBinder.Eval(Container.DataItem,"StoreEmail") &amp; "&amp;Subject="
&amp; DataBinder.Eval(Container.DataItem,"ProductName") &amp; " ID="
&amp; DataBinder.Eval(Container.DataItem,"ProductID") &amp;
"&amp;Body=Test" &amp; DataBinder.Eval (Container.DataItem,"ProductName")
&amp; " ID=" &amp; DataBinder.Eval (Container.DataItem,"ProductID")
%>'>HyperLink</asp:HyperLink>
I get the hyperlinks the way I want them, everything
works fine
BUT.... Just out of an obtuse wish
to separate code better, I would like to put all the info in the HTML page in
the  .vb page.  
All and any further help is much
appreciated.
 
Paolo</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>"IPGrunt" <<A
href="mailto:[email protected]">[email protected]</A>> wrote in message
<A href="130.133.1.4">news:[email protected]

face=Arial size=2>...</DIV>> On 19 Feb 2005,
"Paolo Pignatelli" <<A href="mailto[email protected]">[email protected]</A>>
postulated > in <A
href="face=Arial
size=2>face=Arial
size=2>: > > > Yes, exactly, I am trying to bring the
DataBinding statements into > code > > behind. Is there also a
VB version of the article? > > > > TIA, >

> said:
> Paolo > > > > > > "Scott Allen"

< said:
href="mailto:[email protected]">[email protected]</A>> wrote
in message > > <A
href="news:[email protected]">... > >> Hi Paolo: > >>

>> Are you trying to bring the DataBinding statements into

code said:
behind? > >> > >> This article may provide some
insight: > >> <A
href="http://odetocode.com/Articles/278.aspx">http://odetocode.com/Articles/278.aspx</A> > >> > >> Let me know if I've misunderstood the
question... > >> > >> -- > >>

Scott said:
>> <A href="http://www.OdeToCode.com/blogs/scott/"> http://www.OdeToCode.com/blogs/scott/</A> > >> > >> On Sat, 19 Feb 2005 08:23:07 -0500, "Paolo
Pignatelli" > >> <<A
href="mailto[email protected]">[email protected]</A>>
wrote: > >> > >> >I have an aspx code behind page
that goes something like this in > the HTML > >>
>view: > >> > > >> > <asp:HyperLink
id=HyperLink1 runat="server" > >> > > >>
>NavigateUrl='<%#"mailto:" &amp; > >>
>DataBinder.Eval(Container.DataItem,"StoreEmail") &amp; >
"&amp;Subject=" > > &amp; > >>
>DataBinder.Eval(Container.DataItem,"ProductName") > > >
> > >> >... > >> > > > > >It
works. For each item in the datagrid, it displays the correct > >>
>information. > >> > > >> >... here is
additional info, if needed ... > >> > > > > >Public
Function GetItems(ByVal cartID As String) As SqlDataReader > >>
> > >> >Dim myConnection As SqlConnection = New

>> >SqlConnection(ConfigurationSettings.AppSettings >
("ConnectionString")) > >> > > >> >Dim myCommand
As SqlCommand = New SqlCommand("ShoppingCartList", > >>
>myConnection) > >> > > >>
>myCommand.CommandType = CommandType.StoredProcedure > >>
> > >> >Dim parameterCartID As SqlParameter = New
SqlParameter("@CartID", > >> >SqlDbType.NVarChar,

50) said:
>> > > >> >parameterCartID.Value = cartID

>> > > >>
>myCommand.Parameters.Add(parameterCartID) > >> >

>> >myConnection.Open() > >> > > > > >Dim
result As SqlDataReader = > >>
>myCommand.ExecuteReader(CommandBehavior.CloseConnection) > >>
> > >> >' Return the datareader result > >>
> > >> >Return result > >> > > >>
>End Function > >> > > >>
>/////////////// > >> > > >> >The sproc is
here: > >> > > >> >CREATE PROCEDURE
[dbo].[ShoppingCartList] > >> > > >> >@CartID
nvarchar (50) > >> > > >> >AS > >>
> > >> >SELECT    
dbo.Products.ProductID, > >>

>dbo.Products.ProductName said:
>> >dbo.ShoppingCart.Quantity, > >>
>dbo.Products.Price, > >> >... > >>

> said:
>> >FROM         dbo.Products
INNER JOIN > >>
>                      
dbo.ShoppingCart ON dbo.Products.ProductID > = > > >
>dbo.ShoppingCart.ProductID INNER JOIN > >>
>                  
... > >> > > >> > WHERE > > >
>        Products.ProductID =
ShoppingCart.ProductID > >> >

... said:
>> > > >> >GO > >>
>_________________________________ > >> > > >>
> > >> > > >> >Now I would like to bring this
HTML code to code-behind page > (.vb). > >> >

>> >So, I have (the name is different because I had to use

a said:
FindControl > >> >construct) > >> >

>> >MailHyperLink.NavigateUrl = .... (Do I use the same quote, '<%#
 > .... %>' > > .. > >> >what do I put
here??) > >> > > >> >How do I

continue? said:
>> > > >> >If you could also explain the "why" for your
answer ,that would > be even > >> >better.

>> > > >> >TIA, > >> > > >>
>Paolo > >> > > >> > > > >
 > > You don't use the script delimiters in

codebehind. said:
 > Your codebehind file is pure code. Essentially, the task is to create
 > a page object that implements your particular task. In this case,
 > looks like you wish to fill a cart, which is a datagrid?

> Looks like you already have the code for creating the
sqldatareader. > > The datagrid accepts the SqlDataReader as it's
DataSource. Given: > > Dim grid As DataGrid >

assign the reader as: > > grid.DataSource = GetItems
(someCartID) > > then you need to bind the two >

grid.DataBind() > > > Is this what you're talking about? If
so, take a look at the .NET > examples for ADO, of which you can see 2 or
3 examples of this kind > of thing, using codebehind with asp.net
datalist type controls. > > <A
href="http://samples.gotdotnet.com/quickstart/aspplus/">http://samples.gotdotnet.com/quickstart/aspplus/</A>

face=Arial size=2>> > -- ipgrunt</BODY></HTML>

------=_NextPart_000_0008_01C51727.C29BF010--

Honestly, I believe you are doing this correct way. In my philosophy
of code design, (which I believe is similar to M$ thinking), the
codebehind page serves up the data while the ASPX page formats and
displays the data.

But, if you really want to, you can build the values for the
Hyperlink control in codebehind. The overal scheme is to read the
SqlDataReader values and assign to the Webcontrol.

First you must read the SqlDataReader values....It is convenient to
place them in local variables for this example, (but not necessary)

Dim StoreEmail As String
Dim ProductName As String
Dim ProductID As Int

Then assume a SqlDataReader as so:

Dim SqlDataReader As myReader = cart.GetItems(cartId)

you need to test if it was successful:

If myReader.HasData Then

Then, inside this If statement, read the data.

myReader.Read()

This loads the reader with the first row of data (only one row if
your Sproc worked properly). You then read the values into your local
variables IN THE ORDER IN WHICH THEY ARE ASSIGNED WITHIN THE SPROC.
This is important. So, if your SQL statement is:

SELECT StoreEmail, ProductName, ProductID FROM Products WHERE
ProductID = @ProductID

then you read them in this order:

StoreEmail = myReader.GetString(0)
ProductName = myReader.GetString (1)
ProductID = myReader.GetInt32 (2)

Don't forget to close the reader...

myReader.Close()

(By the way, when you open the reader with the
CommandBehavior.CloseConnection argument, like this (in C#):

SqlDataReader rdr =
myCommand.ExecuteReader(CommandBehavior.CloseConnection);

then the connection will close when the reader closes. This is
important as you will usually return a reader from a business or data
object (using n-tier design), and no longer have access to the
connection. Even with garbage collection, you must close those
connections when finished with them.)

Now you can build your link string for the web control:

HyperLink1.NavigateUrl = "mailto: " & StoreEmail
& "&Subject=" & ProductName
& "&ID=" & ProductID.ToString()

When the codebehind finishes, the page is set with this link. You
might do this in the PageLoad method, or in the delegate responding
to a button push.

So, please excuse my syntactical mistakes in VB (I code in C# most of
the time), but I hope you get the idea.

Again, there is nothing wrong with how you are doing this in ASPX.
But, if you want to use codebehind, you can because of the wonderful
design of WebControls that make them all objects and how dotnet
provides access to all the fields.

Have fun!

-- ipgrunt

Paolo Pignatelli · Feb 21, 2005

Wow! Thank you ever so much not only for the programming help, but also in
explaining the philosophy of how the code is divided.

Paolo

(snip)

how to bind data provided in code-behind to a gridview?	3	Mar 12, 2010
how to access html <hr> in code-behind?	13	Mar 7, 2007
How to Execute Code Behind Code in Inline aspx	1	Oct 25, 2005
Refreshing client browsers (with javascript from asp.net code)	0	Feb 22, 2005
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may	4	Jun 3, 2004
How to add an attribute to a html control in code behind?	1	Aug 18, 2005
Guid handling	1	Jun 14, 2008
Image download upload display problems on aspx (code pasted in)	1	Dec 12, 2003

How to bring aspx code (in HTML view) to the aspx.vb code-behind?

Paolo Pignatelli

Scott Allen

Paolo Pignatelli

IPGrunt

Paolo Pignatelli

IPGrunt

Paolo Pignatelli

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads