private void deleteUser()
{
string errInsert = string.Empty;
cKoneksi koneksi = new cKoneksi();
SqlConnection conn = new SqlConnection(koneksi.konekMsSql('1'));//koneksi ke 64 db parkir
cQuery qr = new cQuery();
SqlCommand cmd = null;
try
{
conn.Open();
cmd = new SqlCommand(qr.qDeleteUserWhereUsernameAndPass(), conn);
cmd.Parameters.AddWithValue("@username", txt_username.Text);
cmd.Parameters.AddWithValue("@password", txt_password.Text);
cmd.ExecuteNonQuery();//insert ke sql
}
catch (Exception ex)
{
errInsert = ex.Message;
MessageBox.Show(errInsert, "BSI UMY", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
conn.Close();
conn.Dispose();
}
if (errInsert == string.Empty)
{
label_message.Text = "User Berahasil dihapus";
}
//string err = string.Empty;
//cQuery qr = new cQuery();
//cKoneksi koneksi = new cKoneksi();
//using (var conn = new SQLiteConnection(koneksi.LokasiSqlite()))//koneksi ke sqlite
//{
// try
// {
// conn.Open();//buka koneksi
// using (var cmd = new SQLiteCommand(conn))
// {
// using (var transaction = conn.BeginTransaction())
// {
// cmd.CommandText = qr.qDeleteUserWhereUsernameAndPass();//" Delete from user where username = @username and password = @password ";
// cmd.Parameters.Clear();
// cmd.Prepare();
// cmd.Parameters.AddWithValue("@username", txt_username.Text);
// cmd.Parameters.AddWithValue("@password", txt_password.Text);
// cmd.ExecuteNonQuery();
// transaction.Commit();
// }
// }
// }
// catch(Exception ex)
// {
// MessageBox.Show(ex.Message);
// }
// finally
// {
// conn.Close(); //tutup koneksi
// conn.Dispose();
// }
//}
//if (err == string.Empty)
//{
// MessageBox.Show("Username berhasil dihapus");
//}
}