sql 2005 views

Discussion in 'ASP .Net' started by JohnE, Jun 18, 2010.

  1. JohnE

    JohnE Guest

    I am beginning the process of converting a 15 yr old Access db (frontend)
    into a website application. It might be 15yo but is still very much used
    today and has gone thru all the updates over time. The back end is sql
    server 2005. Much in the front end uses sql views.

    How are views treated in asp.net sqldatasource? As stored proc, view,
    table, or ??? How are they referred to in a sqldatasource? Same as a stored
    proc? Any samples/examples/links of using a view?

    Thanks...John
     
    JohnE, Jun 18, 2010
    #1
    1. Advertisements

  2. JohnE

    Paul Shapiro Guest

    "JohnE" <> wrote in message
    news:...
    > I am beginning the process of converting a 15 yr old Access db (frontend)
    > into a website application. It might be 15yo but is still very much used
    > today and has gone thru all the updates over time. The back end is sql
    > server 2005. Much in the front end uses sql views.
    >
    > How are views treated in asp.net sqldatasource? As stored proc, view,
    > table, or ??? How are they referred to in a sqldatasource? Same as a
    > stored
    > proc? Any samples/examples/links of using a view?
    >
    > Thanks...John


    A SqlDataSource can either specify a stored procedure or a SQL statement,
    which can include parameters. The documentation has details and examples.
     
    Paul Shapiro, Jun 18, 2010
    #2
    1. Advertisements

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. Shawn H. Mesiatowsky

    SQL Innerjoins and data views

    Shawn H. Mesiatowsky, Apr 7, 2005, in forum: ASP .Net
    Replies:
    2
    Views:
    1,270
    Scott Allen
    Apr 8, 2005
  2. Juan T. Llibre
    Replies:
    0
    Views:
    625
    Juan T. Llibre
    Jun 7, 2005
  3. Sql Agentman
    Replies:
    0
    Views:
    822
    Sql Agentman
    Jan 19, 2006
  4. Replies:
    1
    Views:
    721
  5. Brad  Brening
    Replies:
    0
    Views:
    617
    Brad Brening
    Mar 1, 2007
  6. Lamis

    sql Views

    Lamis, Nov 29, 2007, in forum: ASP .Net
    Replies:
    2
    Views:
    488
    Eliyahu Goldin
    Nov 29, 2007
  7. XJ
    Replies:
    8
    Views:
    1,981
  8. Jake Henderson

    Visual Web Developer 2005 Express and SQL 2005 Express

    Jake Henderson, Mar 10, 2006, in forum: ASP .Net Web Services
    Replies:
    0
    Views:
    441
    Jake Henderson
    Mar 10, 2006
Loading...