Esempio n. 1
0
 private void btnField_Click(object sender, EventArgs e)
 {
     nf             = new frmNewField();
     nf.Owner       = this;
     nf.FormClosed += Nf_FormClosed;
     nf.Show();
 }
Esempio n. 2
0
 private void Nt_FormClosed(object sender, FormClosedEventArgs e)
 {
     nt = null;
     if (lblCurrentTable.Text != null)
     {
         primary = false;
         frmMain fm = ((frmMain)(this.Owner));
         myTB           = myDB.CreateTableDef(lblCurrentTable.Text);
         nf             = new frmNewField();
         nf.Owner       = this;
         nf.FormClosed += Nf_FormClosed;
         nf.Show();
     }
 }
Esempio n. 3
0
        private void save_new_field()
        {
            ListViewItem to_add;
            string       datatype = "";
            string       index    = "";

            nf = null;
            MessageBox.Show(fieldtype + " is the datatype");
            switch (fieldtype)
            {
            case 0:
                myFL     = myTB.CreateField(Field_Name, DataTypeEnum.dbText, 100);
                datatype = "Text";
                myTB.Fields.Append(myFL);
                break;

            case 1:
                myFL     = myTB.CreateField(Field_Name, DataTypeEnum.dbLong);
                datatype = "Number";
                myTB.Fields.Append(myFL);
                break;

            case 2:
                myFL     = myTB.CreateField(Field_Name, DataTypeEnum.dbDate);
                datatype = "DateTime";
                myTB.Fields.Append(myFL);
                break;

            case 3:
                myFL     = myTB.CreateField(Field_Name, DataTypeEnum.dbCurrency);
                datatype = "Currency";
                myTB.Fields.Append(myFL);
                break;

            case 4:
                myFL     = myTB.CreateField(Field_Name, DataTypeEnum.dbBoolean);
                datatype = "YesNo";
                myTB.Fields.Append(myFL);
                break;

            case 5:
                myFL     = myTB.CreateField(Field_Name, DataTypeEnum.dbLong);
                datatype = "AutoNumber";
                myTB.Fields.Append(myFL);
                myFL.Attributes = (int)FieldAttributeEnum.dbAutoIncrField;
                break;
            }
            if (!primary)
            {
                if (MessageBox.Show("Is this primary key?", "Index", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    Index myInd = myTB.CreateIndex("PrimaryKey");
                    myFL = myInd.CreateField(Field_Name);
                    ((IndexFields)myInd.Fields).Append(myFL);
                    myInd.Primary = true;
                    myTB.Indexes.Append(myInd);
                    index   = "Primary";
                    primary = true;
                }
            }
            to_add = new ListViewItem(index);
            to_add.SubItems.Add(Field_Name);
            to_add.SubItems.Add(datatype);
            lstview_current_table.Items.Add(to_add);
        }