Display SQL View In Webform?

[Leon]

Is it possible to display a sql view from my ms sql 2000 database in my
webform?

 

[Guest]

Have you tried it? Should be no different than selecting from the tables
directly--your web form doesn't know the difference.

Bill

 

[Leon]

can you passmeters to views like with tables and stored procedures
example:
CREATE PROCEDURE GetSchoolByState
(
@StateID char(2)
)
AS
SELECT SchoolID,SchoolName FROM School WHERE StateID = @StateID ORDER BY
SchoolName ASC
GO

 

[Guest]

Yes, a view is virtually no different--e.g. Select * From MyView Where
CustID=@CustID, etc. You need to play around with it, and/or find a good
reference (start with the SQL docs). Enjoy.