Shulou(Shulou.com)05/31 Report--

The example analysis of the combination of MySQL and ASP.NET, aiming at this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

MySQL is more powerful with ASP.NET.

Due to its competitive price and ease of use, MySQL has gradually increased its market share. In order to expand the use of MySQL, the open source community has developed database connectors that can be used in the .net framework (.NET Framework). Let's learn how to use MySQL in .net applications.

MySQL has gradually become a feasible database solution when choosing a database platform. What proves this is that many companies have chosen mySQL as their database platform, such as Google, the Associated Press (The Associated Press) and NASA. Although for an open source code, low price is often used as a major advantage to convince customers, but for large-scale organizations like Google, they will not rest assured to store very useful information in a database product with only price advantage. MySQL's real strength far outweighs his price advantage, providing a wealth of additional tools from the open source community and commercialization.

Data Integration with. Net

The MySQL community has developed a data interface for MySQL, which provides basic functions for connecting data sources and program code. On the Windows platform, there are the following MySQL connectors:

* MySQL Connector/Net 1.0 (formerly known as ByteFX.Data): is an open source .NET data interface designed for MySQL. It is developed entirely in C # and can be found on the MySQL.com website. (note: in the examples in this article, we all use MySQL Connector/Net 1.0 as a data interface to connect to the database, which can be easily installed using the Windows installer, and its code examples and documentation are included.)

* MySQLDirect .NET Data Provider: is a commercial data interface developed by Core Lab. His price is determined by the type of license purchased, but we can download a trial version of it.

If you use Mono, you can find downloads of the PHP connector on the Mono website. If you run Mono on the Windows platform, the connector you download includes the installer. If not, download the appropriate connector according to the type of operating system you have.

Use the MySQL data interface

After installing MySQL's data interface, you must introduce it into your code before you can use it. You can use the MySql.Data.MySqlClient namespace to connect to the MySQL server. In C #, you can use the using statement to introduce the MySQL data interface:

Using MySql.Data.MySqlClient

In addition, you can also introduce the MySQL data interface in an ASP.NET web form (Web Form) by using the Import command:

Alternatively, you can write the full path of a class when using this namespace in your code, but it will waste more characters and bytes than using the Import instruction to import input. Once the namespace is specified, we can interact with the MySQL database. The MySql.Data.MySqlClient namespace provides a number of classes for working with MySQL data. Here is a sample of these classes:

* MySqlConnection: manage connections to MySQL servers / databases

* MySqlDataAdapter: a set of commands and connections for populating DataSet objects and updating MySQL databases

* MySqlDataReader: enables you to read data from a MySQL database. It is an one-way data stream

* MySqlCommand: provides the ability to send instructions to the database server

* MySqlException: provide exception handling when a problem occurs.

We will use some of these classes to interact with our sample database.

Connect to MySQL database

The first step in using a MySQL database is to establish a connection to the database through the MySQLConnection class. Through a connection string, MySqlConnection will be instantiated as an example. The connection string will tell the code where to find the MySQL server and other options.

A connection string tells the code to connect to a MySQL server named MySQLTestServer and enter the techrepublic database using the specified user name and password. I set it on my test machine to allow anonymous login (this setting has a very large security vulnerability, so it is not recommended that you do the same on the production server), so the following connection string will be used in the example:

"server=localhost; database=sitepoint;"

Once the connection string is specified, the Open method of the MySqlConnection object is called and the connection is opened. Once the connection is established, you can send commands to or get data from the MySQL database.

Combination of ASP.NET and MySQL

Let's take a closer look at combining the MySqlConnection class with other classes to generate a list of databases on the MySQL server. Table B lists a web page form written in ASP.NET in C #. It establishes a connection, then gives the server an instruction (SHOW DATABASES), and then displays the results through the MySqlReader object.

The result of sending a SHOW DATABASES command to the MySQL server with a MySqlCommand object is the same as entering this command directly into the MySQL management tool. The only difference is that we have to use another object in the code to get the result set. The MySqlDataReader object is instantiated when the result is obtained (through the ExecuteReader method of the MySqlCommand class). The GetString method of the MySqlDataReader object is used to display the data in the result set through the label control of ASP.NET. The pointer 0 of the GetString method specifies the first column of data that displays the current row of the result set (in the while loop).

Mono hint

If you use the open source Mono development platform, the code in the example only needs to make minor changes to work properly. The data interface for MySQL is in the space name ByteFX.Data.MySqlClient, not the MySql.Data.MySqlClient space name on Windows. In fact, MySQL's data interface was originally developed by ByteFX, but was later acquired by MySQL. So if you use Mono, you must declare the space name as follows:

Using ByteFX.Data.MySqlClient

The combination of MySQL and .NET provides a powerful development platform. MySQL has strong technical support in the open source community, and .NET is accepted by the open source community through Mono. This combination provides a highly flexible development platform in Windows and other languages such as UNIX or Linux.

This is the answer to the sample analysis question about the combination of MySQL and ASP.NET. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.