What Is ... .NET (ASP) | This series covers the basics the new (or practicing) .NET developer will need to know before they being to develop a Website in ASP.NET. It comprises 4 articles; Chapter 1: Introduction to .NET (ASP) | This chapter begins by asking the questions, "What is .NET?" and, "What is ASP.NET?" It then goes on to explain what you'll need to get started, and how to install all the necessary software. Finish off by developing your first ASP.NET page! (SOURCE >> >> For more on .NET in general, see >> our .NET page

What is ASP.NET? | For years now, Active Server Pages (ASP) has been arguably the leading choice for Web developers building dynamic Websites on Windows Web servers. ASP has gained popularity by offering the simplicity of flexible scripting via several languages. That, combined with the fact that itís built into every Microsoft Windows-based Web server, has made ASP a difficult act to follow.

ASP.NET is a server-side technology for developing Web applications based on the Microsoft .NET Framework.


Software and related

How to .NET (ASP) | Installing the Required Software > This section tackles the necessary installation and configuration of software that you'll need for this book, including:

more Information

Plus -

- also going to need a database.

+DB ... Microsoft Access or

+SQL Server Desktop Engine (MSDE). For that, you can go to ( Start > Programs > Microsoft Framework SDK, and choose Samples and QuickStart Tutorials.

Choose the Download and Install the Microsoft SQL Server 2000 Desktop Engine link.
You will be redirected to a download page on Microsoft's Website.

+Web Data (dB) Administrator (like phpAdmin); you can download this program from Microsoft's developer site.

Or ... MySQL? use LAMP Stack? the MySQL website. >>

MySQL on Windows | MySQL provides you with a suite of tools for developing and managing business critical applications on Windows. >>

Download Connector/Net | Connector/Net is a fully-managed ADO.NET driver for MySQL. >>

A Step-by-Step Guide To Using MySQL with ASP.NET - Part 1 | Step 1 - Installation Step 2 - Configuration The MySQL Server Instance Configuration Wizard makes configuring your server really simple.

> server type as "Developer Machine" > Multi-functional Database > enable TCP/IP networking, port 3306 ? ... enable TCP/IP networking in order to allow the web server to connect to the database when we get to building a web page to query the database. > Standard Chatacter set > Install as Windows service > Modify Security settings (root pwd)

recommend you download and install the MySQL Administrator. >> << (can also use phpAdmin ) Because,

1. In order to create our database, we first need to connect to the server. Run (MySQL/php) Administrator and login to your server using the password you set during installation.

2. You'll then want to select the "Catalogs" item at the bottom left of the MySQL Administrator window. This should bring up a list of the current databases on the server (There should be two of them: "mysql" and "test"). If you right-click in the small window where they are listed you should get the option to "Create New Schema".

3. You'll then be prompted to enter a name for the new database in the Schema Name.

4. Creating a Table | To create a table simply click on the "Create Table" button.

When you're done making changes, you simply click the "Apply Changes" button. A window that looks something like the one below will pop up showing you the SQL that will be executed and asking you to confirm that you want to save changes to the table design.

5. Adding Data | In the real world, data in your table would probably come in via your application. To get some sample data into our table, I'm simply going to insert a few lines by hand, entering INPUT statements using the MySQL Command Line Client. SOURCE >>

Step 7 - Creating a New MySQL User Account | I'm assuming that you're been following along with part one, so at this point you should have the MySQL Server and MySQL Adminstrator installed, and have a sample database named "mydatabase" which contains a sample table named "mytable" with two rows of data in it.

In order to add a new user account, we'll once again need to run MySQL Administrator and login to your server using the password you set during installation. You'll then want to select the "User Administration" item from the list of items at the left of the MySQL Administrator window. This should bring up a list of the current user account on the server (There should already be once called "root").

Step 8 - Granting the User Account Access to the Database | By default new users have permission to do almost nothing. In order to allow our new user to connect to the MySQL database server, we need to grant him what MySQL calls "Schema Privileges". This is naturally done from the "Schema Privileges" tab in MySQL Administrator.

Step 9 - Connecting to the Database Server from an ASP.NET Page | To my knowledge there are currently two main ways to connect to a MySQL database server from .NET: MySQL Connector/ODBC (aka. MyODBC) and MySQL Connector/Net. >> << While the ODBC connector is cross-platform and is compliant with ODBC standards, the .NET version is generally the better choice when using MySQL with .NET.

The setup files can be downloaded from the MySQL Connector/Net page and installation is straight-forward.

Step 10 - A Sample ASP.NET Page to Query a MySQL Database | So with our MySQL database finally squared away and MySQL Connector/Net installed, we can now start using MySQL from our ASP.NET web pages.

// MySQL.aspx

<%@ Page Language="VB" debug="true" %>

<%@ Import Namespace = "System.Data" %> <%@ Import Namespace = "MySql.Data.MySqlClient" %>

Simple MySQL Database Query


see also ...

C# ASP.NET MySQL Connection Tutorial with MySQL Connector | In order to connect to MySQL Server with .NET in C# or ASP.NET: You need to download MySQL Connector/Net . >>

MySQL - Getting started | The easiest way to use MySQL with ASP.NET is to use the MySQL ODBC Connector from MySQL AB. If you're work is being hosted by a company which supports MySQL, they have probably already installed this, but if you're testing your code on your own machine with your own instance of MySQL, then you need to install this. MySQL Connector/ODBC 3.51 can be downloaded from this page: >> SOURCE >>

- and (!) a development environment (IDE) like Visual Studio .NET - >> * VS Downloads >>

Official Microsoft ASP.NET support Website can be found at >> (SOURCE >>

Send a Message

Please feel free to use our FeedBack form to give us input.

Who are you?
e-mail address:

Bulletin Board

Leave a Note

INSTRUCTIONS Enter the NotePad! Enter questions, comments and link info in the NotePad, NOTE - we do NOT automatically capture e-mail address - you must enter it.   EDITing is up to you, what you submit is what gets posted.   To request further maintenance -or- for more private communications, use the FeedBack form, above.

Post Here

Who are you:
Where are you from:
What would you like to say:

posted Comments

Thanx! for stopping by -and- Spread the Word!