Hi, when the select statement is used directly in the codebehind of an ASP.NET page it looks something like this.
DBCommand = New OdbcCommand("SELECT CarID, Model From CarsTB where Make = '" & Manufacturers.Items(i).Text & "'", DBConn)
If I want to use a stored procedure to do exactly the same as the line above, what would the syntax be? How to I keep DBConn which is a variable of type, since it is used to open a connection?