Display SQL View In Webform?

  • Thread starter Thread starter Leon
  • Start date Start date
L

Leon

Is it possible to display a sql view from my ms sql 2000 database in my
webform?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display RTF tekst in webform 1
running webform page inside MVC framework 1
Save Visio file into SQL 1
Create an instance of one webform on another webform 5
implementing sql transactions in data access layers 2
MVC WEBFORM INTEGRATION 1
Save MS Visio file into SQL 2000 1
loosing data on first web page when reloaded. 2

Back
Top