public void display_Data()
{
//SQLiteConnection sqlite_conn;
//SQLiteCommand sqlite_cmd;
//SQLiteDataReader sqlite_datareader;
Administator A2 = new Administator();
using (SQLiteConnection sqlite_conn = new SQLiteConnection("Data Source=Login.db;Version=3;Compress=True;"))
{
sqlite_conn.Open();
using (SQLiteCommand sqlite_cmd = new SQLiteCommand("SELECT Username FROM Login where Username='******' and Password='******'", sqlite_conn))
{
sqlite_cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SQLiteDataAdapter da = new SQLiteDataAdapter(sqlite_cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
sqlite_conn.Close();
}
}
//sqlite_cmd.CommandText = "SELECT * FROM Login where Username='******'and Password='******'";
//sqlite_cmd.CommandText = "SELECT * FROM Login where Username='******' and Password='******'";
// sqlite_cmd.ExecuteNonQuery();
//DataTable dt = new DataTable();
//SQLiteDataAdapter da = new SQLiteDataAdapter(sqlite_cmd);
//da.Fill(dt);
//dataGridView1.DataSource = dt;
}
private void button4_Click(object sender, EventArgs e)
{
var result = MessageBox.Show("Do you want to delete your account ? After pressing yes you will be logout from account and your account will be remove!", "Delete Account", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
Administator A1 = new Administator();
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_dataread;
SQLiteConnection sqlite_conn1;
SQLiteCommand sqlite_cmd1;
sqlite_conn = new SQLiteConnection("Data Source=Login.db;Version=3;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "Select * from Login where Username='******' and Password='******'";
sqlite_dataread = sqlite_cmd.ExecuteReader();
if (sqlite_dataread.Read())
{
sqlite_conn.Close();
sqlite_conn1 = new SQLiteConnection("Data Source=Login.db;Version=3;Compress=True;");
sqlite_conn1.Open();
sqlite_cmd1 = sqlite_conn1.CreateCommand();
sqlite_cmd1.CommandText = "Delete from Login where Username='******' and Password='******'";
sqlite_cmd1.ExecuteNonQuery();
sqlite_conn1.Close();
i = 1;
this.Hide();
this.Close();
}
else
{
i = 0;
sqlite_conn.Close();
MessageBox.Show("Username and Password is incorrect!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
