Display SQL View In Webform?

[Leon]

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

[Bill Borg]

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

Bill

"Leon" wrote:

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

[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

"Bill Borg" <Bi******@discussions.microsoft.com> wrote in message
news:8C**********************************@microsof t.com...

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

Bill

"Leon" wrote:

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

[Bill Borg]

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.

"Leon" wrote:

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

"Bill Borg" <Bi******@discussions.microsoft.com> wrote in message
news:8C**********************************@microsof t.com...

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

Bill

"Leon" wrote:

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