how do you use sql views in asp.net? 1

[radiance]

hello.

another developer needs for me to use his views in my program. I have looked on microsoft's site and there is no clear explanation on using 'views' in place of sql queries.

please advise.

so, if I wanted to change the following:

Dim pullfilesbyDate As String = "select bookID, title, dateSubmitted from mytestTable where dateSubmitted between '" & firstdate & "' and '" & lastdate & "' order by dateSubmitted ASC"

the view is showTable

how would that be done? the view may also have several possible parameters too?

 

[ca8msm]

Accessing a view should be no different to accessing a table so just replace the table name with the view name.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[radiance]

ok...but is there a way to select certain parameters from the view?

 

[ca8msm]

Again, it's the same format as if you were adding parameters when searching a table.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.