Sample Stored Procedure reference, and I just want to reference a view now:
I might be mistaken here, but a view is treated pretty much like a table. So if you want to return data from a view, query against it as if it were a table: SELECT * FROM vw_myView WHERE ...
' Connect to the Database
Dim MyConn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("myConnectionString"))
' Establish the set of data commands and a database connection that are used to fill the dataset
Dim MyCommand As New SqlCommand("vw_Mast_PW_Accounts", MyConn)MyCommand.CommandType = CommandType.StoredProcedure
MyConn.Open()
dgMyGrid.DataSource = MyCommand.ExecuteReader
dgMyGrid.DataBind()MyConn.Close()
You'll need to make sure your web app has permissions to query the view and, I think, any underlying tables (though I might be wrong on that last point).|||That's great, but do is there a way to do it without using SQL but simply referencing it as I would a stored procedure (i.e., just the name)?
Thank you,
Brent|||I don't believe so, for that same reason that you couldn't do that with a table.
Youcould create a stored procedure that returned data from your view, if you really needed that functionality...|||I gave up and built the stored procedure to access that view. Thank you for the suggestion!
Brent
