代码如下:
class MySQLClass
{
private MySQLConnection conn;
public void Connection(string sqlconnection)
{
try
{
conn = new MySQLConnection(sqlconnection); //string Sqlconnection = "Provider=MySQLProv;Data Source=sql1;User Id=root;Password=123456";
conn.Open();
MessageBox.Show("数据库连接成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void DisConnection()
{
conn.Close();
MessageBox.Show("数据库关闭!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public int SqlCmd(string sqlcommand)
{
MySQLCommand cmd = new MySQLCommand(sqlcommand,conn);
return cmd.ExecuteNonQuery();
}
}
由于才开始学习编程,还望大家多多指导,我会跟着大家虚心学习!