ASP.NET操作MySql数据库的实例代码讲解
一、把MySql.Data.dll放到BIN目录下。
二、这是aspx.cs的全部源码,修改参数直接运行即可!
usingMySql.Data.MySqlClient; usingSystem; usingSystem.Collections.Generic; usingSystem.Data; usingSystem.Linq; usingSystem.Web; usingSystem.Web.UI; usingSystem.Web.UI.WebControls; publicpartialclassLogin:System.Web.UI.Page { publicstaticclassMySqlHelper { publicstaticintExecuteNonQuery(stringconnectionString,CommandTypecommandtype,stringcommandText) { returnExecuteNonQuery(connectionString,commandtype,commandText,null); } publicstaticintExecuteNonQuery(stringconnectionString,CommandTypecommandtype,stringcommandText,paramsMySqlParameter[]commandParameters) { if(string.IsNullOrEmpty(connectionString)) { thrownewException("connectionStringexception"); } intresult=0; MySqlConnectioncon=null; try { using(con=newMySqlConnection(connectionString)) { con.Open(); MySqlCommandcommand=newMySqlCommand(commandText,con); command.CommandType=commandtype; result=command.ExecuteNonQuery(); } returnresult; } catch(Exceptionex) { throwex; } finally { if(con.State==ConnectionState.Open) { con.Close(); } } } } protectedvoidPage_Load(objectsender,EventArgse) { stringconnectionString="server=localhost;uid=root;pwd=;database=zentaopro;"; LogManage_SqlDate.WriteLog("connectionString=:"+connectionString); stringsql="insertuser(account)values('china2')"; MySqlHelper.ExecuteNonQuery(connectionString,CommandType.Text,sql); Console.Read(); } }
以上所述是小编给大家介绍的ASP.NET操作MySql数据库的实例代码讲解,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持!