Solved

Access Database with Visual Web developer

Posted on 2006-06-20
1
413 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ejb wildfly example 2 24
Help Required 2 39
SQL Insert parts by customer 12 42
Selenium docs api java index 3 48
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.

860 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