Пример #1
0
        private void RecordEdit()
        {
            //Edit user
            string cUser = dataGridView1.CurrentRow.Cells["USER_NAME"].Value.ToString();

            PowerUserForm pUserF = new PowerUserForm(this.Icon, this.Font);

            pUserF.textBox1.Text = cUser;

            var rslt = pUserF.ShowDialog();

            if (rslt == DialogResult.OK)
            {
                if (pUserF.textBox1.Text.Trim().Length > 0)
                {
                    OleDbCommand cmd = new OleDbCommand("", connection);
                    cmd.CommandText =
                        "update POWER_USERS set \n" +
                        "USER_NAME='" + MainForm.StrToSQLStr(pUserF.textBox1.Text) + "' \n" +
                        "where USER_NAME='" + MainForm.StrToSQLStr(cUser) + "'";

                    if (MainForm.cmdExecute(cmd) >= 0)
                    {
                        DS.Tables["POWER_USERS"].Clear();
                        daPowerUsers.Fill(DS, "POWER_USERS");
                    }
                }
            }
        }
Пример #2
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            //Insert new user

            PowerUserForm pUserF = new PowerUserForm(this.Icon, this.Font);

            var rslt = pUserF.ShowDialog();

            if (rslt == DialogResult.OK)
            {
                if (pUserF.textBox1.Text.Trim().Length > 0)
                {
                    OleDbCommand cmd = new OleDbCommand("", connection);
                    cmd.CommandText =
                        "insert into POWER_USERS (USER_NAME) \n" +
                        "values('" + MainForm.StrToSQLStr(pUserF.textBox1.Text) + "')";

                    if (MainForm.cmdExecute(cmd) >= 0)
                    {
                        DS.Tables["POWER_USERS"].Clear();
                        daPowerUsers.Fill(DS, "POWER_USERS");
                    }
                }
            }
        }