freelanceprogrammers.org Forum Index » ASP

View previous topic :: View next topic

Re: aspclassic to ASP.NET ..................................

System-Administrator@... Posted: Mon Jan 03, 2005 10:47 am

Joined: 03 Jan 2005

Posts: 15

Re: aspclassic to ASP.NET ..................................

So far I did manage to get the repeater to work and made the member page
listing :)
http://webslave/btcNET/ViewBTCMemberIndex.aspx and thanks to al that have
help so far thank you.

I am not making my Sql String correctly I guess as the code below results in
an error also listed after the code. What I am attempting to do is just get
the record with the member that was clicked from the preceding page. Then I
will display it on the page.

<CODE>

`---------- Get Playingname from Querystring ------

Dim strPlayingName As String

strPlayingName = Request.QueryString("PlayingName")

Dim strSQLstring As String

strSQLstring = "SELECT * FROM tblBTC WHERE PlayingName LIKE " &
strPlayingName

`--------------------------------

`Create a DataAdapter ------------------------------------

Dim objDataAdapter As OleDbDataAdapter

`objDataAdapter = New OleDbDataAdapter("SELECT * FROM tblBTC", objConn)

objDataAdapter = New OleDbDataAdapter(strSQLstring, objConn)

</CODE>

Syntax error (missing operator) in query expression `PlayingName LIKE
Hudson[BTC]`.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing
operator) in query expression `PlayingName LIKE Hudson[BTC]`.

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:

[OleDbException (0x80040e14): Syntax error (missing operator) in query
expression `PlayingName LIKE Hudson[BTC]`.]

Mike Belcher
Independant Computer Consultant
Email: mbelcher@...

Have a nice day.
----- Original Message -----
From: "Ben Miller" <mylists@...>
To: <AspNetAnyQuestionIsOk@yahoogroups.com>
Sent: Wednesday, December 29, 2004 12:05 PM
Subject: Re: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET

