A simple ASP. NET Access to MySql database favorites

A simple ASP. NET access MySql database Favorites

Download ADO. NET Driver for MySQLMySql. Data. dll

After installation, find the Assemblies folder under the installation directory and find MySql. Data. dll

(This file is a. Net driver for accessing the MySQL database. It is in full ADO. NET data access mode and is officially provided by MySQL. Multiple versions are available .)

A link to learning: http://www.cnblogs.com/wcfgroup/articles/1242256.html

Create an asp.net website and add reference MySql. Data. dll to the website.

Add:

<Add key = "mysqlconn" value = "server = 192.168.1.102; database = database name; uid = user name; pwd = password;"> </add>

This user name and password are set during MySql installation.

Create a class file to access the MySql database: MySqlClass. cs

The file code is as follows:

View plaincopy to clipboardprint?

1. Using System;
2. Using System. Collections. Generic;
3. Using System. Web;
4. Using MySql. Data. Types;
5. Using MySql. Data. MySqlClient;
6. Using System. Configuration;
7. Using System. Data;
8. /// <Summary>
9. /// Summary of MySqlClass
10. /// </Summary>
11. Public class MySqlClass
12. {
13. Private MySqlConnection conn;
14. Private MySqlCommand com;
16. # Region construction
17. Public MySqlClass ()
18. {
19. Try
20. {
21. Conn = new MySqlConnection (ConfigurationManager. etettings ["mysqlconn"]);
22. Conn. Open ();
23. Com = new MySqlCommand ();
24. Com. Connection = conn;
25. }
26. Catch (Exception ee)
27. {
28. Throw new Exception ("database connection error ");
29. }
30. }
31. # Endregion
32. # Region obtaining DataSet
33. Public DataSet GetDataSet (string sqlString)
34. {
35. DataSet ds = new DataSet ();
36. Try
37. {
38. MySqlDataAdapter da = new MySqlDataAdapter (sqlString, conn );
39. Da. Fill (ds );
40. }
41. Catch (Exception ee)
42. {
43. Throw new Exception ("SQL:" + sqlString + "<br/>" + ee. Message. ToString ());
44. }
45. Return ds;
46. }
47. # Endregion
48. }

Using System; using System. collections. generic; using System. web; using MySql. data. types; using MySql. data. mySqlClient; using System. configuration; using System. data; // <summary> /// summary of MySqlClass /// </summary> public class MySqlClass {private MySqlConnection conn; private MySqlCommand com; # region construct public MySqlClass () {try {conn = new MySqlConnection (ConfigurationManager. appSettings ["mysqlconn"]); conn. open (); com = new MySqlCommand (); com. connection = conn;} catch (Exception ee) {throw new Exception ("database Connection error") ;}# endregion # region gets DataSet public DataSet GetDataSet (string sqlString) {DataSet ds = new DataSet (); try {MySqlDataAdapter da = new MySqlDataAdapter (sqlString, conn); da. fill (ds);} catch (Exception ee) {throw new Exception ("SQL:" + sqlString + "<br/>" + ee. message. toString ();} return ds ;}# endregion}

2. Create An aspx page and pull a Girdview control on the page,

View plaincopy to clipboardprint?

1. <Asp: GridView runat = "server" ID = "GirdView1"> </asp: GridView>

Write the following code on the aspx. cs page of aspx:

View plaincopy to clipboardprint?

1. Protected void Page_Load (object sender, EventArgs e)
2. {
3. If (! IsPostBack)
4. {
5. MySqlClass mysqlClass = new MySqlClass ();
6. GirdView1. DataSource = mysqlClass. GetDataSet ("SELECT * FROM admin"). Tables [0]. DefaultView;
7. GirdView1.DataBind ();
8. }
9. }

Protected void Page_Load (object sender, EventArgs e) {if (! IsPostBack) {MySqlClass mysqlClass = new MySqlClass (); GirdView1. DataSource = mysqlClass. GetDataSet ("SELECT * FROM admin"). Tables [0]. DefaultView; GirdView1.DataBind ();}}

This is a simple example of ASP. NET accessing the MySql database.

Of course, you can also insert data, modify data, and perform other operations on the MySql database!

I will not write it here