parameters in .net

[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>

 

[Cor Ligthert[MVP]]

Rick,

The newsgroup public.dotNet.framework.AdoNet would better fit for your
question.

But have a look at this page, in my is everything in it especially in the
sample about what you ask.

http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbparameter.aspx#

Cor