Solved

Access Database with Visual Web developer

Posted on 2006-06-20
1
410 Views
Last Modified: 2013-12-04
I have just started using visual web developer and have created an access database called computerswaps.mdb.
I can get the data to display online but can't figure out how to input data to the database from the web interface.  All I have in the web site now are two pages:
default.aspx which is my actual web page
web.config

Here are the contents of default.aspx

<%@ Page Language="C#" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>DAH Computers</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <br />
        <strong><span style="font-size: 24pt">Department of Arkansas Heritage Computers<br />
        </span></strong>
        <br />
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:computer_swapsConnectionString %>"
            ProviderName="<%$ ConnectionStrings:computer_swapsConnectionString.ProviderName %>"
            SelectCommand="SELECT * FROM [Computers] ORDER BY [Old PC Name]"></asp:SqlDataSource>
   
    </div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="7"
            DataKeyNames="ID" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None">
            <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <Columns>
                <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
                    SortExpression="ID" />
                <asp:BoundField DataField="Dept" HeaderText="Dept" SortExpression="Dept" />
                <asp:BoundField DataField="Name of Main User" HeaderText="Name of Main User" SortExpression="Name of Main User" />
                <asp:BoundField DataField="Old PC Name" HeaderText="Old PC Name" SortExpression="Old PC Name" />
                <asp:BoundField DataField="New PC Name" HeaderText="New PC Name" SortExpression="New PC Name" />
                <asp:BoundField DataField="Old  Serial" HeaderText="Old  Serial" SortExpression="Old  Serial" />
                <asp:BoundField DataField="New Serial" HeaderText="New Serial" SortExpression="New Serial" />
                <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" />
                <asp:BoundField DataField="Installer" HeaderText="Installer" SortExpression="Installer" />
                <asp:BoundField DataField="Notes" HeaderText="Notes" SortExpression="Notes" />
                <asp:BoundField DataField="Field10" HeaderText="Field10" SortExpression="Field10" />
            </Columns>
            <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
            <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
            <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>
    </form>
</body>
</html>

Here is the web.config file:

<?xml version="1.0"?>
<!--
    Note: As an alternative to hand editing this file you can use the
    web admin tool to configure settings for your application. Use
    the Website->Asp.Net Configuration option in Visual Studio.
    A full list of settings and comments can be found in
    machine.config.comments usually located in
    \Windows\Microsoft.Net\Framework\v2.x\Config
-->
<configuration>
      <appSettings/>
      <connectionStrings>
            <add name="computer_swapsConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ftp-web\inetpub\wwwroot\dah_intranet\computer_database\computer_swaps.mdb" providerName="System.Data.OleDb"/>
      </connectionStrings>
      <system.web>
            <!--
            Set compilation debug="true" to insert debugging
            symbols into the compiled page. Because this
            affects performance, set this value to true only
            during development.
        -->
            <compilation debug="true"/>
            <!--
            The <authentication> section enables configuration
            of the security authentication mode used by
            ASP.NET to identify an incoming user.
        -->
            <authentication mode="Windows"/>
            <!--
            The <customErrors> section enables configuration
            of what to do if/when an unhandled error occurs
            during the execution of a request. Specifically,
            it enables developers to configure html error pages
            to be displayed in place of a error stack trace.

        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm" />
            <error statusCode="404" redirect="FileNotFound.htm" />
        </customErrors>
        -->
      </system.web>
</configuration>

I haven't done alot of coding but I realize I'll probably have to do some to get this working because it doesn't seem to be a gui option.
Any help would be greatly appreciated.  

Thanks, Karen
0
Comment
Question by:ksilvoso
1 Comment
 
LVL 3

Accepted Solution

by:
Dimkov earned 500 total points
ID: 16948845
ksilvoso

Adding a row in the database is merely just executing another SQL Insert string.
Something like
INSERT INTO tableName (fieldOne) VALUES ('valueOne');

A good reference could be
http://www.tutorial-web.com/asp/database/
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
topping3 challenge 14 70
Counting documents in a Domino View 3 66
Auto-indent certain lines in Notepad++ 10 31
"Black Box" Testing of Control System Software 2 26
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now