CREATE TABLE [dbo].[Addresses] (
	[AddressesID] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[Address] [varchar] ( 200 
	[PostalCode] [int] NULL ,
	[Parish] [varchar] ( 50 )
	[District] [varchar] ( 20 ) )

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
//my namespaces
using System.Data.SqlClient;

namespace Elections
{
    public partial class frmAddresses : Form
    {
        private DataSet dstAddresses;
        private SqlDataAdapter adpAddresses;
        private CurrencyManager cmAddresses;
        private DataTable addressesTable;
       
        public frmMainMenu objmainmenu;
        public frmAddresses()
        {
            InitializeComponent();
     
            adpAddresses = new SqlDataAdapter
                ("select * from Addresses",
                "server=local;database=Elections;uid=sa;pwd=hopgo");

            SqlCommandBuilder builder = new SqlCommandBuilder(adpAddresses);
   
            dstAddresses = new DataSet("AddressesDataSet");
            adpAddresses.Fill(dstAddresses, "Addresses");
            addressesTable = dstAddresses.Tables["Addresses"];
            dgdAddresses_1.DataSource = dstAddresses.Tables["Addresses"];//.DefaultView;
        }

        private void frmAddresses_Load(object sender, EventArgs e)
        {
            txtAddressID.DataBindings.Add("Text", dstAddresses, "Addresses.AddressesID");
            txtAddress.DataBindings.Add("Text", dstAddresses, "Addresses.Address");
            txtPostalCode.DataBindings.Add("Text", dstAddresses, "Addresses.PostalCode");
            txtParish.DataBindings.Add("Text", dstAddresses, "Addresses.Parish");
            txtDistrict.DataBindings.Add("Text", dstAddresses, "Addresses.District");

            cmAddresses = (CurrencyManager)BindingContext[dstAddresses, "Addresses"];
         }
  
        private void dgdAddresses_1_SelectionChanged(object sender, EventArgs e)
        {
         // возможно здесь нужен код обрабатывающии й момоент перехода на след строку
        }

        private void btnAddressAdd_Click(object sender, EventArgs e)
        {
           try
           {   
             cmAddresses.AddNew();
           }
           catch (Exception ex)
           {
             MessageBox.Show(ex.Message, "Add failed!",
             MessageBoxButtons.OK, MessageBoxIcon.Error);
           }
        }
        private void btnAddressEdit_Click(object sender, EventArgs e)
        {
            cmAddresses.EndCurrentEdit();
            cmAddresses.Refresh();
        }
        private void btnAddressDelete_Click(object sender, EventArgs e)
        {
            if (cmAddresses.Count >  0 )
            {
                cmAddresses.RemoveAt(cmAddresses.Position);

            }
            else MessageBox.Show("No Address to Delete!", "Delete Address",
                                 MessageBoxButtons.OK, MessageBoxIcon.Error);
        }
        private void btnAddressSave_Click(object sender, EventArgs e)
        {
            UpdateDB();
        }
        private void btnAddressPrior_Click(object sender, EventArgs e)
        {
            cmAddresses.Position--;
        }
                private void btnAddressNext_Click(object sender, EventArgs e)
        {
            cmAddresses.Position++;
        }
        private void UpdateDB()
        {
            if (dstAddresses.HasChanges())
                try
                {
                    adpAddresses.Update(dstAddresses, "Addresses");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "Save in DB failed!",
                    MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
        }      
      
    }
}