public partial class Customers1DataTable : global::System.Data.TypedTableBase<Customers1Row> {

private global::System.Data.DataColumn columnIDC;

private global::System.Data.DataColumn columnCustomer_Name;

private global::System.Data.DataColumn columnCustomer_Adress;

namespace TST
{
/// <summary>
/// Логика взаимодействия для MainWindow.xaml
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
}


}
public class CustomerDataProvider
{
public TST.DataSetTST TESTDataSet;
public TST.DataSetTSTTableAdapters.Customers1TableAdapter TESTAdapter;


public CustomerDataProvider()
{
TESTDataSet = new DataSetTST();
TESTAdapter = new DataSetTSTTableAdapters.Customers1TableAdapter();
TESTAdapter.Fill(TESTDataSet.Customers1);
TESTDataSet.Customers1.Customers1RowChanged += new DataSetTST.Customers1RowChangeEventHandler(CustomersRowModified);
TESTDataSet.Customers1.Customers1RowDeleted += new DataSetTST.Customers1RowChangeEventHandler(CustomersRowModified);
}
public DataView GetCustomers()
{
return TESTDataSet.Customers1.DefaultView ;
}

void CustomersRowModified(object sender, DataSetTST.Customers1RowChangeEvent e)
{
try
{
TESTAdapter.Update(TESTDataSet.Customers1);
TESTDataSet.Customers1.AcceptChanges();
}
catch (Exception ex)
{
MessageBox.Show("Ошибка:" + ex.GetBaseException()+' '+ ex.HResult +' '+ ex.Message +' '+ex.Source );
}
}
}
} 

USE [semist]
GO
/****** Object: StoredProcedure [dbo].[NewUpdateCommand] Script Date: 12/08/2017 18:33:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[NewUpdateCommand]
(
@IDC int,
@Customer_Name nchar(20),
@Customer_Adress nchar(20),
@Original_IDC int,
@Original_Customer_Name nchar(20),
@Original_Customer_Adress nchar(20)
)
AS
SET NOCOUNT OFF;
UPDATE [Customers] SET [IDC] = @IDC, [Customer Name] = @Customer_Name, [Customer Adress] = @Customer_Adress WHERE (([IDC] = @Original_IDC) AND ([Customer Name] = @Original_Customer_Name) AND ([Customer Adress] = @Original_Customer_Adress));

--SELECT IDC, [Customer Name], [Customer Adress] FROM Customers WHERE (IDC = @IDC) 

 USE [semist]
GO
/****** Object: StoredProcedure [dbo].[NewInsertCommand] Script Date: 12/08/2017 18:34:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[NewInsertCommand]
(
@IDC int,
@Customer_Name nchar(20),
@Customer_Adress nchar(20)
)
AS
SET NOCOUNT OFF;
INSERT INTO [Customers] ([IDC], [Customer Name], [Customer Adress]) VALUES (@IDC, @Customer_Name, @Customer_Adress);

--SELECT IDC, [Customer Name], [Customer Adress] FROM Customers WHERE (IDC = @IDC)