PitSquad
asked on
View vs Stored Procedure From loading view only form data
I am building a simple Window Forms application that pulls data from a remote SQL DB.
I have been using SQLConnection with SQL data Adapter and SQL Commands to pull data from the DB via stored procedures instead of building SQL statements in the application.
Some of these SP are just select all statements, so i was thinking, it might be easier to use a view...
however, you cannot use a view with a SQL command.
I have been avoiding doing direct data binding to the form, is there a reason why I would be better off doing data binding to the form and using a SQL view rather than using the SP?
The view and the SP are running identical select statements.
I have been using SQLConnection with SQL data Adapter and SQL Commands to pull data from the DB via stored procedures instead of building SQL statements in the application.
Some of these SP are just select all statements, so i was thinking, it might be easier to use a view...
however, you cannot use a view with a SQL command.
I have been avoiding doing direct data binding to the form, is there a reason why I would be better off doing data binding to the form and using a SQL view rather than using the SP?
The view and the SP are running identical select statements.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.