How to execute a database command on an Access database using ASP.NET
Print
Create a Database Command
To specify the records to retrieve from the database, we will create a dbcomm
variable as a new OleDbCommand class. The OleDbCommand class is for issuing SQL
queries against database tables:
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
sub Page_Load
dim dbconn,sql,dbcomm
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
data source=" & server.mappath("northwind.mdb"))
dbconn.Open()
sql="SELECT * FROM customers"
dbcomm=New OleDbCommand(sql,dbconn)
end sub
</script>
|
|
Was this answer helpful?