>
> I have attached a Repeater definition that should work.
>
> This should generate the correct looking layout that you have on your site
> currently. All you need is a DataTable with the data using the same
> fieldnames that you had in your objRS("fieldname") stuff.
>
> Ben Miller
>
> ----- Original Message -----
> From: Ben Miller
> To: AspNetAnyQuestionIsOk@yahoogroups.com
> Sent: Wednesday, December 29, 2004 9:36 AM
> Subject: Re: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET
>
>
> Looking at the page referenced below, you have a great example of using a
> DataList or a Repeater control. DataList will generate beginning table
> and
> ending table tags and you can form the layout inside like you have. If
> you
> use a Repeater then you have full control of the HTML and table tags to
> get
> what you want.
>
> This is not that bad, as you would have a databinding statement wherever
> you
> have the objRS("fieldname") and the rest would remain the same.
>
> HTH. I will reply with a template if I get time today.
>
> Ben Miller
>
> ----- Original Message -----
> From: System-Administrator@...
> To: AspNetAnyQuestionIsOk@yahoogroups.com
> Sent: Tuesday, December 28, 2004 9:49 PM
> Subject: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET
>
>
> I am in the process of converting an aspclassic website I have over to
> asp.net before I do anything more with it. I would like it to do at least
> what it is able to do now. It has custom views I made with aspclassic and
> forms to edit etc.... I am having issues at the moment just making a
> simple
> connection to a .MDB file. I can go into server explorer and make the
> connection using visual studio .net no problem but its
> LONG....................... I also want to make data generate in the way
> it
> does not with asp classic. The site is www.belchingtoadclan.com and it is
> a
> little old but before adding more features to it I want to convert it
> over.
> Some things are confusing in how to get the same results in .net. Like a
> page to list the members of the gaming clan
>
> http://belchingtoadclan.gotdns.com/btc2/_Scripts/ViewBTCMemberIndex.asp
>
>
> that lists the members. How can I make the same custom type page
> generation in .net? If you click on a member there is another custom
> generated page. SO far in .net its datagrids etc but that isn`t what I
> need.
> Here is the code from the page listed above its OLD. As far as included
> content goes I got that figured out. Its the building of the page the way
> it
> is done now and making that happen in .NET - This is the best list there
> is
> so I posted here. Thank you.
>
>
> <CODE>
> <%@ Language=VBScript %>
> <% Option Explicit %>
> 
> 
>
> <HTML><head>
>
> <style>
> 
> </style>
>
> <STYLE>BODY {
> SCROLLBAR-FACE-COLOR: #000000; SCROLLBAR-HIGHLIGHT-COLOR: #000000;
> SCROLLBAR-SHADOW-COLOR: #000000; SCROLLBAR-ARROW-COLOR: #000000;
> SCROLLBAR-TRACK-COLOR: #000000; SCROLLBAR-DARKSHADOW-COLOR: #000000
> }
> </style>
>
> <style fprolloverstyle>A:hover {color: #00FF00; font-weight: bold}
> </style>
>
>
>
>
>
> </head>
> <body bgcolor="#000000" text="#C0C0C0" link="#FFFFFF" vlink="#FFFFFF"
> alink="#FFFFFF" background="../_Images/right.gif" bgproperties="fixed">
> <div align="center">
> <table border="0" cellpadding="0" cellspacing="0" width="572">
> <tr>
> <td>
> </td>
> </tr>
> <tr>
> <td>
> 
>  <div align="center">
> <div align="center">
> <table border="1" cellpadding="3" cellspacing="0" width="383"
> id="table3" bordercolorlight="#666666" bordercolordark="#333333">
> <tr>
> <td nowrap background="../_Images/Development/metal3Dark.gif">
> 
> Belching
> Toad Clan Members</td>
> </tr>
> </table>
> </div>
> </div>
> </td>
> </tr>
> </table>
> </div>
> <%
> `AUTHOR MIKE BELCHER
> `THIS WILL LIST THE MEMBERS
> %>
>
> <%
> `create a SQL statement to list the Events by ProgramStart
>
>
>
> Dim strSQL
> strSQL = "SELECT * FROM tblBTC" & " ORDER BY DateJoined"
>
> Dim objRS
> Set objRS = Server.CreateObject("ADODB.Recordset")
> objRS.Open strSQL, objConn
>
> Response.Write "<center><table border=""0"" width=""575""
> cellpadding=""0"" cellspacing=""0"" height=""303"">"
> Response.Write "<tr>"
> Response.Write "<td>"
>
> Dim strLink, strPlayingName, strLocation, strCounter, strEmail
> Response.Write " <center>"
>
> strCounter = 0
> Do While Not objRS.EOF
> strCounter = strCounter + 1
> strPlayingName = objRS("PlayingName")
> strEmail = objRS("Email")
> strPlayingName = Server.URLEncode(strPlayingName)
>
> strPlayingName=Replace(strPlayingName, "~", "%7E")` tilde
> strPlayingName=Replace(strPlayingName, "`", "%60")` `
> strPlayingName=Replace(strPlayingName, "!", "%21")` exclamation
> strPlayingName=Replace(strPlayingName, "@", "%40")` @
> strPlayingName=Replace(strPlayingName, "#", "%23")` pound
> strPlayingName=Replace(strPlayingName, "$", "%24")` dollar sign
> `strPlayingName=Replace(strPlayingName, "%", "%2525")` percent sign
> strPlayingName=Replace(strPlayingName, "^", "%5E")` exponent
> strPlayingName=Replace(strPlayingName, "&", "%26")` and
> strPlayingName=Replace(strPlayingName, "*", "%2A")` and
> strPlayingName=Replace(strPlayingName, "(", "%28")` (
> strPlayingName=Replace(strPlayingName, ")", "%29")` )
> strPlayingName=Replace(strPlayingName, ",", "%2C")` comma
> strPlayingName=Replace(strPlayingName, "`", "%27")` apostrophe
> strPlayingName=Replace(strPlayingName, "-", "%2D")` dash
> strPlayingName=Replace(strPlayingName, "_", "%5F")` underscore
> strPlayingName=Replace(strPlayingName, "+", "%20")` plus
> strPlayingName=Replace(strPlayingName, "=", "%3D")` equal
> strPlayingName=Replace(strPlayingName, "{", "%7B")` left bracket
> strPlayingName=Replace(strPlayingName, "}", "%7D")` right bracket
> strPlayingName=Replace(strPlayingName, "[", "%5B")` [
> strPlayingName=Replace(strPlayingName, "]", "%5D")` [
> strPlayingName=Replace(strPlayingName, "|", "%7C")` |
> strPlayingName=Replace(strPlayingName, "", "%5C")`
> strPlayingName=Replace(strPlayingName, "/", "%2F")` /
> strPlayingName=Replace(strPlayingName, ":", "%3A")` :
> strPlayingName=Replace(strPlayingName, ";", "%3B")` ;
> `strPlayingName=Replace(strPlayingName, """, "%22")` qoute
> strPlayingName=Replace(strPlayingName, "<", "%3C")` <
> strPlayingName=Replace(strPlayingName, ">", "%3E")` >
> strPlayingName=Replace(strPlayingName, ".", "%2E")` .
>
>
> Response.Write "<table border=""0"" width=""780"" cellpadding=""3""
> cellspacing=""3"" id=""table2""><tr>"
> Response.Write "<td width=""50""
> background=""../_Images/Development/bg2.gif""> </td><td>"
> Response.Write "<div align=""center"">"
> Response.Write "<table border=""2"" cellpadding=""3"" cellspacing=""0""
> width=""100%"" align=""left"" id=""table3""
> background=""../_Images/Development/metal3Dark.gif""
> bordercolorlight=""#666666"" bordercolordark=""#333333""
> bgcolor=""#292929"">"
> Response.Write "<tr>"
> Response.Write "<td><BIG><BIG>"
> Response.Write ""
> Response.Write "<a href=`../_scripts/ViewBTCMemberfromindex.asp?" &
> objRS("PlayingName") & "`>" & objRS("PlayingName") &
> "<a/></BIG></BIG>"
> Response.Write " size=""2""> "
> Response.Write "JOINED: " &
> objRS("DateJoined") & " "
> Response.Write " color=""#008000"">NAME:" & objRS("Name") &
> ""
> Response.Write " "
> Response.Write " color=""#008000"">AGE: " & objRS("Age") &
> ""
> Response.Write " "
> Response.Write " size=""2"">LOCATION: " & objRS("Location")
> &
> ""
> Response.Write " color=""#0080FF""> "
> Response.Write " size=""2"">EMAIL: <a href=`mailto:" &
> strEmail & "?Subject=Mail from BelchingToadClan Members Page`>" &
> objRS("Email") & "</a>"
> Response.Write " color=""#008000""> "
> Response.Write " size=""2"">AIM: <A
> href=""aim:goim?screenname=" & objRS("Aim") & """>" & objRS("Aim") &
> "</A> "
> Response.Write " color=""#008000"">ICQ:" & objRS("Icq") &
> " "
> Response.Write "CONNECTION: size=""2""
> color=""#00FF00"">" & objRS("Connect") & ""
> Response.Write "</td>"
> Response.Write "</tr>"
> Response.Write "</table>"
> Response.Write "</div>"
> Response.Write " </td>"
> Response.Write "<td width=""268""
> background=""../_Images/Development/bg2.gif"">"
> Response.Write " </td></tr><tr>"
> Response.Write "<td width=""50"">"
> Response.Write " "
> Response.Write " </td><td>"
> Response.Write " </td>"
> Response.Write "<td width=""268"">"
> Response.Write " </td></tr></table>"
>
>
>
> `Response.Write "<img src=""../_Images/sarge.gif"" width=""21""
> height=""32"" border=""0""><BIG><BIG><a class=""roll""
> href=`../_scripts/ViewBTCMemberfromindex.asp?" & objRS("PlayingName") &
> "`>"
> & objRS("PlayingName") & "</a></BIG></BIG> "
> `Response.Write "" &
> objRS("Location") & " "
> `Response.Write "<a href=`mailto:" & strEmail & "?Subject=Mail
> from
> BelchingToadClan Members Page`>" & objRS("Email") & "</a>"
> `Response.Write " "
> objRS.MoveNext
> Loop
> `Response.Write "<BIG>THERE ARE CURRENTLY [" & strCounter & "] BTC
> MEMBERS</BIG> "
> `Response.Write "</td>"
> `Response.Write "</tr><tr><td width=""575""></td></table>"
>
>
> %>
>
>  
>
> <%
> objRS.Close
> Set objRS = Nothing
> objConn.Close
> Set objConn = Nothing
> %>
> 
> 
> </BODY>
> </HTML>
> </CODE>
>
>
>
> Mike Belcher
> Independant Computer Consultant
>
> Email: mbelcher@...
>
>
> [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
> ------------------------------------------------------------------------------
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
>
> b.. To unsubscribe from this group, send an email to:
> AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
> AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> ----------
>
> <asp:Repeater id="ClanMembersList" runat="server">
> <HeaderTemplate>
> <table border="0" width="780" cellpadding="3" cellspacing="3">
> <tr>
> </HeaderTemplate>
> <ItemTemplate>
> <td width="50" background="../_Images/Development/bg2.gif"> </td>
> <td>
> <div align="center">
> <table border="2" cellpadding="3" cellspacing="0" width="100%"
> align="left" id="table3"
> background="../_Images/Development/metal3Dark.gif"
> bordercolorlight="#666666" bordercolordark="#333333" bgcolor="#292929">
> <tr>
> <td><BIG><BIG>
> 
> <a href=`../_scripts/ViewBTCMemberfromindex.asp?<%#
> DataBinder.Eval(Container.DataItem, "PlayingName") %>`><%#
> DataBinder.Eval(Container.DataItem, "PlayingName")
> %><a/></BIG></BIG>
> 
> JOINED: <%# DataBinder.Eval(Container.DataItem,
> "DateJoined") %> 
> NAME: color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Name")
> %>
> 
> AGE: color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Age")
> %>
> 
> LOCATION: color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Location")
> %>
> 
> EMAIL: color="#00ff00"><a href=`mailto:<%# DataBinder.Eval(Container.DataItem,
> "Email") %>?Subject=Mail from BelchingToadClan Members Page`><%#
> DataBinder.Eval(Container.DataItem, "Email") %></a>
> 
> AIM: color="#00ff00"><A href=`aim:goim?screenname=<%#
> DataBinder.Eval(Container.DataItem, "Aim") %>`><%#
> DataBinder.Eval(Container.DataItem, "Aim") %></A> 
> ICQ: color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Icq")
> %> 
> CONNECTION:<%#
> DataBinder.Eval(Container.DataItem, "Connect") %>
> </td>
> </tr>
> </table>
> </div> 
> </td>
> <td width="268" background="../_Images/Development/bg2.gif"> </td>
> </tr>
> <tr>
> <td width="50">
>  
> </td>
> <td> 
> </td>
> <td width="268"> 
> </td>
> </ItemTemplate>
> <FooterTemplate>
> </tr>
> </table>
> </FooterTemplate>
> </asp:Repeater>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

jamil_h_t Posted: Mon Jan 03, 2005 2:32 pm

Joined: 07 Jan 2006

Posts: 7

Re: aspclassic to ASP.NET ..................................

hi all , how can i store an array after the postback in vb.net , if it is as
view state how can i use it

thank`s

---------------------------------
Do you Yahoo!?
All your favorites on one personal page � Try My Yahoo!

[Non-text portions of this message have been removed]

ben4miller Posted: Mon Jan 03, 2005 7:16 pm

Joined: 05 Jan 2005

Posts: 3

Re: aspclassic to ASP.NET ..................................

You need to put ` (single quotes) around the data.

SELECT * FROM tblBTC WHERE PlayingName LIKE `" & strPlayingName & "`"

the above looks like (singlequote)(doublequote) & strPlayingName &
(doublequote)(singlequote)(doublequote)

The delimiter when using strings is the single quote.

Ben Miller

----- Original Message -----
From: System-Administrator@...
To: AspNetAnyQuestionIsOk@yahoogroups.com
Sent: Sunday, January 02, 2005 9:47 PM
Subject: Re: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET
.....................................

So far I did manage to get the repeater to work and made the member page
listing :)
http://webslave/btcNET/ViewBTCMemberIndex.aspx and thanks to al that have
help so far thank you.

I am not making my Sql String correctly I guess as the code below results in
an error also listed after the code. What I am attempting to do is just get
the record with the member that was clicked from the preceding page. Then I
will display it on the page.

<CODE>

`---------- Get Playingname from Querystring ------

Dim strPlayingName As String

strPlayingName = Request.QueryString("PlayingName")

Dim strSQLstring As String

strSQLstring = "SELECT * FROM tblBTC WHERE PlayingName LIKE " &
strPlayingName

`--------------------------------

`Create a DataAdapter ------------------------------------

Dim objDataAdapter As OleDbDataAdapter

`objDataAdapter = New OleDbDataAdapter("SELECT * FROM tblBTC", objConn)

objDataAdapter = New OleDbDataAdapter(strSQLstring, objConn)

</CODE>

Syntax error (missing operator) in query expression `PlayingName LIKE
Hudson[BTC]`.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing
operator) in query expression `PlayingName LIKE Hudson[BTC]`.

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:

[OleDbException (0x80040e14): Syntax error (missing operator) in query
expression `PlayingName LIKE Hudson[BTC]`.]

Mike Belcher
Independant Computer Consultant
Email: mbelcher@...

Have a nice day.
----- Original Message -----
From: "Ben Miller" <mylists@...>
To: <AspNetAnyQuestionIsOk@yahoogroups.com>
Sent: Wednesday, December 29, 2004 12:05 PM
Subject: Re: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET

>
> I have attached a Repeater definition that should work.
>
> This should generate the correct looking layout that you have on your site
> currently. All you need is a DataTable with the data using the same
> fieldnames that you had in your objRS("fieldname") stuff.
>
> Ben Miller
>
> ----- Original Message -----
> From: Ben Miller
> To: AspNetAnyQuestionIsOk@yahoogroups.com
> Sent: Wednesday, December 29, 2004 9:36 AM
> Subject: Re: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET
>
>
> Looking at the page referenced below, you have a great example of using a
> DataList or a Repeater control. DataList will generate beginning table
> and
> ending table tags and you can form the layout inside like you have. If
> you
> use a Repeater then you have full control of the HTML and table tags to
> get
> what you want.
>
> This is not that bad, as you would have a databinding statement wherever
> you
> have the objRS("fieldname") and the rest would remain the same.
>
> HTH. I will reply with a template if I get time today.
>
> Ben Miller
>
> ----- Original Message -----
> From: System-Administrator@...
> To: AspNetAnyQuestionIsOk@yahoogroups.com
> Sent: Tuesday, December 28, 2004 9:49 PM
> Subject: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET
>
>
> I am in the process of converting an aspclassic website I have over to
> asp.net before I do anything more with it. I would like it to do at least
> what it is able to do now. It has custom views I made with aspclassic and
> forms to edit etc.... I am having issues at the moment just making a
> simple
> connection to a .MDB file. I can go into server explorer and make the
> connection using visual studio .net no problem but its
> LONG....................... I also want to make data generate in the way
> it
> does not with asp classic. The site is www.belchingtoadclan.com and it is
> a
> little old but before adding more features to it I want to convert it
> over.
> Some things are confusing in how to get the same results in .net. Like a
> page to list the members of the gaming clan
>
> http://belchingtoadclan.gotdns.com/btc2/_Scripts/ViewBTCMemberIndex.asp
>
>
> that lists the members. How can I make the same custom type page
> generation in .net? If you click on a member there is another custom
> generated page. SO far in .net its datagrids etc but that isn`t what I
> need.
> Here is the code from the page listed above its OLD. As far as included
> content goes I got that figured out. Its the building of the page the way
> it
> is done now and making that happen in .NET - This is the best list there
> is
> so I posted here. Thank you.
>
>
> <CODE>
> <%@ Language=VBScript %>
> <% Option Explicit %>
> 
> 
>
> <HTML><head>
>
> <style>
> 
> </style>
>
> <STYLE>BODY {
> SCROLLBAR-FACE-COLOR: #000000; SCROLLBAR-HIGHLIGHT-COLOR: #000000;
> SCROLLBAR-SHADOW-COLOR: #000000; SCROLLBAR-ARROW-COLOR: #000000;
> SCROLLBAR-TRACK-COLOR: #000000; SCROLLBAR-DARKSHADOW-COLOR: #000000
> }
> </style>
>
> <style fprolloverstyle>A:hover {color: #00FF00; font-weight: bold}
> </style>
>
>
>
>
>
> </head>
> <body bgcolor="#000000" text="#C0C0C0" link="#FFFFFF" vlink="#FFFFFF"
> alink="#FFFFFF" background="../_Images/right.gif" bgproperties="fixed">
> <div align="center">
> <table border="0" cellpadding="0" cellspacing="0" width="572">
> <tr>
> <td>
> </td>
> </tr>
> <tr>
> <td>
> 
>  <div align="center">
> <div align="center">
> <table border="1" cellpadding="3" cellspacing="0" width="383"
> id="table3" bordercolorlight="#666666" bordercolordark="#333333">
> <tr>
> <td nowrap background="../_Images/Development/metal3Dark.gif">
> 
> Belching
> Toad Clan Members</td>
> </tr>
> </table>
> </div>
> </div>
> </td>
> </tr>
> </table>
> </div>
> <%
> `AUTHOR MIKE BELCHER
> `THIS WILL LIST THE MEMBERS
> %>
>
> <%
> `create a SQL statement to list the Events by ProgramStart
>
>
>
> Dim strSQL
> strSQL = "SELECT * FROM tblBTC" & " ORDER BY DateJoined"
>
> Dim objRS
> Set objRS = Server.CreateObject("ADODB.Recordset")
> objRS.Open strSQL, objConn
>
> Response.Write "<center><table border=""0"" width=""575""
> cellpadding=""0"" cellspacing=""0"" height=""303"">"
> Response.Write "<tr>"
> Response.Write "<td>"
>
> Dim strLink, strPlayingName, strLocation, strCounter, strEmail
> Response.Write " <center>"
>
> strCounter = 0
> Do While Not objRS.EOF
> strCounter = strCounter + 1
> strPlayingName = objRS("PlayingName")
> strEmail = objRS("Email")
> strPlayingName = Server.URLEncode(strPlayingName)
>
> strPlayingName=Replace(strPlayingName, "~", "%7E")` tilde
> strPlayingName=Replace(strPlayingName, "`", "%60")` `
> strPlayingName=Replace(strPlayingName, "!", "%21")` exclamation
> strPlayingName=Replace(strPlayingName, "@", "%40")` @
> strPlayingName=Replace(strPlayingName, "#", "%23")` pound
> strPlayingName=Replace(strPlayingName, "$", "%24")` dollar sign
> `strPlayingName=Replace(strPlayingName, "%", "%2525")` percent sign
> strPlayingName=Replace(strPlayingName, "^", "%5E")` exponent
> strPlayingName=Replace(strPlayingName, "&", "%26")` and
> strPlayingName=Replace(strPlayingName, "*", "%2A")` and
> strPlayingName=Replace(strPlayingName, "(", "%28")` (
> strPlayingName=Replace(strPlayingName, ")", "%29")` )
> strPlayingName=Replace(strPlayingName, ",", "%2C")` comma
> strPlayingName=Replace(strPlayingName, "`", "%27")` apostrophe
> strPlayingName=Replace(strPlayingName, "-", "%2D")` dash
> strPlayingName=Replace(strPlayingName, "_", "%5F")` underscore
> strPlayingName=Replace(strPlayingName, "+", "%20")` plus
> strPlayingName=Replace(strPlayingName, "=", "%3D")` equal
> strPlayingName=Replace(strPlayingName, "{", "%7B")` left bracket
> strPlayingName=Replace(strPlayingName, "}", "%7D")` right bracket
> strPlayingName=Replace(strPlayingName, "[", "%5B")` [
> strPlayingName=Replace(strPlayingName, "]", "%5D")` [
> strPlayingName=Replace(strPlayingName, "|", "%7C")` |
> strPlayingName=Replace(strPlayingName, "", "%5C")`
> strPlayingName=Replace(strPlayingName, "/", "%2F")` /
> strPlayingName=Replace(strPlayingName, ":", "%3A")` :
> strPlayingName=Replace(strPlayingName, ";", "%3B")` ;
> `strPlayingName=Replace(strPlayingName, """, "%22")` qoute
> strPlayingName=Replace(strPlayingName, "<", "%3C")` <
> strPlayingName=Replace(strPlayingName, ">", "%3E")` >
> strPlayingName=Replace(strPlayingName, ".", "%2E")` .
>
>
> Response.Write "<table border=""0"" width=""780"" cellpadding=""3""
> cellspacing=""3"" id=""table2""><tr>"
> Response.Write "<td width=""50""
> background=""../_Images/Development/bg2.gif""> </td><td>"
> Response.Write "<div align=""center"">"
> Response.Write "<table border=""2"" cellpadding=""3"" cellspacing=""0""
> width=""100%"" align=""left"" id=""table3""
> background=""../_Images/Development/metal3Dark.gif""
> bordercolorlight=""#666666"" bordercolordark=""#333333""
> bgcolor=""#292929"">"
> Response.Write "<tr>"
> Response.Write "<td><BIG><BIG>"
> Response.Write ""
> Response.Write "<a href=`../_scripts/ViewBTCMemberfromindex.asp?" &
> objRS("PlayingName") & "`>" & objRS("PlayingName") &
> "<a/></BIG></BIG>"
> Response.Write " size=""2""> "
> Response.Write "JOINED: " &
> objRS("DateJoined") & " "
> Response.Write " color=""#008000"">NAME:" & objRS("Name") &
> ""
> Response.Write " "
> Response.Write " color=""#008000"">AGE: " & objRS("Age") &
> ""
> Response.Write " "
> Response.Write " size=""2"">LOCATION: " & objRS("Location")
> &
> ""
> Response.Write " color=""#0080FF""> "
> Response.Write " size=""2"">EMAIL: <a href=`mailto:" &
> strEmail & "?Subject=Mail from BelchingToadClan Members Page`>" &
> objRS("Email") & "</a>"
> Response.Write " color=""#008000""> "
> Response.Write " size=""2"">AIM: <A
> href=""aim:goim?screenname=" & objRS("Aim") & """>" & objRS("Aim") &
> "</A> "
> Response.Write " color=""#008000"">ICQ:" & objRS("Icq") &
> " "
> Response.Write "CONNECTION: size=""2""
> color=""#00FF00"">" & objRS("Connect") & ""
> Response.Write "</td>"
> Response.Write "</tr>"
> Response.Write "</table>"
> Response.Write "</div>"
> Response.Write " </td>"
> Response.Write "<td width=""268""
> background=""../_Images/Development/bg2.gif"">"
> Response.Write " </td></tr><tr>"
> Response.Write "<td width=""50"">"
> Response.Write " "
> Response.Write " </td><td>"
> Response.Write " </td>"
> Response.Write "<td width=""268"">"
> Response.Write " </td></tr></table>"
>
>
>
> `Response.Write "<img src=""../_Images/sarge.gif"" width=""21""
> height=""32"" border=""0""><BIG><BIG><a class=""roll""
> href=`../_scripts/ViewBTCMemberfromindex.asp?" & objRS("PlayingName") &
> "`>"
> & objRS("PlayingName") & "</a></BIG></BIG> "
> `Response.Write "" &
> objRS("Location") & " "
> `Response.Write "<a href=`mailto:" & strEmail & "?Subject=Mail
> from
> BelchingToadClan Members Page`>" & objRS("Email") & "</a>"
> `Response.Write " "
> objRS.MoveNext
> Loop
> `Response.Write "<BIG>THERE ARE CURRENTLY [" & strCounter & "] BTC
> MEMBERS</BIG> "
> `Response.Write "</td>"
> `Response.Write "</tr><tr><td width=""575""></td></table>"
>
>
> %>
>
>  
>
> <%
> objRS.Close
> Set objRS = Nothing
> objConn.Close
> Set objConn = Nothing
> %>
> 
> 
> </BODY>
> </HTML>
> </CODE>
>
>
>
> Mike Belcher
> Independant Computer Consultant
>
> Email: mbelcher@...
>
>
> [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
> ------------------------------------------------------------------------------
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
>
> b.. To unsubscribe from this group, send an email to:
> AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
> AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> ----------
>
> <asp:Repeater id="ClanMembersList" runat="server">
> <HeaderTemplate>
> <table border="0" width="780" cellpadding="3" cellspacing="3">
> <tr>
> </HeaderTemplate>
> <ItemTemplate>
> <td width="50" background="../_Images/Development/bg2.gif"> </td>
> <td>
> <div align="center">
> <table border="2" cellpadding="3" cellspacing="0" width="100%"
> align="left" id="table3"
> background="../_Images/Development/metal3Dark.gif"
> bordercolorlight="#666666" bordercolordark="#333333" bgcolor="#292929">
> <tr>
> <td><BIG><BIG>
> 
> <a href=`../_scripts/ViewBTCMemberfromindex.asp?<%#
> DataBinder.Eval(Container.DataItem, "PlayingName") %>`><%#
> DataBinder.Eval(Container.DataItem, "PlayingName")
> %><a/></BIG></BIG>
> 
> JOINED: <%# DataBinder.Eval(Container.DataItem,
> "DateJoined") %> 
> NAME: color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Name")
> %>
> 
> AGE: color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Age")
> %>
> 
> LOCATION: color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Location")
> %>
> 
> EMAIL: color="#00ff00"><a href=`mailto:<%# DataBinder.Eval(Container.DataItem,
> "Email") %>?Subject=Mail from BelchingToadClan Members Page`><%#
> DataBinder.Eval(Container.DataItem, "Email") %></a>
> 
> AIM: color="#00ff00"><A href=`aim:goim?screenname=<%#
> DataBinder.Eval(Container.DataItem, "Aim") %>`><%#
> DataBinder.Eval(Container.DataItem, "Aim") %></A> 
> ICQ: color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Icq")
> %> 
> CONNECTION:<%#
> DataBinder.Eval(Container.DataItem, "Connect") %>
> </td>
> </tr>
> </table>
> </div> 
> </td>
> <td width="268" background="../_Images/Development/bg2.gif"> </td>
> </tr>
> <tr>
> <td width="50">
>  
> </td>
> <td> 
> </td>
> <td width="268"> 
> </td>
> </ItemTemplate>
> <FooterTemplate>
> </tr>
> </table>
> </FooterTemplate>
> </asp:Repeater>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/

To unsubscribe from this group, send an email to:
AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

System-Administrator@... Posted: Tue Jan 04, 2005 2:20 am

Joined: 03 Jan 2005

Posts: 15

Re: aspclassic to ASP.NET ..................................

I knew it was something simple I was not doing. It was late at night and was
tired :) Thanks.

Have a nice day.
----- Original Message -----
From: "Ben Miller" <mylists@...>
To: <AspNetAnyQuestionIsOk@yahoogroups.com>
Sent: Monday, January 03, 2005 8:16 AM
Subject: Re: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET
.....................................

>
> You need to put ` (single quotes) around the data.
>
> SELECT * FROM tblBTC WHERE PlayingName LIKE `" & strPlayingName & "`"
>
> the above looks like (singlequote)(doublequote) & strPlayingName &
> (doublequote)(singlequote)(doublequote)
>
> The delimiter when using strings is the single quote.
>
> Ben Miller
>
> ----- Original Message -----
> From: System-Administrator@...
> To: AspNetAnyQuestionIsOk@yahoogroups.com
> Sent: Sunday, January 02, 2005 9:47 PM
> Subject: Re: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET
> .....................................
>
>
> So far I did manage to get the repeater to work and made the member page
> listing :)
> http://webslave/btcNET/ViewBTCMemberIndex.aspx and thanks to al that have
> help so far thank you.
>
>
> I am not making my Sql String correctly I guess as the code below results
> in
> an error also listed after the code. What I am attempting to do is just
> get
> the record with the member that was clicked from the preceding page. Then
> I
> will display it on the page.
>
>
> <CODE>
>
>
> `---------- Get Playingname from Querystring ------
>
> Dim strPlayingName As String
>
> strPlayingName = Request.QueryString("PlayingName")
>
>
>
> Dim strSQLstring As String
>
> strSQLstring = "SELECT * FROM tblBTC WHERE PlayingName LIKE " &
> strPlayingName
>
> `--------------------------------
>
>
>
> `Create a DataAdapter ------------------------------------
>
> Dim objDataAdapter As OleDbDataAdapter
>
> `objDataAdapter = New OleDbDataAdapter("SELECT * FROM tblBTC", objConn)
>
> objDataAdapter = New OleDbDataAdapter(strSQLstring, objConn)
>
>
> </CODE>
>
>
>
>
> Syntax error (missing operator) in query expression `PlayingName LIKE
> Hudson[BTC]`.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
>
> Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing
> operator) in query expression `PlayingName LIKE Hudson[BTC]`.
>
> Source Error:
>
> An unhandled exception was generated during the execution of the
> current web request. Information regarding the origin and location of the
> exception can be identified using the exception stack trace below.
>
> Stack Trace:
>
> [OleDbException (0x80040e14): Syntax error (missing operator) in query
> expression `PlayingName LIKE Hudson[BTC]`.]
>
>
>
>
>
> Mike Belcher
> Independant Computer Consultant
> Email: mbelcher@...
>
>
>
> Have a nice day.
> ----- Original Message -----
> From: "Ben Miller" <mylists@...>
> To: <AspNetAnyQuestionIsOk@yahoogroups.com>
> Sent: Wednesday, December 29, 2004 12:05 PM
> Subject: Re: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET
>
>
>>
>> I have attached a Repeater definition that should work.
>>
>> This should generate the correct looking layout that you have on your
>> site
>> currently. All you need is a DataTable with the data using the same
>> fieldnames that you had in your objRS("fieldname") stuff.
>>
>> Ben Miller
>>
>> ----- Original Message -----
>> From: Ben Miller
>> To: AspNetAnyQuestionIsOk@yahoogroups.com
>> Sent: Wednesday, December 29, 2004 9:36 AM
>> Subject: Re: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET
>>
>>
>> Looking at the page referenced below, you have a great example of using a
>> DataList or a Repeater control. DataList will generate beginning table
>> and
>> ending table tags and you can form the layout inside like you have. If
>> you
>> use a Repeater then you have full control of the HTML and table tags to
>> get
>> what you want.
>>
>> This is not that bad, as you would have a databinding statement wherever
>> you
>> have the objRS("fieldname") and the rest would remain the same.
>>
>> HTH. I will reply with a template if I get time today.
>>
>> Ben Miller
>>
>> ----- Original Message -----
>> From: System-Administrator@...
>> To: AspNetAnyQuestionIsOk@yahoogroups.com
>> Sent: Tuesday, December 28, 2004 9:49 PM
>> Subject: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET
>>
>>
>> I am in the process of converting an aspclassic website I have over to
>> asp.net before I do anything more with it. I would like it to do at least
>> what it is able to do now. It has custom views I made with aspclassic and
>> forms to edit etc.... I am having issues at the moment just making a
>> simple
>> connection to a .MDB file. I can go into server explorer and make the
>> connection using visual studio .net no problem but its
>> LONG....................... I also want to make data generate in the way
>> it
>> does not with asp classic. The site is www.belchingtoadclan.com and it is
>> a
>> little old but before adding more features to it I want to convert it
>> over.
>> Some things are confusing in how to get the same results in .net. Like a
>> page to list the members of the gaming clan
>>
>> http://belchingtoadclan.gotdns.com/btc2/_Scripts/ViewBTCMemberIndex.asp
>>
>>
>> that lists the members. How can I make the same custom type page
>> generation in .net? If you click on a member there is another custom
>> generated page. SO far in .net its datagrids etc but that isn`t what I
>> need.
>> Here is the code from the page listed above its OLD. As far as included
>> content goes I got that figured out. Its the building of the page the way
>> it
>> is done now and making that happen in .NET - This is the best list there
>> is
>> so I posted here. Thank you.
>>
>>
>> <CODE>
>> <%@ Language=VBScript %>
>> <% Option Explicit %>
>> 
>> 
>>
>> <HTML><head>
>>
>> <style>
>> 
>> </style>
>>
>> <STYLE>BODY {
>> SCROLLBAR-FACE-COLOR: #000000; SCROLLBAR-HIGHLIGHT-COLOR: #000000;
>> SCROLLBAR-SHADOW-COLOR: #000000; SCROLLBAR-ARROW-COLOR: #000000;
>> SCROLLBAR-TRACK-COLOR: #000000; SCROLLBAR-DARKSHADOW-COLOR: #000000
>> }
>> </style>
>>
>> <style fprolloverstyle>A:hover {color: #00FF00; font-weight: bold}
>> </style>
>>
>>
>>
>>
>>
>> </head>
>> <body bgcolor="#000000" text="#C0C0C0" link="#FFFFFF" vlink="#FFFFFF"
>> alink="#FFFFFF" background="../_Images/right.gif" bgproperties="fixed">
>> <div align="center">
>> <table border="0" cellpadding="0" cellspacing="0" width="572">
>> <tr>
>> <td>
>> </td>
>> </tr>
>> <tr>
>> <td>
>> 
>>  <div align="center">
>> <div align="center">
>> <table border="1" cellpadding="3" cellspacing="0" width="383"
>> id="table3" bordercolorlight="#666666" bordercolordark="#333333">
>> <tr>
>> <td nowrap background="../_Images/Development/metal3Dark.gif">
>> 
>> Belching
>> Toad Clan Members</td>
>> </tr>
>> </table>
>> </div>
>> </div>
>> </td>
>> </tr>
>> </table>
>> </div>
>> <%
>> `AUTHOR MIKE BELCHER
>> `THIS WILL LIST THE MEMBERS
>> %>
>>
>> <%
>> `create a SQL statement to list the Events by ProgramStart
>>
>>
>>
>> Dim strSQL
>> strSQL = "SELECT * FROM tblBTC" & " ORDER BY DateJoined"
>>
>> Dim objRS
>> Set objRS = Server.CreateObject("ADODB.Recordset")
>> objRS.Open strSQL, objConn
>>
>> Response.Write "<center><table border=""0"" width=""575""
>> cellpadding=""0"" cellspacing=""0"" height=""303"">"
>> Response.Write "<tr>"
>> Response.Write "<td>"
>>
>> Dim strLink, strPlayingName, strLocation, strCounter, strEmail
>> Response.Write " <center>"
>>
>> strCounter = 0
>> Do While Not objRS.EOF
>> strCounter = strCounter + 1
>> strPlayingName = objRS("PlayingName")
>> strEmail = objRS("Email")
>> strPlayingName = Server.URLEncode(strPlayingName)
>>
>> strPlayingName=Replace(strPlayingName, "~", "%7E")` tilde
>> strPlayingName=Replace(strPlayingName, "`", "%60")` `
>> strPlayingName=Replace(strPlayingName, "!", "%21")` exclamation
>> strPlayingName=Replace(strPlayingName, "@", "%40")` @
>> strPlayingName=Replace(strPlayingName, "#", "%23")` pound
>> strPlayingName=Replace(strPlayingName, "$", "%24")` dollar sign
>> `strPlayingName=Replace(strPlayingName, "%", "%2525")` percent sign
>> strPlayingName=Replace(strPlayingName, "^", "%5E")` exponent
>> strPlayingName=Replace(strPlayingName, "&", "%26")` and
>> strPlayingName=Replace(strPlayingName, "*", "%2A")` and
>> strPlayingName=Replace(strPlayingName, "(", "%28")` (
>> strPlayingName=Replace(strPlayingName, ")", "%29")` )
>> strPlayingName=Replace(strPlayingName, ",", "%2C")` comma
>> strPlayingName=Replace(strPlayingName, "`", "%27")` apostrophe
>> strPlayingName=Replace(strPlayingName, "-", "%2D")` dash
>> strPlayingName=Replace(strPlayingName, "_", "%5F")` underscore
>> strPlayingName=Replace(strPlayingName, "+", "%20")` plus
>> strPlayingName=Replace(strPlayingName, "=", "%3D")` equal
>> strPlayingName=Replace(strPlayingName, "{", "%7B")` left bracket
>> strPlayingName=Replace(strPlayingName, "}", "%7D")` right bracket
>> strPlayingName=Replace(strPlayingName, "[", "%5B")` [
>> strPlayingName=Replace(strPlayingName, "]", "%5D")` [
>> strPlayingName=Replace(strPlayingName, "|", "%7C")` |
>> strPlayingName=Replace(strPlayingName, "", "%5C")`
>> strPlayingName=Replace(strPlayingName, "/", "%2F")` /
>> strPlayingName=Replace(strPlayingName, ":", "%3A")` :
>> strPlayingName=Replace(strPlayingName, ";", "%3B")` ;
>> `strPlayingName=Replace(strPlayingName, """, "%22")` qoute
>> strPlayingName=Replace(strPlayingName, "<", "%3C")` <
>> strPlayingName=Replace(strPlayingName, ">", "%3E")` >
>> strPlayingName=Replace(strPlayingName, ".", "%2E")` .
>>
>>
>> Response.Write "<table border=""0"" width=""780"" cellpadding=""3""
>> cellspacing=""3"" id=""table2""><tr>"
>> Response.Write "<td width=""50""
>> background=""../_Images/Development/bg2.gif""> </td><td>"
>> Response.Write "<div align=""center"">"
>> Response.Write "<table border=""2"" cellpadding=""3"" cellspacing=""0""
>> width=""100%"" align=""left"" id=""table3""
>> background=""../_Images/Development/metal3Dark.gif""
>> bordercolorlight=""#666666"" bordercolordark=""#333333""
>> bgcolor=""#292929"">"
>> Response.Write "<tr>"
>> Response.Write "<td><BIG><BIG>"
>> Response.Write ""
>> Response.Write "<a href=`../_scripts/ViewBTCMemberfromindex.asp?" &
>> objRS("PlayingName") & "`>" & objRS("PlayingName") &
>> "<a/></BIG></BIG>"
>> Response.Write "> size=""2""> "
>> Response.Write "JOINED: " &
>> objRS("DateJoined") & " "
>> Response.Write "> color=""#008000"">NAME:" & objRS("Name") &
>> ""
>> Response.Write "> size=""4""> "
>> Response.Write "> color=""#008000"">AGE: " & objRS("Age") &
>> ""
>> Response.Write " "
>> Response.Write "> size=""2"">LOCATION: " & objRS("Location")
>> &
>> ""
>> Response.Write "> color=""#0080FF""> "
>> Response.Write "> size=""2"">EMAIL: <a href=`mailto:" &
>> strEmail & "?Subject=Mail from BelchingToadClan Members Page`>" &
>> objRS("Email") & "</a>"
>> Response.Write "> color=""#008000""> "
>> Response.Write "> size=""2"">AIM: <A
>> href=""aim:goim?screenname=" & objRS("Aim") & """>" & objRS("Aim") &
>> "</A> "
>> Response.Write "> color=""#008000"">ICQ:" & objRS("Icq") &
>> " "
>> Response.Write "CONNECTION:> size=""2""
>> color=""#00FF00"">" & objRS("Connect") & ""
>> Response.Write "</td>"
>> Response.Write "</tr>"
>> Response.Write "</table>"
>> Response.Write "</div>"
>> Response.Write " </td>"
>> Response.Write "<td width=""268""
>> background=""../_Images/Development/bg2.gif"">"
>> Response.Write " </td></tr><tr>"
>> Response.Write "<td width=""50"">"
>> Response.Write " "
>> Response.Write " </td><td>"
>> Response.Write " </td>"
>> Response.Write "<td width=""268"">"
>> Response.Write " </td></tr></table>"
>>
>>
>>
>> `Response.Write "<img src=""../_Images/sarge.gif"" width=""21""
>> height=""32"" border=""0""><BIG><BIG><a class=""roll""
>> href=`../_scripts/ViewBTCMemberfromindex.asp?" & objRS("PlayingName") &
>> "`>"
>> & objRS("PlayingName") & "</a></BIG></BIG> "
>> `Response.Write "" &
>> objRS("Location") & " "
>> `Response.Write "<a href=`mailto:" & strEmail & "?Subject=Mail
>> from
>> BelchingToadClan Members Page`>" & objRS("Email") & "</a>"
>> `Response.Write " "
>> objRS.MoveNext
>> Loop
>> `Response.Write "<BIG>THERE ARE CURRENTLY [" & strCounter & "]
>> BTC
>> MEMBERS</BIG> "
>> `Response.Write "</td>"
>> `Response.Write "</tr><tr><td width=""575""></td></table>"
>>
>>
>> %>
>>
>>  
>>
>> <%
>> objRS.Close
>> Set objRS = Nothing
>> objConn.Close
>> Set objConn = Nothing
>> %>
>> 
>> 
>> </BODY>
>> </HTML>
>> </CODE>
>>
>>
>>
>> Mike Belcher
>> Independant Computer Consultant
>>
>> Email: mbelcher@...
>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>> Yahoo! Groups Sponsor
>> ADVERTISEMENT
>>
>>
>>
>>
>>
>>
------------------------------------------------------------------------------
>> Yahoo! Groups Links
>>
>> a.. To visit your group on the web, go to:
>> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
>>
>> b.. To unsubscribe from this group, send an email to:
>> AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
>>
>> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
>> Service.
>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>> Yahoo! Groups Sponsor
>> ADVERTISEMENT
>>
>>
>>
>>
>>
>>
>> Yahoo! Groups Links
>>
>> To visit your group on the web, go to:
>> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
>>
>> To unsubscribe from this group, send an email to:
>> AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
>>
>> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>>
>> ----------
>>
>> <asp:Repeater id="ClanMembersList" runat="server">
>> <HeaderTemplate>
>> <table border="0" width="780" cellpadding="3" cellspacing="3">
>> <tr>
>> </HeaderTemplate>
>> <ItemTemplate>
>> <td width="50" background="../_Images/Development/bg2.gif"> </td>
>> <td>
>> <div align="center">
>> <table border="2" cellpadding="3" cellspacing="0" width="100%"
>> align="left" id="table3"
>> background="../_Images/Development/metal3Dark.gif"
>> bordercolorlight="#666666" bordercolordark="#333333" bgcolor="#292929">
>> <tr>
>> <td><BIG><BIG>
>> 
>> <a href=`../_scripts/ViewBTCMemberfromindex.asp?<%#
>> DataBinder.Eval(Container.DataItem, "PlayingName") %>`><%#
>> DataBinder.Eval(Container.DataItem, "PlayingName")
>> %><a/></BIG></BIG>
>> 
>> JOINED: <%# DataBinder.Eval(Container.DataItem,
>> "DateJoined") %> 
>> NAME:> color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Name")
>> %>
>> 
>> AGE: > color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Age")
>> %>
>> 
>> LOCATION: > color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Location")
>> %>
>> 
>> EMAIL: > color="#00ff00"><a href=`mailto:<%# DataBinder.Eval(Container.DataItem,
>> "Email") %>?Subject=Mail from BelchingToadClan Members Page`><%#
>> DataBinder.Eval(Container.DataItem, "Email") %></a>
>> 
>> AIM: > color="#00ff00"><A href=`aim:goim?screenname=<%#
>> DataBinder.Eval(Container.DataItem, "Aim") %>`><%#
>> DataBinder.Eval(Container.DataItem, "Aim") %></A> 
>> ICQ:> color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Icq")
>> %> 
>> CONNECTION:> color="#00FF00"><%#
>> DataBinder.Eval(Container.DataItem, "Connect") %>
>> </td>
>> </tr>
>> </table>
>> </div> 
>> </td>
>> <td width="268" background="../_Images/Development/bg2.gif"> </td>
>> </tr>
>> <tr>
>> <td width="50">
>>  
>> </td>
>> <td> 
>> </td>
>> <td width="268"> 
>> </td>
>> </ItemTemplate>
>> <FooterTemplate>
>> </tr>
>> </table>
>> </FooterTemplate>
>> </asp:Repeater>
>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>>
>>
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
> AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

System-Administrator@... Posted: Tue Jan 04, 2005 5:11 am

Joined: 03 Jan 2005

Posts: 15

Re: aspclassic to ASP.NET ..................................

Okay I managed to do the connection and it works. Here is my issue and if I can
get this right I can do other simular pages without a problem it is just
learning that FIRST one that is the hard part the same as classic asp and ADO.

Here is the old page in asp classic
Basically you click on the ViewBTCMemberIndex.asp page that I have already
converted with many thanks to Ben Miller and now once that is done it displays
that members information ...

here is the link to what it looks like now done in classic asp
http://belchingtoadclan.gotdns.com/btc2/_scripts/ViewBTCMemberfromindex.asp?Quak
eDealer[BTC]

I used to just open a recordset and get the one record belonging to the member
and i could access each field value in that row. I cold response.write it and
display it etc.. I cannot figure out how to do that in asp.net. Here is the
code fromt he old page. YOu will see how I could get the record I want and then
assign the values to variables....... How to do that in asp.net?

Like how I do this in ado:
strName = objRS("Name")
strPlayingname = objRS("Playingname")

In ADO.NET:
strName = ???
strPlayingname = ????

I put what I started in asp.net after the current asp classic code Block listed.

<ASPCLASSIC-CODE>
<%@ Language=VBScript %>
<% Option Explicit %>



<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Menu</title>

<STYLE>BODY {
SCROLLBAR-FACE-COLOR: #000000; SCROLLBAR-HIGHLIGHT-COLOR: #000000;
SCROLLBAR-SHADOW-COLOR: #000000; SCROLLBAR-ARROW-COLOR: #000000;
SCROLLBAR-TRACK-COLOR: #000000; SCROLLBAR-DARKSHADOW-COLOR: #000000
}
</style>

<style fprolloverstyle>A:hover {color: #00FF00; font-style: italic}
</style>
</head>

<body bgcolor="#000000" text="#C0C0C0" link="#C0C0C0" vlink="#C0C0C0"
alink="#00FF00" style="text-align: center">

<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="572">
<tr>
<td>
</td>
</tr>
<tr>
<%
`AUTHOR: MIKE BELCHER
`VIEW MEMBERS

%>

<%

`GRAB THE RECORD VALUE FROM THE QUERYSTRING HERE AND PLACE INTO A VARIABLE.
Dim strRecord , arrRecord
strRecord = Request.QueryString
strRecord=Replace(strRecord, "%40", "@")
strRecord=Replace(strRecord, "%2E", ".")
strRecord=Replace(strRecord, "%7E", "~")` put tilde back
strRecord=Replace(strRecord, "%60", "`")` put ` back
strRecord=Replace(strRecord, "%21", "!")` put exclamation back
strRecord=Replace(strRecord, "%40", "@")` put @ back
strRecord=Replace(strRecord, "%23", "#")` put pound back
strRecord=Replace(strRecord, "%24", "$")` put dollar sign back
`strRecord=Replace(strRecord, "%2525", "%")` put percent sign back
strRecord=Replace(strRecord, "%5E", "^")` put exponent back
strRecord=Replace(strRecord, "%26", "&")` put and back
strRecord=Replace(strRecord, "%2A", "*")` put and back
strRecord=Replace(strRecord, "%28", "(")` put ( back
strRecord=Replace(strRecord, "%29", ")")` put ) back
strRecord=Replace(strRecord, "%20", " ")` put spaces back
strRecord=Replace(strRecord, "%2C", ",")` put comma back
strRecord=Replace(strRecord, "%27", "`")` put apostrophe back
strRecord=Replace(strRecord, "%2D", "-")` put dash back
strRecord=Replace(strRecord, "%5F", "_")` put underscore back
strRecord=Replace(strRecord, "%3D", "=")` put equal back
strRecord=Replace(strRecord, "%7B", "{")` put left bracket back
strRecord=Replace(strRecord, "%7D", "}")` put right bracket back
strRecord=Replace(strRecord, "%5B", "[")` put [ back
strRecord=Replace(strRecord, "%5D", "]")` put ] back
strRecord=Replace(strRecord, "%7C", "|")` put | back
strRecord=Replace(strRecord, "%5C", "")` put back
strRecord=Replace(strRecord, "%2F", "/")` put / back
strRecord=Replace(strRecord, "%3A", ":")` put : back
strRecord=Replace(strRecord, "%3B", ";")` put ; back
`strRecord=Replace(strRecord, "%22", """"")` put back
strRecord=Replace(strRecord, "%3C", "<")` put < back
strRecord=Replace(strRecord, "%3E", ">")` put > back
strRecord=Replace(strRecord, "%2E", ".")` put . back

`create a SQL statement open the recordset
Dim strSQL
strSQL = "SELECT * FROM tblBTC"

Dim objRS
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open strSQL, objConn

`FIND THE RECORD WE WANT
Dim strShowRecord

Do While Not (objRS.EOF OR strShowRecord)
If Not(StrComp(objRS("PlayingName"), strRecord, vbTextCompare) = 0) Then
`nothing
objRS.MoveNext
Else
strShowRecord = true
End If
Loop

Dim strName, strPlayingname, strUserName, strPassword, strLocation, strEmail,
strAge, strIcq, strAim, strOccupation
Dim strBio, strPersonalInformation, strGamesPlayed, strConnect, strProcessor,
strRam, strVideocard
Dim strSoundcard, strHarddrive, strAdditionalsysteminformation, strPhoto,
strSystemPhoto, strDateJoined, strOS

strName = objRS("Name")
strPlayingname = objRS("Playingname")
strUserName = objRS("UserName")
strPassword = objRS("Password")
strLocation = objRS("Location")
strEmail = objRS("Email")
strAge = objRS("Age")
strIcq = objRS("Icq")
strAim = objRS("Aim")
strOccupation = objRS("Occupation")
strBio = objRS("Bio")
strPersonalInformation = objRS("PersonalInformation")
strGamesPlayed = objRS("GamesPlayed")
strConnect = objRS("Connect")
strProcessor = objRS("Processor")
strRam = objRS("Ram")
strVideocard = objRS("Videocard")
strSoundcard = objRS("Soundcard")
strHarddrive = objRS("Harddrive")
strAdditionalsysteminformation = objRS("Additionalsysteminformation")
strPhoto = objRS("Photo")
strSystemPhoto = objRS("SystemPhoto")
strDateJoined = objRS("DateJoined")
strOS = objRS("OS")

%>

<div align="center">
<table border="0" cellpadding="0" cellspacing="5" width="780" id="table3"><tr>
<td width="50" valign="top">
 </td><td valign="top">
 </td><td width="50" valign="top">
 </td></tr><tr>
<td width="50" valign="top" background="../_Images/Development/bg2.gif">
 </td><td valign="top">

<div align="center">
<table border="1" cellpadding="0" cellspacing="0" width="100%" align="left"
id="table4">
<tr>
<td background="../_Images/Development/metal3Dark.gif"
bordercolorlight="#666666" bordercolordark="#333333" bgcolor="#292929">

<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="100%" align="left"
id="table6">
<tr>
<td colspan="4">
<big><big><big><%=strPlayingname
%></big></big></big></td>
</tr>
<tr>
<td width="100%" colspan="4">      
</td>
</tr>
<tr>
<td width="1%"> </td>
<td width="30%" colspan="2">

<div align="center">
<table border="1" cellpadding="0" cellspacing="0" id="table7"
bordercolorlight="#666666" bordercolordark="#333333" bgcolor="#000000">
<tr>
<td>
<img border="0" src="<%=strPhoto %>" width="166" height="166"></td>
</tr>
</table>

</div></td>


<td width="69%" valign="top">

JOINED: <%=strDateJoined %> 
NAME: <%=strName %> 
AGE: <%=strAge %> 

LOCATION: <%=strLocation %> 
PLAYING  NAME: <%=strPlayingname %> 
EMAIL: <a href=`mailto:<%=strEmail %>`><%=strEmail
%></a> 
AIM: <A href="aim:goim?screenname=<%=strAim
%>"><%=strAim %></A> 

ICQ: <%=strIcq %>
 OCCUPATION: <%=strOccupation %></td>
</tr>
<tr>
<td width="100%" colspan="4">    </td>
</tr>
<tr>
<td width="100%" colspan="4">

BIO: <%=strBio %> 

PERSONAL INFORMATION: <%=strPersonalInformation %> 

GAMES PLAYED: 
<%=strGamesPlayed
%>  </td>
</tr>
<tr>
<td width="100%" colspan="4">

SYSTEM
INFORMATION</td>
</tr>
<tr>
<td width="100%" colspan="4">
   </td>
</tr>
<tr>
<td width="20" colspan="2">
 </td>
<td width="30%">

<div align="center">
<table border="1" cellpadding="0" cellspacing="0" align="center" id="table8"
bordercolorlight="#666666" bordercolordark="#333333" bgcolor="#000000">
<tr>
<td>
<img border="0" src="<%=strSystemPhoto %>" width="166" height="166"></td>
</tr>
</table>
</div></td>
<td valign="top">
 
CONNECTION:
<%=strConnect %> 

OPERATING SYSTEM:
<%=strOS %> 

PROCESSOR:
<%=strProcessor %> 

RAM:
<%=strRam %> 


VIDEO CARD:
<%=strVideocard %> 


SOUND CARD:
<%=strSoundcard %> 

HARD DRIVE:
<%=strHarddrive %>

 
  </td>
</tr>
<tr>
<td width="100%" colspan="4">
 
ADDITIONAL SYSTEM
INFORMATION: 
<%=strAdditionalsysteminformation %>
 
 </td>
</tr>
</table>
</div>

<big><big><big> 
 
 
 
 
 
</big></big></big>

 
  

 
 </td>
</tr>
</table>
</div>
<big><big><big> 
 </big></big></big></td>
<td width="50" valign="top" background="../_Images/Development/bg2.gif">
 </td></tr><tr>
<td width="50" valign="top">
 </td><td valign="top">
 </td><td width="50" valign="top">
 </td></tr></table>

</div>


</body>

</html>

<%
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing

Dim strLink
strLink = ""
%>

</table>
</div>

</BODY>
</HTML>

</ASPCLASSIC-CODE>

</ASP.NET-CODE>

`Open the Connection -------------------------------------

Dim objConn As OleDbConnection

Dim objConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:InetpubwwwroottcNETDBelcherman.mdb"

objConn = New OleDb.OleDbConnection(objConnString)

objConn.Open()

`Response.Write("Connection OPENED ")

`Open the Connection -------------------------------------

`Create a DataSet ----------------------------------------

Dim objDataSet As New DataSet

`Response.Write("objDataSet Created ")

`Create a DataSet ----------------------------------------

`---------- Get Playingname from Querystring ------

Dim strPlayingName As String

strPlayingName = Request.QueryString("PlayingName")

Dim strSQLstring As String

strSQLstring = "SELECT * FROM tblBTC WHERE PlayingName LIKE `" & strPlayingName
& "`"

`--------------------------------

`Create a DataAdapter ------------------------------------

Dim objDataAdapter As OleDbDataAdapter

`objDataAdapter = New OleDbDataAdapter("SELECT * FROM tblBTC", objConn)

objDataAdapter = New OleDbDataAdapter(strSQLstring, objConn)

objDataAdapter.Fill(objDataSet, "BTC MEMBERS")

`Response.Write("objDataAdapter Created and used to fill the the objDataSet with
tblBTC ")

`Create a DataAdapter ------------------------------------

`CODE ===============================================================

`tblBTC.DataSource = objDataSet

`tblBTC.DataBind()

`literal1.text = " HTML CODE "

`Want to add more:

`literal1.text &= " MORE HTML CODE "

`<%# DataBinder.Eval(Container.DataItem, "PlayingName") %>

Dim tblBTC As DataTable = objDataSet.Tables.Item("tblBTC")

`tblBTC.Rows.Item("PlayingName")

strBTC.Text = " HTML CODE "

strBTC.Text &= " -------- HTML CODE added again "

strBTC.Text &= "PlayingName = " & strPlayingName & " "

strBTC.Text &= "SQLString = " & strSQLstring & " "

strBTC.Text &= "DATAITEM ==== " &
objDataSet.Tables("tblBTC").Rows.Item("PlayingName").ToString()

`Console.WriteLine(rowCustomer.Item("CompanyName"))

`objDataSet.Tables("tblBTC").Rows.Item("PlayingName").ToString()

`objDataSet.Tables("tblBTC").Rows.

`objDataSet.Tables("tblBTC").Rows.Item("PlayingName").ToString())

`objDataSet.Tables("tblBTC").Columns.

`CODE ===============================================================

`Close things up ------------------------------------

objDataSet.Dispose()

objDataSet = Nothing

objDataAdapter = Nothing

objConn.Close()

objConn = Nothing

`Response.Write("CLOSED ")

`Close things up ------------------------------------

`----------------------------- Script extras ----------------------

`strSQLstring = "SELECT * FROM tblBTC WHERE PlayingName LIKE `%strPlayingName%`"

`---------------------------------------------------------------------------

</ASP.NET-CODE>

I have tried and looked around but so far nothing is like what i need.

Mike Belcher
Independent Computer Consultant
Email: mbelcher@...

[Non-text portions of this message have been removed]

aws_kamal Posted: Thu Jan 06, 2005 5:02 pm

Joined: 06 Jan 2005

Posts: 1

Re: aspclassic to ASP.NET ..................................

hi,
u can store the array in the sessionby converting the array to
object before save it on Session

Session("array") = CObj(myArray)

Regards

Aws

--- In AspNetAnyQuestionIsOk@yahoogroups.com, jamil tamimi
<jamil_h_t@y...> wrote:
>
> hi all , how can i store an array after the postback in vb.net ,
if it is as view state how can i use it
>
> thank`s
>
>
> ---------------------------------
> Do you Yahoo!?
> All your favorites on one personal page � Try My Yahoo!
>
> [Non-text portions of this message have been removed]

freelanceprogrammers.org Forum Index » ASP

All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help