public void deleteProfile(EdittingProfile ed, string m) { string dbprovider = getDBprovider(); OleDbConnection conn = new OleDbConnection(dbprovider); try { string query = "delete from [users] where [email]='" + m + "'"; conn.Open(); OleDbCommand cmd = new OleDbCommand(query, conn); DialogResult dialogResult = MessageBox.Show("if you Sure you want to delete this domain prees yes else press no", "Some Title", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { cmd.ExecuteNonQuery(); MessageBox.Show("successful deleting:)"); MainForm mf = new MainForm(c); ed.Hide(); mf.Show(); } else { ed.Show(); } conn.Close(); } catch (Exception ex) { throw ex; } }
public void getDataFromUser(EdittingProfile ed, string Mail) { string dbprovider = m.getDBprovider(); String strSql = "SELECT * FROM [users] WHERE [email]= '" + Mail + "'"; OleDbConnection conn = new OleDbConnection(dbprovider); MySearchList sl = new MySearchList(this); conn.Open(); OleDbCommand cmd = new OleDbCommand(strSql, conn); OleDbDataReader reader = cmd.ExecuteReader(); }
public void profileToDelete(EdittingProfile ed, string mail) { m.deleteProfile(ed, mail); }