コード例 #1
0
 private void delete_Click(object sender, EventArgs e)
 {
     MSAConnection.execute("delete from contact where id=" + id);
     MessageBox.Show("Eliminado Exitosamente!!");
     Form1.load();
     Dispose();
 }
コード例 #2
0
ファイル: Form1.cs プロジェクト: evilnapsis/crud-msa
        public static void load()
        {
            ContactForm.data.Rows.Clear();
            OleDbDataReader r = MSAConnection.read("select * from contact");

            while (r.Read())
            {
                ContactForm.data.Rows.Add(r.GetInt32(0), r.GetString(1), r.GetString(2), r.GetString(3), r.GetString(4));
            }
        }
コード例 #3
0
 private void ok_Click(object sender, EventArgs e)
 {
     if (firstname.Text != "")
     {
         if (action == "add")
         {
             MSAConnection.execute("insert into contact (firstname,lastname,address,email,phone) values (\"" + firstname.Text + "\",\"" + lastname.Text + "\",\"" + address.Text + "\",\"" + email.Text + "\",\"" + phone.Text + "\")");
             firstname.Text = lastname.Text = address.Text = phone.Text = email.Text = "";
             MessageBox.Show("Agregado Exitosamente!!");
         }
         else if (action == "update")
         {
             MSAConnection.execute("update contact set firstname=\"" + firstname.Text + "\",lastname=\"" + lastname.Text + "\",address=\"" + address.Text + "\",email=\"" + email.Text + "\",phone=\"" + phone.Text + "\" where id=" + id);
             //firstname.Text = lastname.Text = address.Text = phone.Text = email.Text = "";
             MessageBox.Show("Actualizado Exitosamente!!");
         }
     }
     else
     {
         MessageBox.Show("Campos Obligatorio: Nombre");
     }
 }
コード例 #4
0
        public ContactForm()
        {
            InitializeComponent();



            if (action == "update")
            {
                OleDbDataReader r = MSAConnection.read("select * from contact where id=" + id);
                while (r.Read())
                {
                    firstname.Text = r.GetString(1);
                    lastname.Text  = r.GetString(2);
                    address.Text   = r.GetString(3);
                    email.Text     = r.GetString(5);
                    phone.Text     = r.GetString(4);
                    break;
                }
            }
            else if (action == "add")
            {
                delete.Enabled = false;
            }
        }