I want to know how M/S ACCESS database can be connected to html page hosted on local host
How to link MS Access Database with an HTML Page Hosted on local host...?
0
JorgeM 966 You will not be able to do this with HTML alone. You need to have server side scripting to be able to connect to a Database such as asp.net, php, asp, etc...
0
eltonpiko 2 why not use mysql you can do it via wamp to run the php code.or use asp.net would be much easier to connect to a access db can runn it on IIS on you local machine.
with asp.net you could do something like that
`<%@ 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("northwind.mdb"))
dbconn.Open()
sql="SELECT * FROM customers"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
customers.DataSource=dbread
customers.DataBind()
dbread.Close()
dbconn.Close()
end sub
</script>
<html>
<body>
<form runat="server">
<asp:Repeater id="customers" runat="server">
<HeaderTemplate>
<table border="1" width="100%">
<tr>
<th>Companyname</th>
<th>Contactname</th>
<th>Address</th>
<th>City</th>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td><%#Container.DataItem("companyname")%></td>
<td><%#Container.DataItem("contactname")%></td>
<td><%#Container.DataItem("address")%></td>
<td><%#Container.DataItem("city")%></td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</form>
</body>
</html>`
find out more on http://www.w3schools.com
This topic has been dead for over six months. Start a new discussion instead.
Recommended Topics
