C # operations MySQL database-----HelloWorld

The MYSQL database is connected through MySql.Data.dll, MySql.Web.dll in Visual Studio 2010,

The data is then inserted and queried.

The contents of the Program.cs file are as follows:

C # code

2. Using System;
4. Using System.Collections.Generic;
6. Using System.Linq;
8. Using System.Text;
10. Using MySql.Data.MySqlClient;
12. Using System.Data;
16. Namespace Databaseprogram
18. {
20. Class Program
22. {
24. static String mysqlconnectionstring = "SERVER=LOCALHOST;DATABASE=CSHARP; Uid=root;  Pwd=admin ";
26. static void Main (string[] args)
28. {
30. InsertData ();
32. Selectdata ();
34. }
38. //Inserting data into the database
40. public static void InsertData ()
42. {
44. Mysqlconnection conn = new Mysqlconnection (mysqlconnectionstring);
46. Mysqlcommand command;
48. Conn. Open ();
50. Try
52. {
54. Command = conn. CreateCommand ();
56. Command.commandtext = "INSERT into Phonebook (Id,name,mobile) VALUES (@id, @name, @mobile)";
58. Command.  Parameters.addwithvalue ("@id", 2);
60. Command.  Parameters.addwithvalue ("@name", "Yangjianzhou");
62. Command.  Parameters.addwithvalue ("@mobile", "1234567890");
64. Command. ExecuteNonQuery ();
66. }
68. catch (Exception)
70. {
72. }
74. finally
76. {
78. if (Conn. state = = ConnectionState.Open)
80. {
82. Conn. Close ();
84. }
86. }
88. }
92. //Read data from the database
94. public static void Selectdata ()
96. {
98. Mysqlconnection conn = new Mysqlconnection (mysqlconnectionstring);
100. Conn. Open ();
102. Mysqldatareader dataReader = null;
104. Mysqlcommand command = null;
106. Try
108. {
110. Command = conn. CreateCommand ();
112. Command.commandtext = "SELECT * from Phonebook";
114. DataReader =command. ExecuteReader ();
116. Console.WriteLine ();
118. While (Datareader.read ())
120. {
122. Console.WriteLine ("id={0}, Name={1}, Mobile={2}", Datareader.getint16 (0), datareader.getstring (1),  Datareader.getstring (2));
124. Console.WriteLine ();
126. }
128. }
130. catch (Exception)
132. {
134. }
136. finally
138. {
140. if (!datareader.isclosed)
142. {
144. Datareader.close ();
146. }
148. if (Conn. state = = ConnectionState.Open)
150. {
152. Conn. Close ();
154. }
156. }
158. }
160. }
162. }

The results of the operation are as follows:

The contents of the database are:



The query results are: