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. Advertising

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

    SQL Innerjoins and data views

    Shawn H. Mesiatowsky, Apr 7, 2005, in forum: ASP .Net
    Replies:
    2
    Views:
    1,200
    Scott Allen
    Apr 8, 2005
  2. Juan T. Llibre
    Replies:
    0
    Views:
    454
    Juan T. Llibre
    Jun 7, 2005
  3. Sql Agentman
    Replies:
    0
    Views:
    652
    Sql Agentman
    Jan 19, 2006
  4. Replies:
    1
    Views:
    464
  5. Lamis

    sql Views

    Lamis, Nov 29, 2007, in forum: ASP .Net
    Replies:
    2
    Views:
    398
    Eliyahu Goldin
    Nov 29, 2007
Loading...

Share This Page