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数据库的实例代码讲解，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持！