Solved

Access Database with Visual Web developer

Posted on 2006-06-20
1
409 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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
EvenOdd challenge 10 81
for loop with Set 4 45
changeXy challenge 13 56
Counting documents in a Domino View 3 31
This is about my first experience with programming Arduino.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
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…

763 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

15 Experts available now in Live!

Get 1:1 Help Now