A Challenging Problem I'm Trying to Resolve ....

Discussion in 'ASP .Net' started by Wayne, Nov 9, 2005.

  1. Wayne

    Wayne Guest

    This is a copy of a message I previously posted in a Microsoft Access Newsgroup, but it was suggested to me that my problem is ASP related and not Access, and hence I'm posting in this newsgroup now instead.

    Hi everyone,
    I've got quite a specific query that I'm trying to resolve with Microsoft Access and I'm hopeful someone out there can offer a solution to my problem.

    I have records that I'm displaying on a web page from an Access database and what I would like to do is include a 'Buy Now' button at the end of each record, so when the particular .aspx page is accessed through a users browser and the data pulled from the database, it looks something like the following:

    Product A Description A Price A 'Buy Now Button'
    Product B Description B Price B 'Buy Now Button'
    Product C Description C Price C 'Buy Now Button'

    I'm trying to avoid having to manually add the button to the record by way of an OLE Object field, I fear that could be really time consuming. I have some code that will work behind each button but I need to find a way around two specific problems:

    Firstly, how to display the same 'Buy Now' button (or image) at the end of each record, without the necessity to add it manually to the web page - and for obvious reasons this would be a headache scenario because new records will be added and old ones deleted on a regular basis. I therefore need an automated way to include this button each time a new record is added.

    The second issue I have is how to change two of the components within that code so each Buy Now button will represent the unique product it is displayed next to, for example I need to work out how to change the 'Product Name' and 'Price' within the code so its identical to the 'Product Name' and 'Price' from that particular row of data, and obviously without the necessity again to do this manually each time a new record is added.

    I know this sounds complicated but I am sure there must be a way around this, perhaps using Visual Basic for Applications within the Access Database itself, but I'm not a programmer so I'm a little unsure how to apply the correct VB code to accomplish this task.

    If anyone has a suitable solution for this problem I really would be grateful.

    Many thanks
    Wayne

    As a footnote, I'm running FrontPage 2003, Access 2003 and IIS 6.0 on a Windows 2003 Datacentre Server with ASP.NET 1.1 Installed
    Wayne, Nov 9, 2005
    #1
    1. Advertising

  2. Wayne

    Karl Seguin Guest

    They were right and sending you here. You should get familiar with ASP.Net
    databinding:

    http://66.129.71.130/QuickStartv20/aspnet/doc/ctrlref/data/datalist.aspx

    if you click on the 2nd "run it" you'll see a number of records with a "Show
    Detail" column at the front. This is similar to what you want to do. Click
    the view source to see more on how they do it.

    Karl

    --
    MY ASP.Net tutorials
    http://www.openmymind.net/

    "Wayne" <waynesmith1971(NoSpam)@hotmail.com> wrote in message
    news:...
    This is a copy of a message I previously posted in a Microsoft Access
    Newsgroup, but it was suggested to me that my problem is ASP related and not
    Access, and hence I'm posting in this newsgroup now instead.

    Hi everyone,
    I've got quite a specific query that I'm trying to resolve with Microsoft
    Access and I'm hopeful someone out there can offer a solution to my problem.

    I have records that I'm displaying on a web page from an Access database and
    what I would like to do is include a 'Buy Now' button at the end of each
    record, so when the particular .aspx page is accessed through a users
    browser and the data pulled from the database, it looks something like the
    following:

    Product A Description A Price A 'Buy Now Button'
    Product B Description B Price B 'Buy Now Button'
    Product C Description C Price C 'Buy Now Button'

    I'm trying to avoid having to manually add the button to the record by way
    of an OLE Object field, I fear that could be really time consuming. I have
    some code that will work behind each button but I need to find a way around
    two specific problems:

    Firstly, how to display the same 'Buy Now' button (or image) at the end of
    each record, without the necessity to add it manually to the web page - and
    for obvious reasons this would be a headache scenario because new records
    will be added and old ones deleted on a regular basis. I therefore need an
    automated way to include this button each time a new record is added.

    The second issue I have is how to change two of the components within that
    code so each Buy Now button will represent the unique product it is
    displayed next to, for example I need to work out how to change the 'Product
    Name' and 'Price' within the code so its identical to the 'Product Name' and
    'Price' from that particular row of data, and obviously without the
    necessity again to do this manually each time a new record is added.

    I know this sounds complicated but I am sure there must be a way around
    this, perhaps using Visual Basic for Applications within the Access Database
    itself, but I'm not a programmer so I'm a little unsure how to apply the
    correct VB code to accomplish this task.

    If anyone has a suitable solution for this problem I really would be
    grateful.

    Many thanks
    Wayne

    As a footnote, I'm running FrontPage 2003, Access 2003 and IIS 6.0 on a
    Windows 2003 Datacentre Server with ASP.NET 1.1 Installed
    Karl Seguin, Nov 9, 2005
    #2
    1. Advertising

  3. Wayne

    Wayne Guest

    This looks very interesting Karl and with a bit of tweaking I think it could easily apply to my scenario.

    Thanks very much for posting the link, I'm going to spend a few hours reading through those pages and see what I can adapt further.

    I really appreciate your reply Karl, thanks again.

    Kind Regards,
    Wayne
    "Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net> wrote in message news:OuFA#...
    They were right and sending you here. You should get familiar with ASP.Net
    databinding:

    http://66.129.71.130/QuickStartv20/aspnet/doc/ctrlref/data/datalist.aspx

    if you click on the 2nd "run it" you'll see a number of records with a "Show
    Detail" column at the front. This is similar to what you want to do. Click
    the view source to see more on how they do it.

    Karl

    --
    MY ASP.Net tutorials
    http://www.openmymind.net/

    "Wayne" <waynesmith1971(NoSpam)@hotmail.com> wrote in message
    news:...
    This is a copy of a message I previously posted in a Microsoft Access
    Newsgroup, but it was suggested to me that my problem is ASP related and not
    Access, and hence I'm posting in this newsgroup now instead.

    Hi everyone,
    I've got quite a specific query that I'm trying to resolve with Microsoft
    Access and I'm hopeful someone out there can offer a solution to my problem.

    I have records that I'm displaying on a web page from an Access database and
    what I would like to do is include a 'Buy Now' button at the end of each
    record, so when the particular .aspx page is accessed through a users
    browser and the data pulled from the database, it looks something like the
    following:

    Product A Description A Price A 'Buy Now Button'
    Product B Description B Price B 'Buy Now Button'
    Product C Description C Price C 'Buy Now Button'

    I'm trying to avoid having to manually add the button to the record by way
    of an OLE Object field, I fear that could be really time consuming. I have
    some code that will work behind each button but I need to find a way around
    two specific problems:

    Firstly, how to display the same 'Buy Now' button (or image) at the end of
    each record, without the necessity to add it manually to the web page - and
    for obvious reasons this would be a headache scenario because new records
    will be added and old ones deleted on a regular basis. I therefore need an
    automated way to include this button each time a new record is added.

    The second issue I have is how to change two of the components within that
    code so each Buy Now button will represent the unique product it is
    displayed next to, for example I need to work out how to change the 'Product
    Name' and 'Price' within the code so its identical to the 'Product Name' and
    'Price' from that particular row of data, and obviously without the
    necessity again to do this manually each time a new record is added.

    I know this sounds complicated but I am sure there must be a way around
    this, perhaps using Visual Basic for Applications within the Access Database
    itself, but I'm not a programmer so I'm a little unsure how to apply the
    correct VB code to accomplish this task.

    If anyone has a suitable solution for this problem I really would be
    grateful.

    Many thanks
    Wayne

    As a footnote, I'm running FrontPage 2003, Access 2003 and IIS 6.0 on a
    Windows 2003 Datacentre Server with ASP.NET 1.1 Installed
    Wayne, Nov 9, 2005
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?cmFtYXRh?=

    Classical Complex challenging Asp and SQL problem

    =?Utf-8?B?cmFtYXRh?=, Apr 30, 2005, in forum: ASP .Net
    Replies:
    3
    Views:
    460
    Mark Rae
    May 3, 2005
  2. Replies:
    5
    Views:
    329
    Peter Otten
    Apr 11, 2006
  3. shuisheng
    Replies:
    8
    Views:
    265
    Grizlyk
    Dec 26, 2006
  4. Replies:
    1
    Views:
    10,138
  5. Krishnakant
    Replies:
    7
    Views:
    291
    Piet van Oostrum
    Jul 23, 2009
Loading...

Share This Page