ASP.NET操作MySql数据库的教程

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();

  }

}