I want to know how M/S ACCESS database can be connected to html page hosted on local host
imti321 35 Light Poster
Recommended Answers
Jump to Postwhy 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">
…
All 2 Replies
JorgeM 958 Problem Solver Team Colleague Featured Poster
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...
eltonpiko 2 Junior Poster in Training
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
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.