Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > sql 2005 views

Reply
Thread Tools

sql 2005 views

 
 
JohnE
Guest
Posts: n/a
 
      06-18-2010
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
 
Reply With Quote
 
 
 
 
Paul Shapiro
Guest
Posts: n/a
 
      06-18-2010
"JohnE" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
sql Views Lamis ASP .Net 2 11-29-2007 04:15 PM
Re: "Certifications for Visual Studio 2005 and SQL Server 2005 wil Pedro Simoes MCSD 0 11-24-2005 07:52 PM
"Certifications for Visual Studio 2005 and SQL Server 2005 will be available in early 2006" DST MCSD 8 10-28-2005 02:50 AM
SQL Innerjoins and data views Shawn H. Mesiatowsky ASP .Net 2 04-08-2005 05:53 PM
New Exams for SQL Server 2005 and Visual Studio 2005 gemeaux | tt Microsoft Certification 1 10-25-2004 06:59 PM



Advertisments