Hello,
I am doing a project in which i have to connect a given access database to a created asp.net page(default.aspx).
The asp page should ask for the following inputs from the user and connect the "Fruit" entry to the given access database and also validate it by displaying the quantity and price of the selected fruit. Here's what the asp page asks for: Name, Address, zipcode, Email id, Date and Fruit. Here's the code i have written but havent yet done the database connectivity part. After clicking the submit button it should compare the fruit entry with the database available fruits and display the quantity and price of the selected fruit or else as "Not Available in the database". Somebody kindly explain. Remember I don't have to create a database with rows and columns but have an access database called fruits.mdb given.
CODE
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" Text="Name"></asp:Label>
<asp:TextBox ID="TextBox1" runat="server" ForeColor="Black"></asp:TextBox>
<asp:Label ID="Label2" runat="server" ForeColor="Red"></asp:Label>
</div>
<div>
<asp:Label ID="Label3" runat="server" Text="Address"></asp:Label>
<asp:TextBox ID="TextBox2" runat="server" Height="86px" Width="145px" ForeColor="#C0C000"></asp:TextBox>
<asp:Label ID="Label4" runat="server" ForeColor="Red"></asp:Label>
</div>
<div>
<asp:Label ID="Label5" runat="server" Text="Zipcode"></asp:Label>
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
<asp:Label ID="Label6" runat="server" ForeColor="Red"></asp:Label>
</div>
<div>
<asp:Label ID="Label7" runat="server" Text="Email"></asp:Label>
<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
<asp:Label ID="Label8" runat="server" ForeColor="Red"></asp:Label>
</div>
<div>
<asp:Label ID="Label11" runat="server" Text="Fruit"></asp:Label>
<asp:TextBox ID="TextBox6" runat="server"></asp:TextBox>
<asp:Label ID="Label12" runat="server" ForeColor="Red"></asp:Label>
</div>
<div>
<asp:Label ID="Label9" runat="server" Text="Date"></asp:Label>
<asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
<asp:Label ID="Label10" runat="server" ForeColor="Red"></asp:Label>
</div>
</form>
</body>
</html>
Somebody pls explain it step by step because im new to this webpage designing and have limited understanding.
Thanks,
prads
| 