asp.net网站连接mysql(mysql删除数据库命令)

mysql有个dll，引入项目里面就可以创建mysql连接对象。MySql.Data.dll//Mysql驱动。去网上下载。给你个MySQL的DBHelper类MySqlDBHelper.cs------------------------------usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data;usingMySql.Data.MySqlClient;namespaceMySQLDB{publicclassMySqlDBHelper{//引导数据库连接数据库调用Web.Config文件privatestaticMySqlConnectionconnection;//创建连接publicstaticMySqlConnectionConnection{get{MySqlConnectionmyConn=newMySqlConnection("server=localhost;userid=root;password=root;database=vn_site;CharSet=utf8;");stringconnectionString=myConn.ConnectionString;if(connection==null){connection=newMySqlConnection(connectionString);//打开连接connection.Open();}elseif(connection.State==System.Data.ConnectionState.Closed){connection.Open();}elseif(connection.State==System.Data.ConnectionState.Broken){connection.Close();connection.Open();}returnconnection;}}//（无参）返回执行的行数(删除修改更新)publicstaticintExecuteCommand(stringsafeSql){MySqlCommandcmd=newMySqlCommand(safeSql,Connection);intresult=cmd.ExecuteNonQuery();returnresult;}//（有参）publicstaticintExecuteCommand(stringsql,paramsMySqlParameter[]values){MySqlCommandcmd=newMySqlCommand(sql,Connection);cmd.Parameters.AddRange(values);returncmd.ExecuteNonQuery();}//（无参）返回第一行第一列(删除修改更新)publicstaticintGetScalar(stringsafeSql){MySqlCommandcmd=newMySqlCommand(safeSql,Connection);intresult=Convert.ToInt32(cmd.ExecuteScalar());returnresult;}//（有参）publicstaticintGetScalar(stringsql,paramsMySqlParameter[]values){MySqlCommandcmd=newMySqlCommand(sql,Connection);cmd.Parameters.AddRange(values);intresult=Convert.ToInt32(cmd.ExecuteScalar());returnresult;}//返回一个DataReader（查询）publicstaticMySqlDataReaderGetReader(stringsafeSql){MySqlCommandcmd=newMySqlCommand(safeSql,Connection);MySqlDataReaderreader=cmd.ExecuteReader();returnreader;}publicstaticMySqlDataReaderGetReader(stringsql,paramsMySqlParameter[]values){MySqlCommandcmd=newMySqlCommand(sql,Connection);cmd.Parameters.AddRange(values);MySqlDataReaderreader=cmd.ExecuteReader();returnreader;}//返回一个DataTablepublicstaticDataTableGetDataSet(stringsafeSql){DataSetds=newDataSet();MySqlCommandcmd=newMySqlCommand(safeSql,Connection);MySqlDataAdapterda=newMySqlDataAdapter(cmd);da.Fill(ds);returnds.Tables[0];}publicstaticDataTableGetDataSet(stringsql,paramsMySqlParameter[]values){DataSetds=newDataSet();MySqlCommandcmd=newMySqlCommand(sql,Connection);cmd.Parameters.AddRange(values);MySqlDataAdapterda=newMySqlDataAdapter(cmd);da.Fill(ds);returnds.Tables[0];}}}