private void Form1_Load(object sender, System.EventArgs e)
{
	try
	{
		daGoods.Fill(ds.Tables["Goods"]);
		daNacladnye.Fill(ds.Tables["Nacladnye"]);
	}
	catch(Exception ex)
	{
		MessageBox.Show(ex.Message);
		return;
	}

	DataRelation rel1 = new DataRelation("DataRelation1", ds.Tables["Nacladnye"].Columns["idNacl"], ds.Tables["Goods"].Columns["idNacl"]);
	// Add the relation to the DataSet.
	ds.Relations.Add(rel1);
}

private void but_Del_Click(object sender, System.EventArgs e)
{
	ListViewItem lvi = listView1.SelectedItems[ 0 ];
	try
	{
		DataRowCollection rc = ds.Tables["Nacladnye"].Rows;
		rc[lvi.Index].Delete();
		ds.Tables["Nacladnye"].AcceptChanges();
	}
	catch(Exception ex)
	{
		MessageBox.Show(ex.Message.ToString());
	}
	udateListView();
}

private void but_Update_Click(object sender, System.EventArgs e)
{
	daNacladnye.Update(ds,"Nacladnye");
	daGoods.Update(ds,"Goods");
	udateListView();
}

oleDbDeleteCommand1.CommandText = "DELETE FROM Nacladnye WHERE (idNacl = ?) AND (Caption = ? OR ? IS NULL AND Caption IS NULL)";
oleDbUpdateCommand1.CommandText = "UPDATE Nacladnye SET Caption = ? WHERE (idNacl = ?) AND (Caption = ? OR ? IS NULL AND Caption IS NULL)";

private void daNacladnye_RowUpdated(object sender, System.Data.OleDb.OleDbRowUpdatedEventArgs args)
{
	// Include a variable and a command to retrieve the identity value from the Access database.
	int newID =  0 ;
	OleDbCommand idCMD = new OleDbCommand("SELECT @@IDENTITY", oleDbConnection1);
	if (args.StatementType == StatementType.Insert)
	{
		// Retrieve the identity value and store it in the ID column.
		newID = (int) idCMD.ExecuteScalar();
		args.Row["idNacl"] = newID;
	}

			// oleDbDeleteCommand1
			// 
			this.oleDbDeleteCommand1.CommandText = "DELETE FROM Goods WHERE (idNum = ?) 
AND (Col = ? OR ? IS NULL AND Col IS NULL) AND (Naim = ? OR ? IS NULL AND Naim IS NULL)";
			this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_idNum",
 System.Data.OleDb.OleDbType.Integer,  0 , System.Data.ParameterDirection.Input, false, ((System.Byte)( 0 )), ((System.Byte)( 0 )),
 "idNum", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Col",
 System.Data.OleDb.OleDbType.Integer,  0 , System.Data.ParameterDirection.Input, false, ((System.Byte)( 0 )), ((System.Byte)( 0 )), "Col", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Col1", 
System.Data.OleDb.OleDbType.Integer,  0 , System.Data.ParameterDirection.Input, false, ((System.Byte)( 0 )), ((System.Byte)( 0 )), "Col", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Naim", System.Data.OleDb.OleDbType.VarWChar,  50 , System.Data.ParameterDirection.Input, false,
 ((System.Byte)( 0 )), ((System.Byte)( 0 )), "Naim", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Naim1", System.Data.OleDb.OleDbType.VarWChar,  50 , System.Data.ParameterDirection.Input, false, 
((System.Byte)( 0 )), ((System.Byte)( 0 )), "Naim", System.Data.DataRowVersion.Original, null));
			

		private void btnUpdateBD_Click(object sender, System.EventArgs e)
		{
			da.Update(ds,"Goods");
		}

		private void btnDelCur_Click(object sender, System.EventArgs e)
		{
			ListViewItem lvi = listView1.SelectedItems[ 0 ];
			try
			{
				ds.Tables["Goods"].Rows.RemoveAt(lvi.Index);
				ds.Tables["Goods"].AcceptChanges();
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message.ToString());
			}

DELETE FROM Goods WHERE (idNum = ?) 
AND (Col = ? OR ? IS NULL AND Col IS NULL) AND (Naim = ? OR ? IS NULL AND Naim IS NULL)