InitializeComponent();

}

private void clientBindingNavigatorSaveItem_Click(object sender, EventArgs e)

{

foreach (Control ctl in this.Controls)

{

if (ctl is TextBox || ctl is Label || ctl is CheckBox)

{

ctl.Enabled = false;

}

}

try

{

this.Validate();

this.clientBindingSource.EndEdit();

this.tableAdapterManager.UpdateAll(this.sale1DataSet);

}

catch (System.Data.SqlClient.SqlException s1)

{

if (s1.ErrorCode == -2146232060)

{

MessageBox.Show("Удаление записей невозможно.У данного покупателя имеются заказы", "Ошибка", MessageBoxButtons.OK);

}

}

}

private void Form3_Load(object sender, EventArgs e)

{

// TODO: данная строка кода позволяет загрузить данные в таблицу "sale1DataSet.client". При необходимости она может быть перемещена или удалена.

this.clientTableAdapter.Fill(this.sale1DataSet.client);

}

private void bindingNavigatorMoveFirstItem_Click(object sender, EventArgs e)

{

foreach (Control ctl in this.Controls)

{

if (ctl is TextBox || ctl is Label || ctl is CheckBox)

{

ctl.Enabled = false;

}

}

}

private void bindingNavigatorMovePreviousItem_Click(object sender, EventArgs e)

{

foreach (Control ctl in this.Controls)

{

if (ctl is TextBox || ctl is Label || ctl is CheckBox)

{

ctl.Enabled = false;

}

}

}

private void bindingNavigatorMoveNextItem_Click(object sender, EventArgs e)

{

foreach (Control ctl in this.Controls)

{

if (ctl is TextBox || ctl is Label || ctl is CheckBox)

{

ctl.Enabled = false;

}

}

}

private void bindingNavigatorMoveLastItem_Click(object sender, EventArgs e)

{

foreach (Control ctl in this.Controls)

{

if (ctl is TextBox || ctl is Label || ctl is CheckBox)

{

ctl.Enabled = false;

}

}

}

private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)

{

foreach (Control ctl in this.Controls)

{

if (ctl is TextBox || ctl is Label || ctl is CheckBox)

{

ctl.Enabled = false;

}

}

}

private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)

{

foreach (Control ctl in this.Controls)

{

if (ctl is TextBox || ctl is Label || ctl is CheckBox)

{

ctl.Enabled = true;

}

}

}

private void Form3_Activated(object sender, EventArgs e)

{

this.clientTableAdapter.Fill(this.sale1DataSet.client);

}

private void Form3_FormClosing(object sender, FormClosingEventArgs e)

{

DialogResult s;

this.Hide();

e.Cancel = true;

s = MessageBox.Show("Сохранить сделанные изменения в таблице покупатель?", "Внимание !", MessageBoxButtons.OKCancel);

if (s == DialogResult.OK)

{

try

{

this.Validate();

this.clientBindingSource.EndEdit();

this.tableAdapterManager.UpdateAll(this.sale1DataSet);

}

catch (System.Data.SqlClient.SqlException s1)

{

if (s1.ErrorCode == -2146232060)

{

MessageBox.Show("Удаление записей невозможно.У данного покупателя имеются заказы", "Ошибка", MessageBoxButtons.OK);

}

}

}

}

}

}

Форма Заказы:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace Проектирование_интерфесов__10

{

public partial class Form4 : Form

{

public Form4()

{