Display SQL View In Webform?

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

Bill
 
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
 
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.
 
Back
Top