コード例 #1
0
        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;
            }
        }
コード例 #2
0
        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();
        }
コード例 #3
0
 public void profileToDelete(EdittingProfile ed, string mail)
 {
     m.deleteProfile(ed, mail);
 }