parameters in .net

  • Thread starter Thread starter RICK
  • Start date Start date
R

RICK

If this is not the correct place to ask the following question on parameters
please let me know where to post as I am really stuck on this issue.

In the following code you will note a select statement that says "SELECT *
FROM WebQry_List". The MS Access query needs a single parameter passed to it
to be able to run. How do you add that parameter in the following code. I
have tried parameters.add but am apparently having syntax problems. Please
advise!! Thanks.


<%@ Import Namespace="System.Data.OleDb" %>

<script runat="server">
sub Page_Load
dim dbconn,sql,dbcomm,dbread
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" &
server.mappath("/databases/cpcweb.mdb"))
dbconn.Open()
sql="SELECT * FROM WebQry_List"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
family.DataSource=dbread
family.DataBind()
dbread.Close()
dbconn.Close()
end sub


</script>
 
Back
Top