}//update_Empresa
public int delete_Empresa(Clientes_Model cliente)
{
//Abre conecção
using (MySqlCommand comando = new MySqlCommand(
"DELETE FROM clientes WHERE cod = @cod;", conexao))
{
try
{
conexao.Open();
if (conexao.State == ConnectionState.Open)
{
//Se estiver aberta insere os dados na BD
// comando.Parameters.AddWithValue("@Nome", nome.Text);// para sql usar .Parameters.Add
comando.Parameters.AddWithValue("@cod", Convert.ToInt64(cliente.cod));
comando.BeginExecuteNonQuery();
}
this.status = 0;
this.conexao.Close();
}
catch (Exception Erro)
{
this.status = 1;
this.conexao.Close();
MessageBox.Show("Impossível estabelecer conexão:" + Erro);
}
}
return(this.status);
} //delete_Empresa
}//update_user
public int delete_user(Usuarios_Model user)
{
//Abre conecção
using (MySqlCommand comando = new MySqlCommand(
"DELETE FROM usuarios " +
"WHERE chave = @Chave AND usuario = @Email; ", conexao))
{
try
{
conexao.Open();
if (conexao.State == ConnectionState.Open)
{
//Se estiver aberta insere os dados na BD
// comando.Parameters.AddWithValue("@Nome", nome.Text);// para sql usar .Parameters.Add
comando.Parameters.AddWithValue("@Email", user.login);
comando.Parameters.AddWithValue("@Chave", user.chave);
comando.BeginExecuteNonQuery();
}
status = 0;
conexao.Close();
}
catch (Exception Erro)
{
status = 1;
conexao.Close();
MessageBox.Show("Impossível estabelecer conexão:" + Erro);
}
}
return(this.status);
}//delete_user
protected void ExecuteQuery(string query, MySqlConnection c)
{
MySqlCommand cmd = new MySqlCommand(query, c);
cmd.BeginExecuteNonQuery();
cmd.Dispose();
}
public static void AgregarCliente()
{
Console.Clear();
try
{
Console.WriteLine("Nombre del Cliente");
string nombre = Console.ReadLine();
Console.WriteLine("Direccion: ");
string direccion = Console.ReadLine();
Console.WriteLine("Correo");
string coreo = Console.ReadLine();
int CantidadFacturas = 0;
MySqlCommand insertar = new MySqlCommand(string.Format("insert into Clientes (nombreCliente,direccion,correo,cantidadFacuras) values ('{0}','{1}','{2}',{3})", nombre, direccion, coreo, CantidadFacturas), connection.conectar());
insertar.BeginExecuteNonQuery();
Console.Clear();
Console.WriteLine("Agregar otro cliente? \n 1-Si \n 2-No");
int resp = int.Parse(Console.ReadLine());
if (resp == 1)
{
Console.Clear();
AgregarCliente();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
AgregarCliente();
}
}
public void FLUSH_PRIVILEGES(MySqlConnection LigacaoDB)
{
MySqlCommand CMD_FLUSH = new MySqlCommand();
string QRY_FLUSH_PRIVILEGES = "FLUSH PRIVILEGES;";
CMD_FLUSH.Connection = LigacaoDB;
CMD_FLUSH.CommandText = QRY_FLUSH_PRIVILEGES;
try
{
IAsyncResult Working = CMD_FLUSH.BeginExecuteNonQuery(null, null);
while (!Working.IsCompleted)
{
// Accções Adicionais
}
CMD_FLUSH.EndExecuteNonQuery(Working);
}
catch
{
throw;
}
}
/// <summary>
/// 异步执行
/// </summary>
public static void CommandAsyn()
{
MySqlConnectionStringBuilder mySqlConnectionStringBuilder = new MySqlConnectionStringBuilder();
//服务器地址
mySqlConnectionStringBuilder.Server = "localhost";
//端口号
mySqlConnectionStringBuilder.Port = 3306;
//指定数据库
mySqlConnectionStringBuilder.Database = "test";
//用户名
mySqlConnectionStringBuilder.UserID = "root";
//密码
mySqlConnectionStringBuilder.Password = "******";
using (MySqlConnection sqlConnection = new MySqlConnection(mySqlConnectionStringBuilder.ConnectionString)) {
//sql语句
string sql = "update tb_selcustomer set id=2";
MySqlCommand mySqlCommand = new MySqlCommand(sql, sqlConnection);
IAsyncResult asyncResult = mySqlCommand.BeginExecuteNonQuery();
//用于计时的变量
double time = 0;
//是否结束
while (asyncResult.IsCompleted == false)
{
time++;
Console.WriteLine("{0}s", time * 0.001);
}
if (asyncResult.IsCompleted == true)
{
Console.WriteLine("共用时{0}s", time * 0.001);
}
}
}
public void CREATE_DB_USER(string Username, int Rank)
{
try
{
MySqlCommand CMD_CREATE_USER = new MySqlCommand("site_tvtuga_app_admin_users._SP_INSERT_AdminUsers", LigacaoDB.CONNECTION);
CMD_CREATE_USER.CommandType = CommandType.StoredProcedure;
CMD_CREATE_USER.Parameters.AddWithValue("_username", Username);
CMD_CREATE_USER.Parameters.AddWithValue("_rank", Rank);
LigacaoDB.OPEN_CONNECTION();
CMD_CREATE_USER.Prepare();
IAsyncResult Working_CreateUser = CMD_CREATE_USER.BeginExecuteNonQuery(null, null);
//while (!Working_CreateUser.IsCompleted)
//{
// Accções Adicionais
//}
CMD_CREATE_USER.EndExecuteNonQuery(Working_CreateUser);
}
catch (Exception EX)
{
MessageBox.Show("Ocorreu um erro. Descrição do erro: \n\n " + EX.Message + "", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
LigacaoDB.CLOSE_CONNECTION();
}
}
public void AsyncInsert(string table, Dictionary <string, object> values)
{
if (values.Count <= 0)
{
throw new Exception("Please provide atleast some data to insert.");
}
string query = string.Concat("INSERT INTO ", table, "(", string.Join(",", values.Keys), ") VALUES ");
string valuesString = string.Empty;
if (values.Count > 0)
{
foreach (KeyValuePair <string, object> entry in values)
{
valuesString = string.Concat(valuesString, "@", entry.Key, ",");
}
query = string.Concat(query, "(", valuesString.Remove(valuesString.Length - 1), ")");
}
try {
MySqlCommand cmd = new MySqlCommand(query, this.connection);
foreach (KeyValuePair <string, object> entry in values)
{
cmd.Parameters.AddWithValue("@" + entry.Key, entry.Value);
}
cmd.BeginExecuteNonQuery(new AsyncCallback(AsyncInsertCallback), cmd);
} catch { }
}
public void CREATE_TYPE(string Tipo)
{
try
{
MySqlCommand CMD_CREATE_TYPE = new MySqlCommand("site_tvtuga_app_admin_users._SP_INSERT_WebsiteTipo", LigacaoDB);
CMD_CREATE_TYPE.CommandType = CommandType.StoredProcedure;
CMD_CREATE_TYPE.Parameters.AddWithValue("_nome", Tipo);
LigacaoDB.Open();
CMD_CREATE_TYPE.Prepare();
IAsyncResult Working_CreateType = CMD_CREATE_TYPE.BeginExecuteNonQuery(null, null);
CMD_CREATE_TYPE.EndExecuteNonQuery(Working_CreateType);
}
catch (Exception EX)
{
MessageBox.Show("Ocorreu um erro. Descrição do erro: \n\n " + EX.Message + "", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
LigacaoDB.Close();
}
}
private void _RunCommandAsynchronously(string query)
{
try
{
int count = 0;
_commandExecutor = new MySqlCommand(query, _connectionHandle);
IAsyncResult result = _commandExecutor.BeginExecuteNonQuery();
while (!result.IsCompleted)
{
Console.WriteLine("Waiting ({0})", count++);
System.Threading.Thread.Sleep(500);
}
Console.WriteLine("Command complete. Affected {0} rows.",
_commandExecutor.EndExecuteNonQuery(result));
}
catch (SqlException ex)
{
Console.WriteLine("Error ({0}): {1}", ex.Number, ex.Message);
}
catch (InvalidOperationException ex)
{
Console.WriteLine("Error: {0}", ex.Message);
}
catch (Exception ex)
{
// You might want to pass these errors
// back out to the caller.
Console.WriteLine("Error: {0}", ex.Message);
}
}
public void runsqlcmd(string sqlcmd)
{
var serverName = "127.0.0.1";
var uidName = "root";
var pwdName = "1234";
var databaseName = "BDS";
string connStr = String.Format("server={0};uid={1};pwd={2};database={3}",
serverName, uidName, pwdName, databaseName);
conn = new MySqlConnection(connStr);
try
{
conn.Open();
cmd = new MySqlCommand(sqlcmd, conn);
cmd.ExecuteNonQuery();
asyncResult = cmd.BeginExecuteNonQuery();
nextTime = 5;
//timer1.Enabled = true;
start = DateTime.Now;
}
catch (Exception ex)
{
MessageBox.Show("Exception: " + ex.Message);
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
//public IAsyncResult SpBeginExecuteNonQuery(string spName, AsyncCallback callback, object stateObject, string[] parameters, params object[] values) {
// throw new NotImplementedException();
//}
//public int SpEndExecuteNonQuery(IDbCommand cmd, IAsyncResult ar) {
// throw new NotImplementedException();
//}
public void SpBeginExecuteNonQuery(string spName, Action <AsyncDbCallback <int> > callback, string[] parameters, params object[] values)
{
if (callback == null)
{
throw new ArgumentNullException(string.Format("Exec {0} Error! Callback action can not be null!!", spName));
}
MySqlConnection cnn = GetConnection();
MySqlCommand cmd = new MySqlCommand(spName, cnn);
cmd.CommandTimeout = CommandTimeout;
cmd.CommandType = CommandType.StoredProcedure;
try {
SpFillParameters(cmd, parameters, values);
AsyncDbCallback <int> context = new AsyncDbCallback <int>();
context.CallbackType = CallbackType.NonQuery;
context.DbType = IICDbType.Mysql;
context.SqlConnection = cnn;
context.SqlCommand = cmd;
cmd.BeginExecuteNonQuery(new AsyncCallback(delegate(IAsyncResult ar) {
context.ar = ar;
callback(context);
}), context);
} catch (System.Exception ex) {
cnn.Close();
throw ex;
}
}
public void ExecuteNonQuery()
{
if (Version < new Version(5, 0))
{
return;
}
execSQL("CREATE TABLE test (id int)");
execSQL("CREATE PROCEDURE spTest() BEGIN SET @x=0; REPEAT INSERT INTO test VALUES(@x); " +
"SET @x=@x+1; UNTIL @x = 300 END REPEAT; END");
MySqlCommand proc = new MySqlCommand("spTest", conn);
proc.CommandType = CommandType.StoredProcedure;
IAsyncResult iar = proc.BeginExecuteNonQuery();
int count = 0;
while (!iar.IsCompleted)
{
count++;
System.Threading.Thread.Sleep(20);
}
proc.EndExecuteNonQuery(iar);
Assert.IsTrue(count > 0);
proc.CommandType = CommandType.Text;
proc.CommandText = "SELECT COUNT(*) FROM test";
object cnt = proc.ExecuteScalar();
Assert.AreEqual(300, cnt);
}
public void AddUpdateVictimAccount(CSteamID id, decimal bounty, string lastDisplayName)
{
try
{
MySqlConnection connection = CreateConnection();
MySqlCommand command = connection.CreateCommand();
if (CheckExists(id))
{
command.CommandText = "UPDATE `" + FeexHitman.Instance.Configuration.Instance.FeexHitmanDatabase.DatabaseTableName + "` SET `bounty` = bounty + (" + bounty + "), `lastDisplayName` = @lastDisplayName, `lastUpdated` = NOW() WHERE `steamId` = '" + id.ToString() + "';";
}
else
{
command.CommandText = "INSERT IGNORE INTO `" + FeexHitman.Instance.Configuration.Instance.FeexHitmanDatabase.DatabaseTableName + "` (steamId,bounty,lastDisplayName,lastUpdated) VALUES('" + id.ToString() + "','" + bounty + "',@lastDisplayName,NOW());";
}
command.Parameters.AddWithValue("@lastDisplayName", lastDisplayName);
connection.Open();
IAsyncResult result = command.BeginExecuteNonQuery();
command.EndExecuteNonQuery(result);
connection.Close();
}
catch (Exception ex)
{
Logger.LogException(ex);
}
}
public void AsyncQuery(string query)
{
try {
MySqlCommand cmd = new MySqlCommand(query, this.connection);
cmd.BeginExecuteNonQuery(new AsyncCallback(AsyncQueryCallback), cmd);
} catch { }
}
public static List <Cliente> NuevoCliente()
{
//Cuando se conecte a la base de datos debe insertar las repuestas
List <Cliente> clientes = Cliente.PreCargarClientes();
Console.WriteLine("Nombre del Cliente");
string nombre = Console.ReadLine();
Console.WriteLine("Direccion: ");
string direccion = Console.ReadLine();
Console.WriteLine("Correo");
string coreo = Console.ReadLine();
int CantidadFacturas = 0;
Cliente unNuevoCliente = new Cliente()
{
NombreCliente = nombre,
Direccion = direccion,
Correo = coreo,
CantidadDeFacturas = CantidadFacturas
};
clientes.Add(unNuevoCliente);
MySqlCommand insertar = new MySqlCommand(string.Format("insert into Clientes (nombreCliente,direccion,correo,cantidadFacuras) values ('{0}','{1}','{2}',{3})", nombre, direccion, coreo, CantidadFacturas), connection.conectar());
insertar.BeginExecuteNonQuery();
return(clientes);
}
private void BtnHapus_Click(object sender, EventArgs e)
{
string query = "DELETE FROM kurir WHERE no_ktp = @no_ktp";
try
{
databaseConnection.Open();
MySqlCommand cmd = new MySqlCommand(query, databaseConnection);
cmd.CommandTimeout = 60;
cmd.Parameters.AddWithValue("@no_ktp", tbNoKTP.Text);
cmd.BeginExecuteNonQuery();
MessageBox.Show("Data berhasil dihapus");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
databaseConnection.Close();
}
refresh();
}
public void ExecuteNonQuery()
{
if (Version < new Version(5, 0)) return;
execSQL("CREATE TABLE test (id int)");
execSQL("CREATE PROCEDURE spTest() BEGIN SET @x=0; REPEAT INSERT INTO test VALUES(@x); " +
"SET @x=@x+1; UNTIL @x = 300 END REPEAT; END");
MySqlCommand proc = new MySqlCommand("spTest", conn);
proc.CommandType = CommandType.StoredProcedure;
IAsyncResult iar = proc.BeginExecuteNonQuery();
int count = 0;
while (!iar.IsCompleted)
{
count++;
System.Threading.Thread.Sleep(20);
}
proc.EndExecuteNonQuery(iar);
Assert.IsTrue(count > 0);
proc.CommandType = CommandType.Text;
proc.CommandText = "SELECT COUNT(*) FROM test";
object cnt = proc.ExecuteScalar();
Assert.AreEqual(300, cnt);
}
public ActionResult creatUser(FairOrderingSystem.Models.Company comp)
{
if (ModelState.IsValid)
{
string company = comp.companyName;
string Cell = comp.cell;
string Phone = comp.phone;
string Password = comp.password;
string Email = comp.email;
string connectionString =
"Server=localhost;" +
"Database=fair;" +
"User ID=shane;" +
"Password=Gaming12;" +
"Pooling=false";
string sqlCommand = "INSERT INTO COMPANIES VALUES ('" + company + "','" + Cell + "','" + Phone + "','" + Password + "',NULL,'" + Email + "');";
MySqlConnection conn = new MySqlConnection(connectionString);
conn.Open();
MySqlCommand comm = conn.CreateCommand();
comm.CommandText = sqlCommand;
comm.BeginExecuteNonQuery();
return(View());
}
return(View("NewUser"));
}
public void CREATE_WEBSITE(string Nome, string Endereco, string Tipo)
{
try
{
GET_TYPE_ID(Tipo);
MySqlCommand CMD_CREATE_WEBSITE = new MySqlCommand("site_tvtuga_app_admin_users._SP_INSERT_Websites", LigacaoDB);
CMD_CREATE_WEBSITE.CommandType = CommandType.StoredProcedure;
CMD_CREATE_WEBSITE.Parameters.AddWithValue("_nome", Nome);
CMD_CREATE_WEBSITE.Parameters.AddWithValue("_endereco", Endereco);
CMD_CREATE_WEBSITE.Parameters.AddWithValue("_tipo", TYPE_ID);
if (LigacaoDB.State == ConnectionState.Closed)
{
LigacaoDB.Open();
}
CMD_CREATE_WEBSITE.Prepare();
IAsyncResult Working_CreateWebsite = CMD_CREATE_WEBSITE.BeginExecuteNonQuery(null, null);
CMD_CREATE_WEBSITE.EndExecuteNonQuery(Working_CreateWebsite);
}
catch (Exception EX)
{
MessageBox.Show("Ocorreu um erro. Descrição do erro: \n\n " + EX.Message + "", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
LigacaoDB.Close();
}
}
private void nonQueryGo_Click(object sender, System.EventArgs e)
{
string connStr = String.Format("server={0};uid={1};pwd={2};database={3}",
server.Text, uid.Text, pwd.Text, database.Text);
conn = new MySqlConnection(connStr);
try
{
conn.Open();
string sql = "DROP TABLE IF EXISTS AsyncSampleTable; CREATE TABLE AsyncSampleTable (numVal int)";
cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "DROP PROCEDURE IF EXISTS AsyncSample;" +
"CREATE PROCEDURE AsyncSample() BEGIN " +
"set @x=0; repeat set @x=@x+1; until @x > 5000000 end repeat; " +
"INSERT INTO AsyncSampleTable VALUES (1); end;";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
cmd.CommandText = "AsyncSample";
cmd.CommandType = CommandType.StoredProcedure;
asyncResult = cmd.BeginExecuteNonQuery();
nextTime = 5;
timer1.Enabled = true;
start = DateTime.Now;
}
catch (Exception ex)
{
MessageBox.Show("Exception: " + ex.Message);
}
}
/// <summary>
/// Creates an account in the DB.
/// </summary>
/// <param name="AccountName">The accountname.</param>
/// <param name="Password">The password.</param>
public static void CreateAccount(string AccountName, string Password)
{
MySqlCommand Command = new MySqlCommand("INSERT INTO Accounts(AccountName, Password) VALUES('" +
AccountName + "', '" + Password + "')");
Command.BeginExecuteNonQuery(new AsyncCallback(EndCreateAccount), Command);
}
public void DELETE_DB_USER(int UserID)
{
try
{
// REMOVER ADMIN
MySqlCommand CMD_DELETE_ADMIN = new MySqlCommand("site_tvtuga_app_admin_users._SP_DELETE_AdminUsers", LigacaoDB.CONNECTION);
CMD_DELETE_ADMIN.CommandType = CommandType.StoredProcedure;
CMD_DELETE_ADMIN.Parameters.AddWithValue("_id", UserID);
// REMOVER ADMIN CONFIG
MySqlCommand CMD_DELETE_ADMIN_CONFIG = new MySqlCommand("site_tvtuga_app_admin_users._SP_DELETE_AdminConfig", LigacaoDB.CONNECTION);
CMD_DELETE_ADMIN_CONFIG.CommandType = CommandType.StoredProcedure;
CMD_DELETE_ADMIN_CONFIG.Parameters.AddWithValue("_id", UserID);
// REMOVER ADMIN SQL
MySqlCommand CMD_DELETE_ADMIN_SQL = new MySqlCommand("site_tvtuga_app_admin_users._SP_DELETE_SQLUsers", LigacaoDB.CONNECTION);
CMD_DELETE_ADMIN_SQL.CommandType = CommandType.StoredProcedure;
CMD_DELETE_ADMIN_SQL.Parameters.AddWithValue("_id", UserID);
LigacaoDB.OPEN_CONNECTION();
CMD_DELETE_ADMIN.Prepare();
CMD_DELETE_ADMIN_CONFIG.Prepare();
CMD_DELETE_ADMIN_SQL.Prepare();
IAsyncResult Working_DeleteAdminSQL = CMD_DELETE_ADMIN_SQL.BeginExecuteNonQuery(null, null);
CMD_DELETE_ADMIN_SQL.EndExecuteNonQuery(Working_DeleteAdminSQL);
IAsyncResult Working_DeleteAdminConfig = CMD_DELETE_ADMIN_CONFIG.BeginExecuteNonQuery(null, null);
CMD_DELETE_ADMIN_CONFIG.EndExecuteNonQuery(Working_DeleteAdminConfig);
IAsyncResult Working_DeleteAdmin = CMD_DELETE_ADMIN.BeginExecuteNonQuery(null, null);
CMD_DELETE_ADMIN.EndExecuteNonQuery(Working_DeleteAdmin);
using (RegistryKey Chave = Registry.CurrentUser.OpenSubKey(@"Software\Microsoft\Windows\Roaming\OptionsConfig\AppUsers", true))
{
foreach (string User in Chave.GetValueNames())
{
if (User.Substring(2) == LISTVIEW_CONTAS.SelectedItems[0].Text)
{
Chave.DeleteValue(User);
Chave.SetValue(User, "");
}
}
}
}
catch (Exception EX)
{
MessageBox.Show("Ocorreu um erro. Descrição do erro: \n\n " + EX.Message + "", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
LigacaoDB.CLOSE_CONNECTION();
}
}
public void inserir(string nome, string pessoa, string cnpj)
{
if (bdConn.State == ConnectionState.Open)
{
MySqlCommand commS = new MySqlCommand("INSERT INTO consumidores VALUES(nome,pessoa,cnpj);", bdConn);
commS.BeginExecuteNonQuery();
}
}
public void inserir(string codigo, string leituraAtual, string leituraAnterior, string num)
{
if (bdConn.State == ConnectionState.Open)
{
MySqlCommand commS = new MySqlCommand("INSERT INTO consumidores VALUES(cpf,'0000000000','Leonardo');", bdConn);
commS.BeginExecuteNonQuery();
}
}
public void creerNouvelleUtilisateur(string taux)
{
MySqlCommand cmd = this.connection.CreateCommand();
cmd.CommandText = "INSERT INTO users(taux) VALUES (@taux)";
cmd.Parameters.AddWithValue("@taux", taux);
cmd.BeginExecuteNonQuery();
}
public static void GuardarDetalle(List <DetalleFactura> df)
{
foreach (var i in df)
{
MySqlCommand insertar = new MySqlCommand(string.Format("insert into DetalleFactura (numeroFactura,nombreProducto,cantidadVendida,precioProducto) values('{0}','{1}',{2},{3}); ", i.NumeroFactura, i.NombreProducto, i.CantidadDelProducto, i.Precio), connection.conectar());
insertar.BeginExecuteNonQuery();
}
}
public static void GuardarFactura(Factura facturas)
{
string user = facturas.UsuarioQueLaGenero;
string cliente = facturas.NombreCliente;
double monto = facturas.Monto;
MySqlCommand insertar = new MySqlCommand(string.Format("insert into Facturas (usuariQueLaGenero,cliente,Monto) values('{0}','{1}',{2}); ", user, cliente, monto), connection.conectar());
insertar.BeginExecuteNonQuery();
}
public void AsyncQuery(string query)
{
try
{
MySqlCommand cmd = new MySqlCommand(query, OpenConnection());
cmd.BeginExecuteNonQuery(AsyncQueryCallback, cmd);
}
catch { }
}
public void UPDATE_USER(MySqlConnection LigacaoDB, string ID, string Username, string Password)
{
//MySqlCommand CMD_UPDATE_USER = new MySqlCommand("SP_UPDATE_UTILIZADOR", LigacaoDB);
//CMD_UPDATE_USER.CommandType = CommandType.StoredProcedure;
//CMD_UPDATE_USER.Parameters.AddWithValue("_username", ID);
//CMD_UPDATE_USER.Parameters.AddWithValue("_newname", Username);
//CMD_UPDATE_USER.Parameters.AddWithValue("_password", Password);
MySqlCommand CMD_UPDATE_USER = new MySqlCommand();
CMD_UPDATE_USER.Connection = LigacaoDB;
CMD_UPDATE_USER.CommandText = "RENAME USER '" + ID + "'@'%' TO '" + Username + "'@'%';";
MySqlCommand CMD_UPDATE_PASS = new MySqlCommand();
CMD_UPDATE_PASS.Connection = LigacaoDB;
CMD_UPDATE_PASS.CommandText = "SET PASSWORD FOR '" + Username + "'@'%' = PASSWORD('" + Password + "');";
LigacaoDB.Open();
CMD_UPDATE_USER.Prepare();
try
{
IAsyncResult Working_UpdateUser = CMD_UPDATE_USER.BeginExecuteNonQuery(null, null);
while (!Working_UpdateUser.IsCompleted)
{
// Accções Adicionais
}
CMD_UPDATE_USER.EndExecuteNonQuery(Working_UpdateUser);
FuncoesDB.FLUSH_PRIVILEGES(LigacaoDB);
IAsyncResult Working_UpdatePass = CMD_UPDATE_PASS.BeginExecuteNonQuery(null, null);
while (!Working_UpdatePass.IsCompleted)
{
// Accções Adicionais
}
CMD_UPDATE_PASS.EndExecuteNonQuery(Working_UpdatePass);
FuncoesDB.FLUSH_PRIVILEGES(LigacaoDB);
}
catch
{
throw;
}
finally
{
LigacaoDB.Close();
}
}
public MysqlConnection()
{
MySqlConnection bdConn = new MySqlConnection("server=localhost;database=TEST;uid=root");
bdConn.Open();
MySqlCommand commS = new MySqlCommand("INSERT INTO PAH VALUES('teste1')", bdConn);
commS.BeginExecuteNonQuery();
}
