Professional Web Applications Themes

saved parameter query with MS Access....will it work in asp.net too? - ASP Database

I know this is an ASP group, but I'm curious if (and how) I can use the saved parameter query I learned to do in ASP in ASP.NET as well? Does one merely add the parameters after the sql string like in ASP. Also wondering if trying to do this in ASP.NET has any advantages, since ASP.NET compiles everything anyway. Personally, I like the saved parameter query method because it stops any data entry errors if users use an apostrophe, and I don't have to code in all of the Replace thingys. Thanks, Larry - - - - - - ...

  1. #1

    Default saved parameter query with MS Access....will it work in asp.net too?

    I know this is an ASP group, but I'm curious if (and how) I can use
    the saved parameter query I learned to do in ASP in ASP.NET as well?

    Does one merely add the parameters after the sql string like in ASP.

    Also wondering if trying to do this in ASP.NET has any advantages,
    since ASP.NET compiles everything anyway.

    Personally, I like the saved parameter query method because it stops
    any data entry errors if users use an apostrophe, and I don't have to
    code in all of the Replace thingys.

    Thanks,

    Larry
    - - - - - - - - - - - - - - - - - -
    "Forget it, Jake. It's Chinatown."
    Larry Guest

  2. #2

    Default Re: saved parameter query with MS Access....will it work in asp.net too?

    Larry Rekow wrote: 
    Yes, but i don't know the details yet.



    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"


    Bob Guest

  3. #3

    Default Re: saved parameter query with MS Access....will it work in asp.net too?

    It is possible in asp.net to use parameters. Create a connection object and
    a command object then create parameter objects and add them to the command
    object. That way you keep your type safe params etc. If you are connecting
    to Access then the only advantage you'll get from asp.net is the general
    speed advantage it gives you. You would get ever better performance if you
    are connecting to SQL Server though as you'll be using the .net SQL Server
    provider which is optimised more than the oledb ones.

    "Larry Rekow" <larrynetgeexdotcom> wrote in message
    news:com... 


    Adrian Guest

  4. #4

    Default Re: saved parameter query with MS Access....will it work in asp.net too?

    On Tue, 24 Aug 2004 11:38:07 +0100, "Adrian Forbes [ASP MVP]"
    <zzz> wrote:
     
    ++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++
    Fair enough, thanks.

    Reason I use Access is that
    1) i'm very familiar with it, not very much so with MS SQL and
    2) I use a macro in Access to daily import text reports from a unix
    machine into tables in the Access d/b to display stuff on a web page
    for certain clients.

    Can MS SQL automatically so the same? and/or, can MS SQL server attach
    to or otherwise use MS Access tables?

    I love the neat features in VStutio.Net, but there seem to be so many
    work-arounds to use Access.....just wondering if there is any way to
    have the best of both worlds.

    Thanks much,

    Larry Rekow
    - - - - - - - - - - - - - - - - - -
    "Forget it, Jake. It's Chinatown."
    Larry Guest

  5. #5

    Default Re: saved parameter query with MS Access....will it work in asp.net too?

    Larry Rekow wrote: 

    Yes. It's called Data Transformation Services (DTS).
     

    Yes. Linked Servers. But doing so merely perpetuates the problems you were
    trying to solve when you moved to SQL Server ...

    Bob Barrows

    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.


    Bob Guest

Similar Threads

  1. Query does not work in MS Access in CF
    By Botman63 in forum Coldfusion Database Access
    Replies: 7
    Last Post: April 7th, 05:30 PM
  2. Replies: 3
    Last Post: August 20th, 04:22 PM
  3. Another saved parameter query question (MSAccess XP)
    By Larry Rekow in forum ASP Database
    Replies: 2
    Last Post: August 5th, 02:47 AM
  4. MS Access d/b saved parameter query problem
    By Larry Rekow in forum ASP Database
    Replies: 3
    Last Post: August 3rd, 07:38 PM
  5. Date Parameter For Saved Parameter Queries
    By melody in forum ASP Database
    Replies: 13
    Last Post: December 19th, 09:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139