Beispiel #1
0
        private async void DEP_ISERT_OK_Click(object sender, EventArgs e)
        {
            if (label23.Visible)
            {
                label23.Visible = false;
            }

            if (!string.IsNullOrEmpty(DepNameSet.Text) && !string.IsNullOrWhiteSpace(DepNameSet.Text) &&
                !string.IsNullOrEmpty(DepLocSet.Text) && !string.IsNullOrWhiteSpace(DepLocSet.Text))
            {
                SqlCommand command = new SqlCommand("INSERT INTO [Department](Name,Location)Values(@Name, @Location)", sqlconnection);

                command.Parameters.AddWithValue("Name", DepNameSet.Text);
                command.Parameters.AddWithValue("Location", DepLocSet.Text);
                await command.ExecuteNonQueryAsync();

                DepLocSet.Clear();
                DepNameSet.Clear();
            }
            else
            {
                label23.Visible = true;
                label23.Text    = "поля введены не коректно";
            }
        }
Beispiel #2
0
 private void DEP_ISERT_CANCEL_Click(object sender, EventArgs e)
 {
     DepLocSet.Clear();
     DepNameSet.Clear();
     label23.Visible = false;
 }