ACCESS AND ASP

jessie123 · March 10, 2006

hey i was wondering if any onw could help me.......i need to link my access database and my asp.net together so all information from the web page goes into a database as soon as the user clicks the submot button after they have entered the data......ne one got ne ideas......thanks............jessie

aspnetguy · March 13, 2006

Are you asking for the connection string or a whole script to process your form? Do you have any programming experience or are you trying to learn?If you are looking for a whole script I can only provide a small sample but you will be able to expand it easily to include more form fields.Also are you using Visual Studio or Notepad? It will make a difference in the answer I can give you.

jessie123 · March 13, 2006

Are you asking for the connection string or a whole script to process your form? Do you have any programming experience or are you trying to learn?If you are looking for a whole script I can only provide a small sample but you will be able to expand it easily to include more form fields.Also are you using Visual Studio or Notepad? It will make a difference in the answer I can give you.
<{POST_SNAPBACK}>

thanks for replying to my problem.....

my coding that i have can be seen below.....i just need any coding that links this page to access.....i have no idea what i need the connection string or the whole script however u can help me....will make me happy.........<%@ Page Language="VB" %><script runat="server"> ' Insert page code here ' Sub Button1_Click(sender As Object, e As EventArgs) response.redirect ("http://localhost/entersite.aspx") End Sub Sub Button4_Click(sender As Object, e As EventArgs) response.redirect ("http://localhost/location.aspx") End Sub Sub Button5_Click(sender As Object, e As EventArgs) response.redirect ("http://localhost/menus.aspx") End Sub Sub Button6_Click(sender As Object, e As EventArgs) response.redirect ("http://localhost/offers.aspx") End Sub Sub Button7_Click(sender As Object, e As EventArgs) response.redirect ("http://localhost/freelunch.aspx") End Sub Sub Button8_Click(sender As Object, e As EventArgs) response.redirect ("http://localhost/bookings.aspx") End Sub Sub Button10_Click(sender As Object, e As EventArgs) response.redirect ("http://localhost/feedback.aspx") End Sub Sub Button11_Click(sender As Object, e As EventArgs) response.redirect ("http://localhost/question.aspx") End Sub Sub Button12_Click(sender As Object, e As EventArgs) response.redirect ("http://localhost/recommend.aspx") End Sub</script><html><head></head><body bgcolor="black"> <form runat="server"> <img height="95" src="flag.gif" width="185" /> JOBS <img height="95" src="flag.gif" width="185" /> <asp:Button id="Button1" onclick="Button1_Click" runat="server" Width="148px" BackColor="DodgerBlue" ForeColor="White" Font-Names="Trebuchet MS" Font-Bold="True" BorderWidth="2px" BorderColor="DarkGray" Height="26px" Font-Size="Smaller" Text="BACK TO HOMEPAGE"></asp:Button> <asp:Button id="Button4" onclick="Button4_Click" runat="server" Width="148px" BackColor="White" Font-Names="Trebuchet MS" Font-Bold="True" BorderWidth="2px" BorderColor="DarkGray" Height="26px" Font-Size="Smaller" Text="LOCATION"></asp:Button> <asp:Button id="Button5" onclick="Button5_Click" runat="server" Width="148px" BackColor="Red" ForeColor="White" Font-Names="Trebuchet MS" Font-Bold="True" BorderWidth="2px" BorderColor="DarkGray" Height="26px" Font-Size="Smaller" Text="MENUS"></asp:Button> <asp:Button id="Button6" onclick="Button6_Click" runat="server" Width="148px" BackColor="DodgerBlue" ForeColor="White" Font-Names="Trebuchet MS" Font-Bold="True" BorderColor="DarkGray" Height="26px" Font-Size="Smaller" Text="OFFERS"></asp:Button> <asp:Button id="Button7" onclick="Button7_Click" runat="server" Width="148px" BackColor="White" Font-Names="Trebuchet MS" Font-Bold="True" BorderWidth="2px" BorderColor="DarkGray" Height="26px" Font-Size="Smaller" Text="WIN A FREE LUNCH"></asp:Button> <asp:Button id="Button8" onclick="Button8_Click" runat="server" Width="148px" BackColor="Red" ForeColor="White" Font-Names="Trebuchet MS" Font-Bold="True" BorderWidth="2px" BorderColor="DarkGray" Height="26px" Font-Size="Smaller" Text="BOOKINGS"></asp:Button> <asp:Button id="Button10" onclick="Button10_Click" runat="server" Width="148px" BackColor="DodgerBlue" ForeColor="White" Font-Names="Trebuchet MS" Font-Bold="True" BorderWidth="2px" BorderColor="DarkGray" Height="26px" Font-Size="Smaller" Text="FEEDBACK"></asp:Button> <asp:Button id="Button11" onclick="Button11_Click" runat="server" Width="148px" BackColor="White" Font-Names="Trebuchet MS" Font-Bold="True" BorderWidth="2px" BorderColor="DarkGray" Height="26px" Font-Size="Smaller" Text="KIDS CORNER"></asp:Button> <asp:Button id="Button12" onclick="Button12_Click" runat="server" Width="148px" BackColor="Red" ForeColor="White" Font-Names="Trebuchet MS" Font-Bold="True" BorderWidth="2px" BorderColor="DarkGray" Height="26px" Font-Size="Smaller" Text="RECOMMEND"></asp:Button> If you would like to work for us at Back Inn Time, then fill in the form belows and we will get back to you regarding the postitions that we have. NAME : <asp:TextBox id="name" runat="server" Width="296px"></asp:TextBox> <asp:RequiredFieldValidator id="RequiredFieldValidator1" runat="server" BackColor="Black" ForeColor="DodgerBlue" Font-Names="Trebuchet MS" Font-Bold="True" ErrorMessage="Please enter your name." Display="Dynamic" ControlToValidate="name"></asp:RequiredFieldValidator> DATE OF BIRTH : <asp:TextBox id="dob" runat="server" Width="234px"></asp:TextBox> <asp:RequiredFieldValidator id="RequiredFieldValidator2" runat="server" BackColor="Black" Font-Names="Trebuchet MS" Font-Bold="True" ErrorMessage="Please enter your date of birth." Display="Dynamic" ControlToValidate="dob"></asp:RequiredFieldValidator> <asp:CompareValidator id="CompareValidator1" runat="server" BackColor="Black" ForeColor="DodgerBlue" Font-Names="Trebuchet MS" Font-Bold="True" ErrorMessage="Please re-type your date of birth in the format of DD/MM/YYYY" Display="Dynamic" ControlToValidate="dob" Operator="DataTypeCheck" Type="Date"></asp:CompareValidator> CONTACT NUMBER: <asp:TextBox id="telephone" runat="server" Width="210px"></asp:TextBox> EMAIL ADDRESS: <asp:TextBox id="email" runat="server" Width="298px"></asp:TextBox> <asp:RequiredFieldValidator id="RequiredFieldValidator3" runat="server" BackColor="Black" ForeColor="DodgerBlue" Font-Names="Trebuchet MS" Font-Bold="True" ErrorMessage="Please type your email address." Display="Dynamic" ControlToValidate="email"></asp:RequiredFieldValidator> <asp:RegularExpressionValidator id="RegularExpressionValidator1" runat="server" BackColor="Black" Font-Names="Trebuchet MS" Font-Bold="True" ErrorMessage="Please re-type your email address in the correct format." Display="Dynamic" ControlToValidate="email" ValidationExpression="\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator> JOB APPLYING FOR : <asp:DropDownList id="jobs" runat="server" Width="157px"> <asp:ListItem Value="Please Select One" Selected="True">Please Select One</asp:ListItem> <asp:ListItem Value="Bar Work">Bar Work</asp:ListItem> <asp:ListItem Value="Waiting Tables">Waiting Tables</asp:ListItem> <asp:ListItem Value="Chef">Chef</asp:ListItem> <asp:ListItem Value="Assistant Chef">Assistant Chef</asp:ListItem> <asp:ListItem Value="Kitchen Staff">Kitchen Staff</asp:ListItem> <asp:ListItem Value="Cleaner">Cleaner</asp:ListItem> <asp:ListItem></asp:ListItem> </asp:DropDownList> <asp:RequiredFieldValidator id="RequiredFieldValidator5" runat="server" ForeColor="DodgerBlue" Font-Names="Trebuchet MS" Font-Bold="True" ErrorMessage="Please select a job." Display="Dynamic" ControlToValidate="jobs"></asp:RequiredFieldValidator> EXPERIENCE: <asp:TextBox id="experience" runat="server" TextMode="MultiLine"></asp:TextBox> <asp:RequiredFieldValidator id="RequiredFieldValidator4" runat="server" Font-Names="Trebuchet MS" Font-Bold="True" ErrorMessage="Please enter in some information." Display="Dynamic" ControlToValidate="experience"></asp:RequiredFieldValidator> <asp:Button id="Button2" onclick="Button1_Click" runat="server" Width="148px" BackColor="DodgerBlue" ForeColor="White" Font-Names="Trebuchet MS" Font-Bold="True" BorderWidth="2px" BorderColor="DarkGray" Height="26px" Font-Size="Smaller" Text="SUBMIT"></asp:Button> </form></body></html>im using NOTEPAD i think........thanks again

Sign In

ACCESS AND ASP

Recommended Posts

jessie123

Link to comment

Share on other sites

aspnetguy

Link to comment

Share on other sites

jessie123

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Browse

Activity