Форум программистов [Powered by Invision Power Board]

Код

 public partial class FormBank : Form
    {
        //форматирование широкого DataSet.
        private DataSet bankDS = new DataSet("Bank");
        //Создание DataView
        private DataView myView;
        //Использывание построителей команд для упрощения настройки адаптера данных.
        private SqlCommandBuilder sqlCBCustomers;
        private SqlCommandBuilder sqlCBAccounts;
        private SqlCommandBuilder sqlCBOperations;
        //Адаптеры данных.
        private SqlDataAdapter custTableAdapter;
        private SqlDataAdapter accTableAdapter;
        private SqlDataAdapter operTableAdapter;
        //Фрматирование строки подключения.
        private string cnStr = string.Empty;
        
        public FormBank()
        {
            InitializeComponent();

            try
            {
                cnStr = ConfigurationManager.ConnectionStrings["BankSqlProvider"].ConnectionString;

                custTableAdapter = new SqlDataAdapter("Select * from Customers", cnStr);
                accTableAdapter = new SqlDataAdapter("Select * from Accounts", cnStr);
                //accTableAdapter = new SqlDataAdapter("Select Accounts.id,AccountTypes.name_acc,Customers.fio,Accounts.sum from Accounts,Customers,AccountTypes where Accounts.id_acctype=AccountTy", cnStr);
                operTableAdapter = new SqlDataAdapter("Select * from Operations", cnStr);

                sqlCBCustomers = new SqlCommandBuilder(custTableAdapter);
                sqlCBAccounts = new SqlCommandBuilder(accTableAdapter);
                sqlCBOperations = new SqlCommandBuilder(operTableAdapter);

                bankDS.Tables.Add("Customers");

                DataColumnMapping[] mappedColums ={
                                                     new DataColumnMapping("id", "Код"),
                                                     new DataColumnMapping("fio", "ФИО"),
                                                     new DataColumnMapping("address", "Адрес"),
                                                     new DataColumnMapping("phone", "Телефон"),
                                                     new DataColumnMapping("passSerNumber", "Номер и серия паспорта"),
                                                     new DataColumnMapping("identificationCode", "Идентификационный код"),
                                                     new DataColumnMapping("numberOfInsurance", "Номер страховки"),
                                                     new DataColumnMapping("id_cusType", "Тип клиента")
                                                 };
                DataTableMapping custMap = new DataTableMapping("Customers", "Клиенты", mappedColums);
                custTableAdapter.TableMappings.Clear();
                custTableAdapter.TableMappings.Add(custMap);
                
                //custTableAdapter.Fill(bankDS, "Customers");
                custTableAdapter.Fill(bankDS.Tables["Customers"]);
                accTableAdapter.Fill(bankDS, "Accounts");
                operTableAdapter.Fill(bankDS, "Operations");

                BindingSource bankBS = new BindingSource();
                bankBS.DataSource = bankDS.Tables["Customers"].DefaultView;

                dataGVCustomers.DataSource = bankBS;

                
                MessageBox.Show(bankDS.Tables["Customers"].Columns[1].ToString());
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }