ASP/VB/Access, need sample code

Discussion in 'OT Technology' started by Caanon, Mar 23, 2007.

  1. Caanon

    Caanon OT Supporter

    Joined:
    Nov 16, 2003
    Messages:
    685
    Likes Received:
    0
    Need to do this in ASP/VB. I have the code for using an OLE connection to do a SQL query to the access database and return the results to a datagrid.

    What I need is to be able to have the query returned as a string, so it can be put in text box or whatever. (query will be narrow enough so it's a single value)

    Basically it's a group project where we haven't learned any of this ahead of time, and can pretty much get code from wherever, but need to get it done. I'm still searching google, but if someone could point me at some sample code or some site that does this kind of thing it would be appreciated.
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
  3. Caanon

    Caanon OT Supporter

    Joined:
    Nov 16, 2003
    Messages:
    685
    Likes Received:
    0
    Thanks that is at least pointing me in a direction to look.

    Also I didn't say in first post, doing this in Visual studio.net 2003
     
  4. TMh2QkPU

    TMh2QkPU Guest

  5. gnp

    gnp New Member

    Joined:
    Mar 11, 2007
    Messages:
    280
    Likes Received:
    0
    so you are doing this in vb.net and asp.net or vb and asp? and what do you mean by "have the query returned as a string"
     
  6. TMh2QkPU

    TMh2QkPU Guest

    I think he's simply trying to run a query which extracts a CHAR type value from a field :hsugh:
     

Share This Page