asp.net操作mysql数据库的教程视频|ASP.NET操作MySql数据库的教程

时间:2020-12-16  来源: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, CommandType commandtype,stringcommandText)     {       returnExecuteNonQuery(connectionString, commandtype, commandText,null);     }     publicstaticintExecuteNonQuery(stringconnectionString, CommandType commandtype,stringcommandText,paramsMySqlParameter[] commandParameters)     {       if(string.IsNullOrEmpty(connectionString))       {         thrownewException("connectionString exception");       }       intresult = 0;       MySqlConnection con =null;       try       {         using(con =newMySqlConnection(connectionString))         {           con.Open();           MySqlCommand command =newMySqlCommand(commandText, con);           command.CommandType = commandtype;           result = command.ExecuteNonQuery();         }         returnresult;       }       catch(Exception ex)       {         throwex;       }       finally       {         if(con.State == ConnectionState.Open)         {           con.Close();         }       }     }   }   protectedvoidPage_Load(objectsender, EventArgs e)   {     stringconnectionString ="server=localhost;uid=root;pwd=;database=zentaopro;";     LogManage_SqlDate.WriteLog("connectionString=:"+ connectionString);     stringsql ="insert user(account) values("china2")";     MySqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, sql);     Console.Read();   } }

asp.net操作mysql数据库的教程视频|ASP.NET操作MySql数据库的教程

http://m.bbyears.com/shujuku/116881.html

推荐访问:
相关阅读 猜你喜欢
本类排行 本类最新