Access Database Editor

**Grayson_Peddie** · 01-03-2004

Hi. I'm looking for a database editor and I'm in a tight budget. Is there any database editors that were similar to Microsoft Access? A database editor without a wizard is okay for me, by the way, since I just want to create databases for my web site. (I use Visual C# .net to create .net web sites.)

**-=SoKrA=-** · 01-04-2004

You use C# to crate websites? You're crazy!
Anyway, if you can use php, there's something called phpMyAdmin which can be used as a front-end for MySQL databses.

**Grayson_Peddie** · 01-04-2004

My web server doesn't have support for SQL (only Access) but I got OpenOffice. Thanks for your help.

**-=SoKrA=-** · 01-04-2004

At first I read Acess as a verb, rather than the db app, which is why I pointed you to phpMyAdmin.
I wouldn't think microsoft'd give front-end away, but you might get lucky.

**Grayson_Peddie** · 01-04-2004

The *.mdb is a Microsoft Access Database file.

**ober** · 01-04-2004

what server are you using and why are they only allowing you to use access dbs? (btw, I find this hard to believe because few people in their normal state of mind would want to use Access for a web database.

Do yourself a favor. STFW for tutorials on PHP and MySQL. Both would be free for you to use and as long as your server supports both, you should be good to go. (And as long as you're not trying to make a profit off of them)

I've never heard of anyone interfacing with an Access DB across the web. It just seems ridiculous.

**Grayson_Peddie** · 01-04-2004

I only use Visual C# to create web sites and I don't know if MySQL will work with the server since my web server (UpLinkEarth.com) only support Access. My web hosting provider, UpLinkEarth might support SQL in the future but I don't know when. Also, I don't think that Visual C# supports PHP but I will try it out.

Thanks for your help.

**ober** · 01-04-2004

Here's a thought. Stop using Visual C# to make websites. Why not use plain old html and PHP???? I don't even understand how you're making a website with Visual C#. wtf.

If your provider doesn't support SQL servers like MySQL then maybe you should find a new provider.

**Grayson_Peddie** · 01-04-2004

I suck at HTML. The reason I don't like HTML is HTML is hard for me because of < and >. With HTML, I tend to type slow.

I chose ASP.net over PHP because ASP.net supports about 25 languages. And so, I chose C# because C# is a lot easier to learn than HTML/PHP.

Take a look at this:
http://www.hands-on-labs.com/only4gu...ft/php_asp.pdf

I only stay with C#.

**Waldo2k2** · 01-04-2004

>>I only stay with C#.

a programming angel just lost it's wings....I love php

**[EMOBA]** · 01-04-2004

've never heard of anyone interfacing with an Access DB across the web. It just seems ridiculous.

Unfortunately, it's all too common.

**EvBladeRunnervE** · 01-04-2004

Unfortunately, it's all too common.

yes, I had a computer science lab prof. who thought MS office products were great... I am so glad that most of my CS prof. absolutely hate MS.

**-=SoKrA=-** · 01-04-2004

>>I had a computer science lab prof. who thought
>>MS office products were great...
Mine told us to do modular design with Word because he couldn't install a CAD program the school bought. Terrible

I think absoultely hating MS is a bit extreme, algthough it opens a lot of possiblities.

**ober** · 01-04-2004

Originally posted by Grayson_Peddie
I suck at HTML. The reason I don't like HTML is HTML is hard for me because of < and >. With HTML, I tend to type slow.

I chose ASP.net over PHP because ASP.net supports about 25 languages. And so, I chose C# because C# is a lot easier to learn than HTML/PHP.

I'm sorry, but you cannot be serious. It is web developers like yourself that seriously ........ me off. HTML has got to be one of the easiest things to learn. It's a couple tags. If you said you had a problem learning Javascript, then I might consider you somewhat useful, but give me a break. And PHP? It doesn't get much easier than PHP for scripting.

ASP restricts you to windows based servers. What if your provider decides to switch to all linux machines? You will be F-ed, my friend.

And I don't know C#, but I have a feeling it is harder to learn than HTML and PHP.

**Grayson_Peddie** · 01-04-2004

Just to show you my proof that C# is a lot easier to code and read than HTML, I found C# easier to read than HTML. And my web hosting provider uses Microsoft Windows. I don't use Linux (I don't like Linux that much).

Here's what I do when I create a simple web page.

In Visual C# .net, I create a new ASP.net template project.

Let's say that I want to create a listbox with a textbox, Add, Remove, Remove All, and a status label.

I give the following ID to each of the controls:

Textbox: txtItemName
Button: btnAdd
ListBox: lbItems
Button: btnRemove
Button: btnRemoveAll
Label: lblStatusInfo

When you first double-click the control, VC# creates a code automatically. For example, if I double-click Add, I will see this:

Code:

private void btnAdd_Clicked(object sender, System.EventArgs e)
{
    
}

Visual C# had also added the code for the web form designer:

Code:

this.btnAdd.Clicked += new System.EventHandler(this.btnAdd_Clicked);

The code that start with "this.btnAdd.Clicked" executes the code:

Code:

private void btnAdd_Clicked(object sender, System.EventArgs e)
{
    
}

...when a user clicks a button.

Since the add button is for adding the name of the text from txtItemName, I add the code inside the btnAdd_Clicked() function:

Code:

private void btnAdd_Clicked(object sender, System.EventArgs e)
{
    if(txtItemName.Text != "")
    {
        lbItems.Items.Add(txtItemName.Text);
        lblStatusInfo.Text = "You have added " + txtItemName.Text +
            " to the list.";
        btnRemove.Enabled = true;
        btnRemoveAll.Enabled = true;
    }
    else
    {
        lblStatusInfo.Text = "No name in the text box.";
    }

What this does is when you click the Add button, it copies from txtItemName into lblItems' list box. The lblStatusInfo lets a user know that s/he had added an item to the list. But if there's no text in the txtItemName text box, lblStatusInfo will mention "No name in the text box." Pretty simple.

Here's the code for the Remove button, btnRemove:

Code:

        private void btnRemove_Click(object sender, System.EventArgs e)
        {
            string GetItem;
            try
            {
                if(lbItems.SelectedIndex != 0)
                {
                    GetItem = lbItems.SelectedItem.Text.ToString();
                    lbItems.Items.Remove(lbItems.SelectedItem.Text);
                }
                else
                {
                    lblStatusInfo.Text = "You need to select an item" +
                        " from the list.";
                }
            }
            catch
            {
                lblStatusInfo.Text = "You have removed " + GetItem +
                    "from the list.";
            }
            if(lbItems.Items.Count == 0)
            {
                btnRemove.Enabled = false;
                btnRemoveAll.Enabled = false;
            }
        }

This code, when you press Remove after you select (or if you don't select) an item, handles the exception. The web page will generate an error if you don't select an item. Of course, if there's no items in the list, two buttons: Remove and Remove All, will be disabled.

The third, and last button called Remove All (btnRemoveAll), removes all the items in the list. This is a very simple code.

Code:

       private void btnRemoveAll_Click(object sender, System.EventArgs e)
        {
            if(lbItems.Items.Count != 0)
            {
                lbItems.Items.Clear();
                lblStatusInfo.Text = "You have removed all the items" +
                    " from the list.";
            }
            btnRemove.Enabled = false;
            btnRemoveAll.Enabled = false;
        }

Here's the full source code in C#:

Code:

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace www.future_gpnet.com
{
    /// <summary>
    /// Summary description for Sampler.
    /// </summary>
    public class Sampler : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.Label Label1;
        protected System.Web.UI.WebControls.Button btnAdd;
        protected System.Web.UI.WebControls.ListBox lbItems;
        protected System.Web.UI.WebControls.Button btnRemove;
        protected System.Web.UI.WebControls.TextBox txtItemName;
        protected System.Web.UI.WebControls.Label lblStatusInfo;
        protected System.Web.UI.WebControls.Button btnRemoveAll;
    
        private void Page_Load(object sender, System.EventArgs e)
        {
            // Put user code to initialize the page here
        }

        #region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
            base.OnInit(e);
        }
        
        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {    
            this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);
            this.btnRemove.Click += new System.EventHandler(this.btnRemove_Click);
            this.btnRemoveAll.Click += new System.EventHandler(this.btnRemoveAll_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
		#endregion

        private void btnAdd_Click(object sender, System.EventArgs e)
        {
            if(txtItemName.Text != "")
            {
                lbItems.Items.Add(txtItemName.Text);
                lblStatusInfo.Text = "You have added " + txtItemName.Text +
                    " to the list.";
                btnRemove.Enabled = true;
                btnRemoveAll.Enabled = true;
            }
            else
            {
                lblStatusInfo.Text = "No name in the text box.";
            }
        }

        string GetItem;
        private void btnRemove_Click(object sender, System.EventArgs e)
        {
            try
            {
                GetItem = lbItems.SelectedItem.Text.ToString();
                lbItems.Items.Remove(lbItems.SelectedItem.Text);
                lblStatusInfo.Text = "You have removed " + GetItem +
                    " from the list.";
            }
            catch
            {
                lblStatusInfo.Text = "You need to select an item" +
                    " from the list.";
            }
            if(lbItems.Items.Count == 0)
            {
                btnRemove.Enabled = false;
                btnRemoveAll.Enabled = false;
            }
        }

        private void btnRemoveAll_Click(object sender, System.EventArgs e)
        {
            if(lbItems.Items.Count != 0)
            {
                lbItems.Items.Clear();
                lblStatusInfo.Text = "You have removed all the items" +
                    " from the list.";
            }
            btnRemove.Enabled = false;
            btnRemoveAll.Enabled = false;
        }
    }
}

Here's the source code generated by Visual C# .net:

Code:

<%@ Page language="c#" Codebehind="Sampler.aspx.cs" AutoEventWireup="false" Inherits="www.future_gpnet.com.Sampler" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
    <HEAD>
        <title>Sampler</title>
        <meta name="GENERATOR" Content="Microsoft Visual Studio 7.0">
        <meta name="CODE_LANGUAGE" Content="C#">
        <meta name="vs_defaultClientScript" content="JavaScript">
        <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
    </HEAD>
    <body MS_POSITIONING="GridLayout" text="white" bgColor="black">
        <form id="Sampler" method="post" runat="server">
            <asp:Label id="Label1" style="Z-INDEX: 101; LEFT: 15px; POSITION: absolute; TOP: 11px" runat="server" Width="331px" Height="19px">Enter an item in the text box below and click Add to add an item to the list</asp:Label>
            <asp:Button id="btnRemoveAll" style="Z-INDEX: 106; LEFT: 334px; POSITION: absolute; TOP: 120px" runat="server" Width="92px" BackColor="#C00000" ForeColor="White" Text="Remove All"></asp:Button>
            <asp:TextBox id="txtItemName" style="Z-INDEX: 102; LEFT: 17px; POSITION: absolute; TOP: 59px" runat="server" Width="315px" Height="23px" BackColor="Black" ForeColor="White"></asp:TextBox>
            <asp:Button id="btnAdd" style="Z-INDEX: 103; LEFT: 333px; POSITION: absolute; TOP: 59px" runat="server" Width="92px" BackColor="Green" Text="Add"></asp:Button>
            <asp:ListBox id="lbItems" style="Z-INDEX: 104; LEFT: 17px; POSITION: absolute; TOP: 87px" runat="server" Width="316px" Height="220px" BackColor="Black" ForeColor="White">
                <asp:ListItem Value="Made by Grayson Peddie">Made by Grayson Peddie</asp:ListItem>
                <asp:ListItem Value="Used with Visual C# .net">Used with Visual C# .net</asp:ListItem>
            </asp:ListBox>
            <asp:Button id="btnRemove" style="Z-INDEX: 105; LEFT: 334px; POSITION: absolute; TOP: 89px" runat="server" Width="92px" BackColor="#C00000" ForeColor="White" Text="Remove"></asp:Button>
            <asp:Label id="lblStatusInfo" style="Z-INDEX: 107; LEFT: 18px; POSITION: absolute; TOP: 306px" runat="server" Width="317px" Height="71px"></asp:Label>
        </form>
    </body>
</HTML>

This is an ASP.net code, by the way.

Why don't you try out my sample just to give you a feel of how ASP.net and C# works? Here's the link:
http://www.future-gpnet.com/Sampler.aspx

Access Database Editor

LinkBack

Thread Tools

Display

Access Database Editor

Similar Threads

How to add a database from access in c++

CGI with MS Access database integration

connecting to ms access database

Mfc Dao Access Database