ASP.NET操作MySql数据库的实例代码讲解
程序员文章站
2022-11-14 11:17:31
一、把mysql.data.dll放到bin目录下。
二、这是aspx.cs的全部源码,修改参数直接运行即可!
usin...
一、把mysql.data.dll放到bin目录下。
二、这是aspx.cs的全部源码,修改参数直接运行即可!
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(); } }
以上所述是小编给大家介绍的asp.net操作mysql数据库的实例代码讲解,希望对大家有所帮助
下一篇: 详解.net循环、逻辑语句块(基础知识)