• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

ASP.net SqlDataSource

Hi

I am fairly new to using SqlDataSource on an ASP.net page
Someone I work with referred to pulling a "view" and then just changing the where
clause. Can anyone elaborate on this?

Thanks
0
Murray Brown
Asked:
Murray Brown
2 Solutions
 
DhaestCommented:
0
 
Jerry MillerCommented:
Views are used in some cases to restrict access for specific users. A view is essentially a stored Select statement that is created for the users.

http://msdn.microsoft.com/en-us/library/aa214068%28v=sql.80%29.aspx

Changing the where clause at run time can be considered a dynamic query. These must be done correctly or you open yourself up to SQL injection.

Like Dhaest stated, what are your goals?
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now