ASP. NET instance code for MySql database operations, asp. netmysql
1. Put MySql. Data. dll in the BIN directory.
2. This is all the source code of aspx. cs. Modify the parameters and run them directly!
using MySql.Data.MySqlClient; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class Login : System.Web.UI.Page { public static class MySqlHelper { public static int ExecuteNonQuery(string connectionString, CommandType commandtype, string commandText) { return ExecuteNonQuery(connectionString, commandtype, commandText, null); } public static int ExecuteNonQuery(string connectionString, CommandType commandtype, string commandText, params MySqlParameter[] commandParameters) { if (string.IsNullOrEmpty(connectionString)) { throw new Exception("connectionString exception"); } int result = 0; MySqlConnection con = null; try { using (con = new MySqlConnection(connectionString)) { con.Open(); MySqlCommand command = new MySqlCommand(commandText, con); command.CommandType = commandtype; result = command.ExecuteNonQuery(); } return result; } catch (Exception ex) { throw ex; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } } } protected void Page_Load(object sender, EventArgs e) { string connectionString = "server=localhost;uid=root;pwd=;database=zentaopro;"; LogManage_SqlDate.WriteLog("connectionString=:" + connectionString); string sql = "insert user(account) values('china2')"; MySqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, sql); Console.Read(); } }
The above is a small series of ASP.. NET instance code for MySql database operations. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!