private void mOborud_Click(object sender, EventArgs e) { fOborud frm = new fOborud(); frm.Text = mOborud.Text; frm.MdiParent = this; frm.Show(); }
private void button1_Click(object sender, EventArgs e) { fOborud fOb = new fOborud(); try { SqlCommand cmd = new SqlCommand { Connection = new SqlConnection(Properties.Settings.Default.itInventorConnectionString), CommandText = "updateOborud", CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@indPass", indPass); cmd.Parameters.AddWithValue("@objNote", txParam.Text); // параметры cmd.Parameters.AddWithValue("@cost", nuCost.Value); cmd.Parameters.AddWithValue("@objDate", dtEnter.Value.Date); cmd.Parameters.AddWithValue("@garantDate", dtGarant.Value.Date); cmd.Parameters.AddWithValue("@model", txModel.Text); cmd.Parameters.AddWithValue("@sNo", txSNo.Text); cmd.Parameters.AddWithValue("@id_us", cbUser.SelectedValue); cmd.Parameters.AddWithValue("@id_kn", cbKind.SelectedValue); cmd.Parameters.AddWithValue("@id_ps", cbPost.SelectedValue); cmd.Parameters.AddWithValue("@id_pr", cbProd.SelectedValue); cmd.Parameters.AddWithValue("@objDism", chBox_Spisan.Checked); cmd.Parameters.AddWithValue("@onRemont", cheBox_Remont.Checked); cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); MessageBox.Show("Успешно обновлено"); } catch (Exception ex) { MessageBox.Show(ex.Message); } Close(); }